Senior SQL Server Developer Hallmark Healthcare

7.0 - 11.0 years

9 - 13 Lacs

Hyderabad

Work from Office

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. Develop and maintain error and event handling mechanisms, including precedence constraints, breakpoints, checkpoints, and logging. Experience working with data archival , job scheduling, and integration with legacy systems. 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 .

Posted 2 weeks ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.