SQL Database, T-SQL Developer
Position: SQL Developer
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
- Bachelor’s Degree in Computer Science, Information Technology, Engineering, or a related field.
- Microsoft SQL Server Certifications are an added advantage.
Experience
4 to 6 Years of relevant experience in:
- MS SQL Server
- T-SQL Development
- Performance Tuning & Query Optimization
- Dynamic SQL
- Python Automation
- Production Support
Primary Skills (Must Have)
- MS SQL Server
- T-SQL Programming
- Performance Tuning & Query Optimization
- Stored Procedures & Dynamic SQL
- SQL Server Agent Jobs
- Python Automation
- Debugging & Troubleshooting
- Production Support
- Excellent Communication Skills
Keywords
SQL Server, SQL Developer, T-SQL, Performance Tuning, Query Optimization, Stored Procedures, Functions, Triggers, Dynamic SQL, SQL Server Agent Jobs, Python, Database Development.
IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more at [click to reveal website link]
IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.