Database Engineer II

Fabletics

1d•$120,000 - $130,000•Remote

About The Position

We are looking for an experienced Database Engineer II to join our dynamic team. The ideal candidate will have a deep understanding of database architecture, design, and implementation, with a focus on performance, scalability, and data integrity. This role will involve working closely with cross-functional teams to ensure the development and maintenance of robust, scalable database systems to meet business needs. As a Database Engineer II, you will join a tight knit group of key contributors who are actively working together to achieve aggressive goals and meet timelines to drive the business forward. This position will report to the Sr. Manager, Database Engineering

Requirements

Bachelor’s degree in computer science, Engineering, or a related field (master’s degree is a plus).
3+ years of experience in T-SQL programming and database systems.
3+ years of hands-on experience with SQL Server 2018 or later.
Proven track record working with high-traffic, production-level SQL Server environments.
Strong expertise in writing and optimizing complex SQL queries and stored procedures.
Experience in performing code reviews and ensuring adherence to best practices.
Excellent communication and presentation skills, with the ability to effectively convey complex data findings to non-technical stakeholders.
24x7 Production support experience supporting a high throughput Database.
Strong knowledge of normalization and denormalization strategies, and the ability to apply them as needed.
Proven ability to design, implement, and maintain data workflows and scheduled jobs.
Solid understanding of N-tier architectures, with experience in troubleshooting complex systems.

Nice To Haves

Experience in database engineering on cloud platforms such as Elastic Search, Kafka, Redis, AWS etc.
In-depth understanding of SQL Server internals, including performance tuning and optimization strategies.
Previous experience in e-commerce, retail, or internet industries.

Responsibilities

Collaborate with stakeholders to understand business requirements and provide effective, data-driven solutions to meet their needs.
Design and develop scalable, efficient database structures that align with project goals and business requirements.
Write, modify, and optimize complex SQL queries, stored procedures, and triggers to support internally hosted applications and ensure optimal performance.
Conduct comprehensive code reviews to enforce database engineering best practices, maintain high code quality, and ensure maintainability.
Manage code deployments to production systems, ensuring stability and minimizing downtime.
Proactively monitor and troubleshoot system issues such as blocking, deadlocks, and inefficient execution plans.
Analyze and refactor existing SQL code to enhance performance, scalability, and reliability.
Maintain regular communication with technical, application, and operational teams to develop new tools, features, and systems that support business growth.
Collaborate closely with software developers, analysts, and database administrators to ensure that database operations are efficient and aligned with business goals.
Assist in data integration across multiple systems and build robust data pipelines using ETL processes and cloud technologies like Kafka or AWS.
Stay current with emerging trends, tools, and technologies in database management, cloud computing, and data storage to drive innovation within the team.
Provide on-call production support on a rotating basis to ensure the availability, reliability, and performance of critical database systems.