Role Summary: We are looking for an experienced SQL Server DBA responsible for installing, creating, administrating, maintaining and supporting databases by ensuring their performance, availability and security to provide a stable database environment. Additionally, the role may lean heavily towards migration activities to AWS, both IaaS and RDS for SQL Server. This is a hybrid position where you will work from any Aptia office as well as from your home address. This is a 12 months contract. Here's what you'll be doing: Database administration of SQL Server 2016-2019 including installation, patching, support, releases, monitoring, backup and recovery. Assisting with performance tuning, delving into execution plans, trouble shooting, indexes and statistics. Troubleshooting Sev 1 issues and deciphering alerts. Working with clusters and assisting with server issue investigations. Releasing code and working on Change controlled requests/incidents both in and out of normal working ours. Working collaboratively across teams on ad-hoc projects. Assisting with PostgreSQL support where possible. Working across various teams to troubleshoot issues and deep dive for root cause analysis and resolution, attending meetings and discussing outcomes. Working on a range of resolutions from server availability issues to query coding issues and database configuration. Working on strategies and plans to mitigate on-premise to AWS, or AWS to AWS, automating when possible. Creating/working with teams to create documentation surrounding migration activities, identifying requirements, bottle necks and limitations. Here's what we're looking for: Experience as a database administrator of MS SQL Server Databases in production environments. Experience in managing 247 production servers, large databases and multiple instances. Knowledge of AWS database operations and migrations as well as migration strategies and execution. Good knowledge of SSRS and SSIS. Power BI a bonus. Advanced technical knowledge of replication methods such as Log Shipping, Always On/HA/Mirroring/AG's/WSFC. PowerShell scripting for automation activities or other automation techniques. Experience with MS SQL Agent and features: maintenance plans, scheduled jobs, alerts and DB Mail. Familiarity with MSSQL features such as TDE, Compression, MDW and DMVs. Good knowledge of and skills in database security design and implementation. If you are interested in this role and then we'd love to hear from you. Please go ahead and click apply to submit your CV. Aptia is committed to celebrating the diversity of its employees and are proud to be an Equal Opportunities employer. We strive to create a workplace where all colleagues feel they belong and are supported to succeed in their roles. If there are any reasonable adjustments we can make to the recruitment process to ensure it is accessible to you, we encourage you to email us at Recruitment_UKaptia-group.com.