T-SQL Developer

IQVIA; Ernakulam; On-site; INR 900,000 - 1,500,000; Full time

Job summary

IQVIA in India seeks an MS SQL Developer with strong expertise in Microsoft SQL Server, T-SQL, performance tuning and Python. The role focuses on developing, optimizing, and maintaining database solutions in a fast-paced production environment.

Key responsibilities include designing and optimizing queries, creating and maintaining SQL Server Agent Jobs, automating tasks with Python, and collaborating with application teams to deliver scalable database solutions across development, testing, and

Qualifications

• Bachelor’s degree in computer science, Information Technology, Engineering, or a related field.
• Microsoft SQL Server Certifications are an added advantage.
• Experience with SQL Server DBA activities and cloud databases is a plus.

Responsibilities

• Design, develop, maintain, and optimize database solutions using Microsoft SQL Server.
• Develop and support complex T-SQL queries, stored procedures, functions, views, triggers, and Dynamic SQL.
• Perform SQL Server Performance Tuning and Query Optimization to improve database and application performance.
• Analyze execution plans, indexing strategies, statistics, and database workloads to identify and resolve performance bottlenecks.
• Create, schedule, monitor, and maintain SQL Server Agent Jobs.
• Troubleshoot and resolve database-related issues across development, testing, and production environments.
• Develop automation and support scripts using Python.
• Perform root cause analysis and implement permanent solutions for recurring database issues.
• Collaborate with application teams and business stakeholders to understand requirements and deliver scalable database solutions.
• Support database deployments, maintenance activities, and production releases.
• Participate in weekend support activities when required

Skills

Microsoft SQL Server

T-SQL

Query optimization

Python scripting

Automation

Debugging

Data processing

Database design principles

Education

Bachelor’s degree in Computer Science/IT/Engineering

Tools

PowerShell

Azure SQL

AWS RDS

SQL Server Agent

Job description

We are seeking a highly skilled MS SQL Developer with strong expertise in Microsoft SQL Server, T-SQL, SQL Server Performance Tuning and Python. The ideal candidate will be responsible for developing, optimizing, and maintaining database solutions, troubleshooting complex database issues, and automating operational tasks. The candidate should possess strong analytical and problem-solving skills and be comfortable working in a fast-paced production environment.

Key Responsibilities

• Design, develop, maintain, and optimize database solutions using Microsoft SQL Server
• Develop and support complex T-SQL queries, stored procedures, functions, views, triggers, and Dynamic SQL.
• Perform SQL Server Performance Tuning and Query Optimization to improve database and application performance.
• Analyze execution plans, indexing strategies, statistics, and database workloads to identify and resolve performance bottlenecks.
• Create, schedule, monitor, and maintain SQL Server Agent Jobs.
• Troubleshoot and resolve database-related issues across development, testing, and production environments.
• Develop automation and support scripts using Python.
• Perform root cause analysis and implement permanent solutions for recurring database issues.
• Collaborate with application teams and business stakeholders to understand requirements and deliver scalable database solutions.
• Support database deployments, maintenance activities, and production releases.
• Participate in weekend support activities when required

Technical Skills

• Strong hands-on experience with Microsoft SQL Server.
• Expert-level proficiency in T-SQL Programming.
• Strong experience in SQL Server Performance Tuning and Query Optimization.
• Extensive experience working with complex queries, stored procedures, functions, triggers, and Dynamic SQL.
• Good knowledge of creating, scheduling, monitoring, and maintaining SQL Server Agent Jobs.
• Experience with Python scripting for automation, data processing, and support activities.
• Strong debugging, troubleshooting, and problem-solving skills.
• Good understanding of database design principles, indexing, and SQL Server best practices.
• Experience supporting production environments and critical business applications.

Soft Skills

• Strong analytical and problem-solving abilities.
• Excellent verbal and written communication skills.
• Ability to work independently and collaboratively within a team.
• Strong ownership, accountability, and commitment to delivery.
• Willingness to work on weekends as required.

Nice-to-Have Skills (SQL Server DBA)

• Experience in SQL Server Database Administration (DBA) activities.
• Knowledge of database backup and recovery strategies.
• Experience with PowerShell scripting for automation and administrative tasks.
• Experience with database monitoring, health checks, and capacity planning.
• Understanding of database security, permissions, and user management.
• Exposure to Log Shipping
• Experience with cloud database platforms such as Azure SQL or AWS RDS.

Qualifications

Bachelor’s degree in computer science, Information Technology, Engineering, or a related field. Microsoft SQL Server Certifications are an added advantage.