T-SQL Developer

IQVIA; Bengaluru; Hybrid; INR 900,000 - 1,500,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

IQVIA is seeking a skilled MS SQL Developer with 4–8 years of experience for a hybrid role in Bengaluru/Kochi. The candidate will design, optimize, and maintain SQL Server solutions, develop complex T-SQL code, troubleshoot issues, and automate tasks with Python in a fast-paced production environment.

Preferred skills include PowerShell, Python, and AI familiarity. The role requires strong analytical abilities and effective collaboration with cross-functional teams.

Qualifications

• Must have SQL Database and T-SQL expertise.
• Strong hands-on experience with Microsoft SQL Server.
• Experience in SQL Server performance tuning and query optimization.
• Automation tasks using Python for data processing and support.
• Hybrid work model in Bangalore/Kochi and production environment exposure.

Responsibilities

• Design, develop, and optimize database solutions using Microsoft SQL Server.
• Develop and support complex T-SQL queries, stored procedures, functions, views, and triggers.
• Perform SQL Server performance tuning and query optimization.
• Analyze execution plans, indexing strategies, and workloads to resolve bottlenecks.
• Create and monitor SQL Server Agent Jobs.
• Troubleshoot database issues across development, testing, and production.
• Develop automation scripts using Python.
• Collaborate with application teams and stakeholders to deliver scalable solutions.
• Support deployments, maintenance, and production releases.
• Participate in weekend support activities if required.

Skills

SQL Server

T-SQL

Performance Tuning

Python scripting

Automation

Data processing

Debugging

Education

BTech/BCA/BSc/MTech/MCA/MSc

Tools

PowerShell

Azure SQL

AWS RDS

SQL Server Agent

Job description

Project Role: T-SQL Developer / Database Management Specialist

Work Experience: 4 to 8 years

Work location: Bangalore/Kochi

Work Mode: Hybrid

Must Have: SQL Database, T-SQL

Good to Have: PowerShell ,Python and AI

Job Summary

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

Required Skills & Experience

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

Microsoft SQL Server Certifications are an added advantage.

Educational Qualification

BTech/BCA/BSc/MTech/MCA/MSc