Waystone logo

Principal SQL Server DBA (SME)

Hiring from
India
Work type
Hybrid
Posted

625,816 remote jobs, straight from company career pages

100% free · New jobs every minute

Show job description

About the Role

We are looking for a Microsoft SQL Server subject matter expert to act as the senior technical authority for our SQL Server estate. You will combine deep, hands-on SQL Server DBA expertise with strong experience of running SQL Server in both Microsoft Azure and Amazon Web Services (AWS), and a genuine drive to standardise and automate. The role is accountable for the health, performance, security and resilience of our SQL Server databases, whether hosted on-premises or in the cloud, and for raising the standard of how the Data Services Team builds and operates them.

You will lead by example: solving the hardest technical problems, replacing repetitive manual effort with reliable automation, and mentoring less senior DBAs. You will work closely with the Data Services Manager, and with application, infrastructure and security teams.

Key Responsibilities

SQL Server Administration & Architecture

  • Design, implement and maintain SQL Server environments (2019 and 2022) on-premises, covering capacity planning, schema design, filegroup and storage management, and tempdb configuration.
  • Manage Always On Availability Groups, Failover Cluster Instances (WSFC), log shipping and replication to meet defined availability targets.
  • Administer SQL Server Management Studio, Azure Data Studio, SQL Server Agent and related monitoring tooling.
  • Maintain documented instance configuration baselines and define and enforce standards for naming, collation, partitioning and object management.

Microsoft Azure

  • Own the build, operation and optimisation of SQL Server on Azure, including Azure SQL Managed Instance, Azure SQL Database and SQL Server on Azure VMs.
  • Use Query Performance Insight, SQL Insights in Azure Monitor and automatic tuning recommendations to analyse real-time and historical performance.
  • Manage Azure SQL auto-failover groups, automated backups and long-term retention, with identity and access through Microsoft Entra ID and Azure RBAC, and keys and secrets in Azure Key Vault.
  • Configure and review private endpoints, VNet rules and firewall settings in line with security standards.

Amazon Web Services (AWS)

  • Own the build, operation and optimisation of SQL Server on AWS, including Amazon RDS for SQL Server, RDS Custom and SQL Server on EC2, with Multi-AZ deployments and read replicas.
  • Use Amazon CloudWatch, RDS Performance Insights and Enhanced Monitoring to analyse real-time and historical performance.
  • Manage RDS automated backups, snapshots and AWS Backup plans, native backup and restore to Amazon S3, and platform maintenance windows.
  • Apply AWS IAM, AWS KMS, AWS Secrets Manager, VPC subnet groups and security groups in line with security standards.

Cloud Platform Operations & Architecture

  • Act as the technical owner for SQL Server workloads across both clouds, applying a single set of operational standards regardless of hosting platform.
  • Advise on hosting choices for new and migrating workloads (managed service versus VM or EC2, and Azure versus AWS), with a clear rationale covering cost, resilience and feature requirements.
  • Provision and modify database resources through infrastructure as code and repeatable pipelines rather than manual portal changes.
  • Monitor and report on database cloud spend, identifying right-sizing, reserved capacity, licensing and storage optimisation opportunities.
  • Track service roadmaps and deprecations in both clouds and plan remediation before end-of-support dates.

Performance Tuning & Optimisation

  • Proactively identify and resolve bottlenecks using Query Store, DMVs, wait statistics and Extended Events.
  • Tune execution plans, indexing strategy and statistics; diagnose and remediate parameter sniffing and plan regression; manage tempdb contention, I/O throughput, blocking and deadlocks.
  • Maintain consistent performance baselines and thresholds across on-premises, Azure and AWS so estate health can be compared like for like.
  • Lead periodic performance health checks and present findings and recommendations to the Data Services Manager.

Backup, Recovery & Business Continuity

  • Own the backup strategy (full, differential and transaction log, including backup to URL and Amazon S3) and regularly validate recovery procedures.
  • Maintain and test disaster recovery runbooks for all production databases, coordinating failover exercises and point-in-time restore tests in both clouds.
  • Ensure RPO and RTO targets are documented, tested and achievable, and run integrity checks (DBCC CHECKDB), acting promptly on any corruption.

