Principal SQL Server DBA (SME)
waystone
- Mumbai, India
- Hybrid
- Lead/Staff
- 8+ years
- Posted
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.
