Senior SQL Server Database Developer

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 :

Preferred Qualifications :

(ref : hirist.tech)