Senior Database Administrator (Azure SQL Managed Instance)

Capgemini • Chicago, IL

18h

About The Position

At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world’s most innovative companies unleash their potential. From autonomous cars to life-saving robots, our digital and software technology experts think outside the box as they provide unique R&D and engineering services across all industries. Join us for a career full of opportunities. Where you can make a difference. Where no two days are the same. About the job you're considering We are seeking a highly experienced and solution‑focused Senior Database Administrator (DBA) with deep expertise in Azure SQL Managed Instance to help rapidly assess, stabilize, and optimize production workloads. This role is intentionally hands‑on and impact‑driven, ideal for someone who excels at entering complex environments, diagnosing performance pathologies, and restoring predictable behavior under heavy load. If you thrive in fast‑paced situations, enjoy solving challenging performance and concurrency issues, and are motivated by measurable outcomes, you will find this opportunity both rewarding and influential.

Requirements

• 10+ years of Core DBA experience, with significant time spent supporting high‑volume production environments.
• Bachelor’s degree in computer science or a related technical field.
• Extensive, hands‑on experience managing Azure SQL Managed Instance in production.
• Expert‑level knowledge of: SQL Server locking and concurrency internals, Blocking, deadlocks, and lock escalation patterns, Transaction isolation levels and practical tradeoffs, Query execution plans, indexing strategies, and statistics management, Tempdb architecture and behavior in managed platforms

Responsibilities

• Identify and resolve blocking, deadlocks, lock escalation patterns, and contention hot spots.
• Establish accurate performance baselines using native Azure SQL Managed Instance diagnostic tooling.
• Reduce the frequency, severity, and duration of database‑related incidents.
• Deliver clear, prioritized recommendations with measurable, high‑impact outcomes.
• Perform rapid assessments using Query Store, DMVs, wait statistics, blocking graphs, and deadlock captures.
• Diagnose root causes related to: Inefficient or unstable query plans, Missing, redundant, or suboptimal indexing, Transaction scope issues and inappropriate isolation levels, Tempdb contention, and Resource governance constraints in Azure SQL MI
• Tune queries, indexes, and statistics to reduce latency and improve throughput.
• Recommend and implement improvements to transaction boundaries and isolation strategies to reduce blocking.
• Deploy targeted fixes that improve stability without requiring large‑scale application changes.
• Investigate and address recurring performance regressions tied to deployments or batch operations.

Benefits

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level