SQL Developer - Database Performance Tuning

Description :

About the Role :

We are looking for a skilled SQL Developer to design, optimize, and maintain high-performance databases supporting mission-critical applications. This is a hands-on role requiring strong SQL Server expertise and problem-solving ability.

Key Responsibilities :

- Develop, optimize, and maintain tables, procedures, views, constraints, and indexes.

- Write and debug complex queries involving joins, sub-queries, temporary tables, and aggregate functions.

- Work with XML/JSON data handling within SQL Server environments.

- Create and enhance T-SQL functions, triggers, and stored procedures.

- Conduct performance tuning, query optimization, and indexing strategies to improve application response times.

- Collaborate with application and analytics teams to support data requirements.

- Ensure database reliability, integrity, and security across multiple SQL Server versions (2008/2012/2014/2016).

- Troubleshoot database issues, identify root causes, and implement corrective actions.

- Participate in code reviews, documentation, and process improvements.

Skills Required :

- Strong SQL and T-SQL programming skills.

- Hands-on experience with Microsoft SQL Server (20082016).

- Expertise in performance tuning, query optimization, and indexing.

- Knowledge of database architecture, stored procedures, triggers, and functions.

- Understanding of XML/JSON, temporary tables, and advanced joins.

- Ability to analyze complex datasets and optimize data workflows.

Qualifications :

- B.Tech/B.E. (Computers), MCA, M.Sc IT, or M.Tech.