Senior Sql Server Developer

Key Responsibilities:

• Design, develop, and maintain complex stored procedures, functions, views, and business logic using T-SQL.
• Analyze and optimize existing T-SQL code for performance, scalability, and maintainability.
• Conduct code reviews of legacy SQL components and implement performance improvements.
• Create and maintain optimized database schemas, with proficiency in normalization and denormalization techniques.
• Perform root cause analysis and troubleshooting of issues related to query performance, deadlocks, blocking, and long-running transactions.
• Utilize tools such as SQL Server Profiler, Execution Plans, Extended Events, DMVs, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor for performance tuning and diagnostics.
• Collaborate with application teams to design efficient data access patterns and support scalable architectures.
• Ensure data security through proper user roles, permissions, encryption techniques, and secure development practices.
• Document database designs, stored procedures, and troubleshooting steps in a clear and standardized format.
• Stay current with the latest SQL Server features and best practices, recommending adoption where relevant.

Required Qualifications:

• Minimum 7 years of experience as a SQL Server Developer.
• Expert-level knowledge of T-SQL programming, stored procedures, and performance optimization.
• Strong understanding of SQL Server internals, including indexing strategies, transaction management, and execution plans.
• Proficient in performance analysis and tuning using Profiler, Execution Plans, Extended Events, and DMVs.
• Solid grasp of database security principles, including access control and encryption.
• Proven experience working with large and complex T-SQL codebases.
• Ability to write logical, efficient, and scalable SQL code.
• Comfortable working independently as well as part of cross-functional teams.
• Strong troubleshooting and analytical skills.
• Experience working with Azure SQL Database or other cloud-based deployments.

Preferred Qualifications:

• Experience with CI/CD pipelines for managing database deployments.
• Familiarity with version control systems for database code (e.g., Git, Redgate SQL Source Control).
• Domain experience in healthcare or workforce management platforms is a plus.
• Experience with creating, populating, and maintaining data marts, with strong knowledge of data warehousing structures, including Star and Snowflake schemas.