Description :
Job Title : Senior SQL Server Database Developer
Location : Hyderabad
Experience Level : 7-15 Years
Mode : Work From Office
Employment Type : Full-Time
NP : 15-30 days
Position Summary :
We are looking for an experienced SQL Server Developer who excels in writing and maintaining complex stored procedures, functions, and business logic within SQL Server and Azure SQL environments. The ideal candidate is adept at performance tuning, has a solid understanding of SQL Server internals, and can effectively review and optimize legacy code. This role requires close collaboration with application developers, architects, and business stakeholders to ensure that the database layer is robust, efficient, and secure.
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.(ref : hirist.tech)