Senior Database Administrator
Senior Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
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 onprem 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 MySQLespecially on AWS RDS/Aurorais a strong plus. The role blends handson 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 onprem 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 TSQL 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 GeoReplication; leverage AWS MultiAZ for RDS and EC2based failover patterns; document automated runbooks aligned to RPO/RTO targets.
- Plan and execute migrations onprem 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 longterm 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 thirdparty 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 247 operations/oncall rotation respond to incidents perform RCA implement preventive improvements; maintain uptodate documentation (architecture SOPs runbooks).
- Contribute to capacity planning and cost optimization across Azure and AWS (instance/storage rightsizing IOPS tiers storage autoscaling licensing posture environment scheduling).
Qualifications :
Required:
- 5 years of experience as a SQL Server DBA in production environments.
- Deep knowledge of SQL Server architecture and internals; handson with versions (or later).
- Proven experience with both onprem SQL Server and cloud platforms: Azure (Azure SQL Database Managed Instance) and AWS (SQL Server on EC2 Amazon RDS for SQL Server).
- Expertise in backup/restore HA/DR design and testing (Always On Log Shipping Azure GeoReplication; MultiAZ patterns on AWS).
- Strong TSQL scripting and performance tuning skills (execution plans indexing strategies Query Store wait statistics Extended Events).
- Operational proficiency with Azure Portal/Monitor and AWS Console/CloudWatch; experience with automation tools (PowerShell Azure Automation AWS Systems Manager Lambda).
- Working knowledge of security controls: RBAC/least privilege encryption at rest/in transit (TDE Always Encrypted) auditing; practical use of IAM/Azure AD KMS/Key Vault Secrets Manager.
- Handson with cloud and platform migrations (DMA Azure Migrate AWS DMS/SCT) and version upgrades.
- Familiarity with monitoring/administration toolsets such as Splunk SolarWinds/SentryOne or similar.
- Clear communication documentation discipline and collaboration with crossfunctional teams; comfort with ITILaligned incident/request/problem processes and oncall support.
Nice to Have:
PostgreSQL and/or MySQL administration experience (replication tuning schema design) ideally on AWS RDS/Aurora.
Additional Information :
At Endava were 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 perspectivesbecause 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.
Remote Work :
No
Employment Type :
Full-time
Employment Type
Full-time
