Description

You will lead database design and optimization efforts for large-scale data warehouses.

Responsibilities

• Design data warehouses and create detailed ER diagrams.
• Develop and optimize large, chained stored procedures and standard or indexed views.
• Implement archival and purging strategies for complex entity relationships.
• Solve complex data management and performance issues.
• Mentor junior developers and collaborate with the engineering team.

Required Skills

• 10+ years of hands-on SQL Server experience.
• Extensive expertise in writing complex T-SQL queries.
• Proven ability to tune performance without relying on SQL Profiler.
• Deep understanding of SQL execution plans and optimization techniques.
• Knowledge of advanced indexing, including columnstore indexes.
• Strong understanding of SQL isolation levels and their impact on queries.
• Proficiency in C++, Node.js, and T-SQL.
• Bachelor's degree.

Key Skills

Education

Bachelor's degree