SQL Server Experience: Minimum of 10 years of hands-on experience.
T-SQL Expertise: Extensive experience in writing complex T-SQL queries.
Stored Procedures: Proficient in developing and optimizing large and chained stored procedures.
SQL Views: Proficient in creating both standard and indexed SQL views.
Performance Tuning: Skilled in performance tuning without relying on SQL Profiler.
Database Design: Expertise in creating ER diagrams and designing data warehouses.
Data Management: Experience with archival and purging strategies in large SQL data warehouses involving numerous entity relationships.
Execution Plans: Deep understanding of SQL execution plans and optimization techniques.
Advanced Indexing: Knowledgeable in advanced SQL indexing techniques, including columnstore indexes.
Transaction Isolation: Strong understanding of SQL isolation levels and their impact on queries.
Soft Skills: Strong problem-solving skills, collaborative team players, excellent communication skills, and the ability to mentor junior developers.
Bachelor's degree