Senior Database Administrator

Job Description

Role overview

We are seeking an experienced SQL Server DBA to lead the reliability, performance, and security of our Microsoft SQL Server estate across on‑prem, Azure, and AWS. Primary focus is on MSSQL (on Windows / Linux; Azure SQL Database and Azure SQL Managed Instance; SQL Server on EC2 and Amazon RDS for SQL Server). Experience with PostgreSQL and MySQL—especially on AWS RDS / Aurora—is a strong plus. The role blends hands‑on administration, performance tuning, HA / DR design, automation, and close collaboration with engineering and DevOps teams.

Responsibilities :

• Install, configure, patch, and harden Microsoft SQL Server across on‑prem, Azure (Azure SQL Database, Azure SQL Managed Instance), and AWS (SQL Server on EC2, Amazon RDS for SQL Server).
• Manage and monitor database performance, integrity, capacity, and security; execute routine maintenance (backups / restores, index and statistics maintenance).
• Drive T‑SQL tuning and workload optimization (execution plans, indexing strategies, Query Store, wait statistics, Extended Events); partner with developers to improve schema and SQL patterns.
• Design, implement, and regularly test HA / DR solutions : Always On availability groups, Log Shipping, Azure Geo‑Replication; leverage AWS Multi‑AZ for RDS and EC2‑based failover patterns; document automated runbooks aligned to RPO / RTO targets.
• Plan and execute migrations on‑prem ↔ Azure ↔ AWS with minimal downtime using DMA / Azure Migrate, AWS Database Migration Service (DMS), and Schema Conversion Tool (SCT).
• Implement secure, durable backup / restore and retention strategies using Azure Backup / Blob Storage and AWS S3 / AWS Backup; apply encryption and lifecycle policies for long‑term archives.
• Automate administrative tasks and guardrails with PowerShell, SQL Agent, Azure Automation, AWS Systems Manager (SSM), and Lambda; codify infrastructure with Terraform / CloudFormation.
• Establish proactive observability and alerting using Azure Monitor / Log Analytics and AWS CloudWatch / CloudTrail, plus third‑party suites (Splunk, SolarWinds / SentryOne, ScienceLogic or similar).
• Ensure compliance with governance and security standards : RBAC / least privilege, TDE / Always Encrypted, Auditing, data masking; integrate with IAM / Azure AD, KMS / Key Vault, Secrets Manager / Key Vault.
• Participate in 24×7 operations / on‑call rotation, respond to incidents, perform RCA, implement preventive improvements; maintain up‑to‑date documentation (architecture, SOPs, runbooks).
• Contribute to capacity planning and cost optimization across Azure and AWS (instance / storage rightsizing, IOPS tiers, storage auto‑scaling, licensing posture, environment scheduling).

Qualifications

Required :

Nice to Have :

PostgreSQL and / or MySQL administration experience (replication, tuning, schema design), ideally on AWS RDS / Aurora.

Additional Information

At Endava, we’re committed to creating an open, inclusive, and respectful environment where everyone feels safe, valued, and empowered to be their best. We welcome applications from people of all backgrounds, experiences, and perspectives—because we know that inclusive teams help us deliver smarter, more innovative solutions for our customers. Hiring decisions are based on merit, skills, qualifications, and potential. If you need adjustments or support during the recruitment process, please let us know.