Senior Database Administrator

Company Description Technology is our how And people are our why For over two decades we have been harnessing technology to drive meaningful change By combining world-class engineering industry expertise and a people-centric mindset we consult and partner with leading brands from various industries to create dynamic platforms and intelligent digital experiences that drive innovation and transform businesses From prototype to real-world impact - be part of a global shift by doing work that matters 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 24x7 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 5 years of experience as a SQL Server DBA in production environments Deep knowledge of SQL Server architecture and internals hands on with versions 2016-2022 or later Proven experience with both on prem 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 Geo Replication Multi AZ patterns on AWS Strong T SQL 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 Hands on 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 cross functional teams comfort with ITIL aligned incident request problem processes and on call support 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