Principal SQL Database Specialist (Contract)

About Client :

Our Client is a global IT services company headquartered in Southborough, Massachusetts, USA. Founded in 1996, with a revenue of $1.8B, with 35,000+ associates worldwide, specializes in digital engineering, and IT services company helping clients modernize their technology infrastructure, adopt cloud and AI solutions, and accelerate innovation. It partners with major firms in banking, healthcare, telecom, and media.

Our Client is known for combining deep industry expertise with agile development practices, enabling scalable and cost-effective digital transformation. The company operates in over 50 locations across more than 25 countries, has delivery centers in Asia, Europe, and North America and is backed by Baring Private Equity Asia.

Job Title : SQL DBA

Experience Level : 8-12 Years

Job Location : PAN India

Budget : 16 LPA

Job Type : Contract

Work Mode : Hybrid

Notice Period : Immediate Joiners

Job Description :

Mandatory skills & JD :

Conduct T-SQL code reviews and enforce best practices.

Lead performance tuning initiatives (indexing strategies, query optimization).

Develop and maintain automation scripts (PowerShell, T-SQL).

Document operational procedures and RCA reports.

Lead DR drills and ensure DR site readiness.

Mentor L1 / L2 DBAs and provide technical leadership.

Configure and maintain High Availability (HA) and Disaster Recovery (DR) solutions.

Monitor and troubleshoot SQL Server performance issues (e.G., deadlocks, blocking).

Manage and optimize scheduled jobs, backups, and maintenance plans.

Handle incidents, SCTAKS and problem tickets.

Collaborate with developers to test and optimize database performance.

Deploy database objects across environments (Dev, QA, UAT, Prod).

Participate in bridge calls for P1 / P2 incidents and assist in root cause analysis.

Perform database refreshes and environment cloning.

Set up and fine-tune alerts for performance, space, and job failures.

Respond to monitoring system alerts and take corrective actions.

Provide on-call support as part of a rotation.

Analyse growth trends and plan for future capacity needs