Database Engineer II

Fabletics is seeking an experienced Database Engineer II to join their dynamic team. This role involves designing and developing scalable database structures, optimizing SQL queries, and collaborating with cross-functional teams to ensure robust database systems meet business needs.

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

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
• 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