Security & Compliance

  • Enforce least-privilege access across logins, database users, roles and service accounts.
  • Implement and audit Transparent Data Encryption (TDE), Always Encrypted, Dynamic Data Masking, Row-Level Security and SQL Server Audit.
  • Work with the security team on vulnerability assessments and patch remediation to meet regulatory and organisational standards in every hosting environment.

Patching, Upgrades & Change

  • Plan and execute Cumulative Update (CU) and GDR patching cycles with minimal downtime, and manage platform-driven maintenance in Azure and AWS.
  • Lead major version upgrades and migrations to Azure SQL or Amazon RDS, including compatibility testing, Azure DMS or AWS DMS, and rollback planning.
  • Prepare change advisory board submissions and complete post-implementation reviews.

Automation & Continuous Improvement

  • Identify and eliminate repetitive DBA tasks through automation using T-SQL, PowerShell (including dbatools and the Az and AWS Tools modules) and SQL Server Agent.
  • Standardise routine maintenance through a proven framework covering index and statistics maintenance, integrity checks and backup scheduling.
  • Improve monitoring and alerting, tuning thresholds to cut noise and strengthen signal quality.
  • Maintain a technical debt register and drive its reduction through prioritised, tracked work.

Incident & Problem Management

  • Take technical command of P1/P2 database incidents, delegating diagnostics clearly and prioritising service restoration.
  • Provide prompt initial assessments and regular, factual status updates throughout an incident.
  • Lead post-incident reviews and ensure resulting actions are tracked through to completion.

Technical Leadership & Collaboration

  • Act as primary technical mentor to less senior DBAs: assigning and briefing work, reviewing scripts, changes and runbooks before they reach production, and giving timely, constructive feedback.
  • Run knowledge-sharing sessions and contribute to technical assessments and onboarding of new team members.
  • Provide a concise weekly status summary and quarterly database health reports to the Data Services Manager.
  • Represent the team at release and change meetings, and explain database risks and dependencies in clear, non-technical language.

Documentation & Work Management

  • Own and maintain the database inventory, architecture documentation, runbooks and DR procedures, treating documentation as part of the definition of done.
  • Track all work in the team's ticketing and project tools (Jira), keeping status and effort up to date and supporting regular backlog triage.

Essential Skills & Experience

  • Substantial commercial experience as a SQL Server DBA (typically 8+ years), operating as a senior technical authority or subject matter expert.
  • Expert knowledge of SQL Server 2019 / 2022 administration, including Always On Availability Groups, WSFC, backup and recovery, and security.
  • Proven performance tuning ability using Query Store, DMVs, wait statistics, Extended Events and execution plan analysis.
  • Hands-on experience running SQL Server in Azure (Azure SQL Managed Instance, Azure SQL Database or SQL Server on Azure VMs).
  • Hands-on experience running SQL Server in AWS (Amazon RDS for SQL Server, RDS Custom or SQL Server on EC2).
  • Strong automation skills: T-SQL and PowerShell applied to real DBA operations.
  • Experience with patching, upgrades and migrations, and with TDE, auditing and least-privilege security models.
  • Experience designing and testing high availability and disaster recovery solutions against defined RPO and RTO targets.
  • Experience leading technical response to major incidents.
  • Strong written and verbal communication, with the ability to adapt message and detail to technical and non-technical audiences.

Desirable Skills & Experience

  • Infrastructure-as-code tooling (for example Terraform, Bicep or CloudFormation), Git and CI/CD pipeline experience applied to database change.
  • Experience with Azure CLI and AWS CLI tooling.
  • Experience of cloud cost optimisation, reserved capacity and SQL Server licensing.
  • Exposure to Oracle in a multi-platform estate.
  • PostgreSQL administration experience, including performance tuning, backup and recovery, and high availability, on-premises or on managed cloud services (for example Azure Database for PostgreSQL or Amazon RDS for PostgreSQL).
  • Relevant Microsoft and AWS certifications (for example Azure Database Administrator Associate).
  • Experience mentoring or coordinating the work of other DBAs.

Behaviours

  • Proactive: anticipates problems and acts on early warning signs rather than waiting for an alert.
  • Accountable: owns mistakes openly and focuses on solutions, not blame.
  • Collaborative: builds strong working relationships across development, infrastructure and security teams.
  • Supportive: creates a psychologically safe environment, recognises good work and develops others.
  • Trustworthy: maintains the confidentiality of sensitive data, credentials and commercial information.

Similar jobs

Apply for this job100% free