Senior Database Administrator (Azure SQL Managed Instance Stabilization & Performance Specialist)
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Role:
Senior Database Administrator (Azure SQL Managed Instance – Stabilization & Performance Specialist)
Work location: Remote
Background and Meet and Greet: MANDATORY
Job Description:
- Senior Database Administrator (Azure SQL Managed Instance – Stabilization & Performance Specialist)
- Engagement Objective
- Customer needs a Senior DBA Stabilization Specialist to rapidly assess, stabilize, and optimize production workloads running on Azure SQL Managed Instance. This role is narrowly focused on performance, concurrency, and reliability—with immediate impact expected.
- This role is hands-on and has a short feedback loop. The right candidate has deep experience entering environments with existing technical debt, diagnosing locking and performance pathologies, and restoring predictable, stable behavior under load.
- Primary Outcomes (What You Will Be Accountable For)
- Within the first 30–60 days, you will:
- Identify and remediate blocking, deadlocks, lock escalation, and contention hot spots
- Establish clear performance baselines using Azure SQL MI–native tooling
- Reduce the frequency and duration of database-driven incidents
- Deliver clear, prioritized recommendations with measurable impact
- Scope of WorkRapid Performance & Locking Assessment
- Analyze Query Store, DMVs, wait stats, blocking chains, and deadlock graphs
- Identify root causes related to:
- Poor query plans
- Inefficient indexing
- Transaction scope and isolation levelstemp db contention
- Resource governance constraints in Azure SQL MIStabilization & Remediation
- Tune queries, indexes, and statistics to reduce contention and latency
- Advise on transaction boundaries and isolation strategies to mitigate blocking
- Implement tactical fixes that improve stability without requiring major application rewrites
- Address recurring performance regressions tied to deployments or batch workloads
- Production Incident Leadership
- Act as the escalation point for database-related production issues
- Lead focused root-cause analysis with clear evidence and reasoning
- Provide concise post-incident summaries oriented toward prevention, not blame
- Monitoring & Guardrails
- Establish lightweight, high-signal monitoring for:
- Lock waits and blockingCPU, IO, and memory pressure
- Query regressions
- Define actionable thresholds and early-warning indicators.
- Knowledge Transfer
- Produce clear, operator-ready documentation:
- Known failure modes
- What to watch
- What actions to take
- Coach internal engineers on performance-safe patterns
Key Responsibilities:
Required Expertise
Azure SQL Managed Instance
Deep, hands-on experience supporting production Azure SQL Managed Instance workloadsExpert understanding of:
- SQL Server locking and concurrency internalsDeadlocks, blocking chains, and lock escalationTransaction isolation levels and their real-world tradeoffsQuery execution plans and index designtempdb behavior in managed environments
- Performance Analysis SkillsFluent in using:
- Query StoreDMVs and wait statistics
- Execution plans (estimated vs actual)
- Ability to move from symptom → root cause → corrective action quickly
- Operational Mindset
- Proven experience stabilizing systems under live production load
- Comfortable operating in high-pressure environments with incomplete information
- Bias toward pragmatic, high-impact fixes over theoretical purity
- Success Criteria
- Locking and contention incidents materially decrease
- Performance regressions are detected earlier and resolved faster
- Teams have clearer guardrails for database-safe changes
What are the Mandatory skills and skill proficiencies required for this position?
Deep, hands-on experience supporting production Azure SQL Managed Instance workloadsExpert understanding of:
SQL Server locking and concurrency internalsDeadlocks, blocking chains, and lock escalationTransaction isolation levels and their real-world tradeoffsQuery execution plans and index designtempdb behavior in managed environments