Job Title: Microsoft Windows SQL Server DBA (Contract)

ROLE OVERVIEW

We are seeking an experienced Microsoft Windows SQL Server DBA to drive application performance excellence. In this role you will serve as the subject matter expert and will partner closely with application development teams, infrastructure architects, and business stakeholders to ensure database systems are available,

secure, and tuned to meet end-to-end application performance goals.

KEY RESPONSIBILITIES

- Install, configure, and maintain Microsoft SQL Server instances (2019, 2025, Azure SQL Database) across complex, multi-server Windows environments.
- End-to-end application performance engineering: analyze execution plans, identify problematic queries, and work with development teams to implement lasting optimisations at the code and schema level.
- Proactively monitor application and database performance using Extended Events, DMVs, Wait Statistics analysis, and third-party tooling; establish baselines and SLA-aligned alerting thresholds.
- Design, implement, and test robust backup and recovery strategies; own RTO/RPO targets and validate them through regular recovery drills.
- Architect and maintain HA/DR solutions including Always On Availability Groups and Log Shipping across production and DR environments.
- Manage database security: role-based access controls, auditing frameworks, and encryption strategies in line with least-privilege and regulatory requirements.
- Capacity planning and storage forecasting; collaborate with infrastructure teams to ensure database platforms scale ahead of demand.
- Database change governance: review and approve schema migrations,



deployment scripts, and ORM-generated queries before they reach production.
- Drive automation of routine DBA tasks (index maintenance, integrity checks, job monitoring) through PowerShell and SQL Agent.
- Manage SQL Server patching and upgrades through a formal change management process, including pre- and post-upgrade validation.
- Contribute to team knowledge base and runbook documentation.
- On-call rotation: response and post-incident review for database outages.

REQUIRED SKILLS & EXPERIENCE

- 5+ years of hands-on SQL Server DBA experience in large-scale, mission-critical production environments.
- Expert-level proficiency with Microsoft SQL Server 2019 / 2025 on Windows Server 2019 / 2022.
- Advanced T-SQL skills: query optimization, execution plan analysis, index design, partitioning, and performance troubleshooting.
- Deep expertise in application performance tuning: collaborating with developers to resolve ORM anti-patterns, N+1 queries, lock contention, and blocking chains.
- Proven experience architecting and supporting Always On Availability Groups, WSFC, and DR failover in enterprise environments.
- Strong command of Wait Statistics, DMVs, Extended Events, and Query Store for root-cause performance diagnosis.




- Solid experience with point in time database restores, High-Availability failover, disaster recovery planning, and hands-on recovery testing.
- Windows Server administration and Active Directory / Kerberos authentication for SQL Server.
- Demonstrated ability to lead technical projects and mentor junior team members.
- Familiarity with ITIL change, incident, and problem management processes.

DESIRABLE / ADVANTAGEOUS

- Microsoft certification: DP-300 (Azure Database Administrator Associate) or legacy MCSE Data Management & Analytics.
- Experience with Azure SQL Database or SQL Server on Azure VMs in hybrid configurations.
- Exposure to APM tooling (e.g. Dynatrace, AppDynamics, New Relic) and correlating application traces with database-level diagnostics.
- Proficiency with Redgate SQL Monitor, SolarWinds DPA, SentryOne, or equivalent database monitoring platforms.
- PowerShell scripting for DBA automation, including use of dbatools.
- Experience with SSIS in a data warehousing or reporting context.
- Knowledge of data governance and compliance frameworks such as GDPR, ISO 27001, or SOC 2.
- Exposure to DevOps CI/CD pipelines with database deployments (e.g. Flyway, Liquibase, or Redgate Deployment Manager).

KEY COMPETENCIES

- Problem Solving & Analytical Thinking
- Attention to Detail
- Transparent Written & Verbal Communication
- Proactive & Self-Motivated
- Collaborative Team Player
- Ability to Prioritise Under Pressure

This role description is intended as a guide and is not exhaustive. Responsibilities may evolve in line with business needs.

📌 Microsoft Windows SQL Server DBA (Contarct) (Karnataka)
🏢 HeadSpin
📍 Karnataka