jobapplier

Principal SQL Server DBA (SME)

waystone

Skills

Required

  • SQL
  • Server DBA
  • SQL Server / RDS Custom
  • Server
  • SQL Server 2019 / 2022 administration
  • WSFC
  • backup and
  • recovery
  • Query Store
  • Azure
  • EC2
  • T-SQL
  • PowerShell

Preferred

  • DBA
  • Terraform / Bicep / CloudFormation
  • Git
  • Oracle
  • PostgreSQL
  • SQL Server Management Studio
  • Data Studio
  • RDS
  • Amazon S3
  • Jira

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.

Responsibilities

  • 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.
  • 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.
  • 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.
  • 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.
  • RDS automated backups, snapshots and AWS Backup plans, native backup and restore to Amazon S3, and platform maintenance windows.
  • AWS IAM, AWS KMS, AWS Secrets Manager, VPC subnet groups and security groups in line with security standards.
  • 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.
  • 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.
  • RPO and RTO targets are documented, tested and achievable, and run integrity checks (DBCC CHECKDB), acting promptly on any corruption.
  • & 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.
  • & 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.
  • & 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.
  • builds strong working relationships across development, infrastructure and security teams.
  • creates a psychologically safe environment, recognises good work and develops others.

Requirements

  • 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).
  • 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.
  • anticipates problems and acts on early warning signs rather than waiting for an alert.
  • owns mistakes openly and focuses on solutions, not blame.

Preferred

  • 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.

Trustworthy

maintains the confidentiality of sensitive data, credentials and commercial information.

Easy Apply