Senior SQL Server DBA

A leading organisation is looking for a highly experienced Senior SQL Server DBA to take ownership of mission-critical SQL Server platforms across production UAT development and disaster recovery environments.

This is a hands-on role focused on database performance high availability disaster recovery security encryption backup and recovery automation and advanced troubleshooting. The successful candidate will work closely with developers and infrastructure teams to ensure critical database environments remain stable secure performant and recoverable.

Key Responsibilities

• Administer configure maintain patch and upgrade SQL Server environments.
• Monitor SQL Server health performance capacity availability jobs backups and database growth.
• Troubleshoot production incidents including blocking deadlocks failed jobs performance degradation and database issues.
• Design maintain and troubleshoot High Availability and Disaster Recovery solutions.
• Manage Always On Availability Groups Failover Clustering Replication and Log Shipping.
• Develop and maintain robust backup restore and point-in-time recovery strategies.
• Perform regular restore and disaster recovery testing.
• Conduct advanced SQL Server performance tuning and query optimisation.
• Assist developers with query tuning indexing execution plans stored procedures and schema refinement.
• Manage partitioning strategies for large and high-growth databases.
• Implement and maintain SQL Server security permissions encryption TDE certificates and key management.
• Develop T-SQL and PowerShell scripts to automate database administration and monitoring processes.
• Perform capacity planning and monitor database storage and infrastructure growth.
• Support Azure SQL and hybrid database environments where required.
• Maintain technical documentation operational procedures and database standards.
• Provide technical guidance and mentorship to junior team members.

Requirements

• 10 years experience in Microsoft SQL Server administration within enterprise or production environments.
• Strong SQL Server performance tuning and optimisation experience.
• Advanced T-SQL skills including stored procedures triggers indexing and execution plans.
• Strong experience with backups restores recovery models and point-in-time recovery.
• Extensive SQL Server HA/DR experience.
• Hands-on experience with Always On Failover Clustering Replication and Log Shipping.
• Strong knowledge of SQL Server security permissions encryption and TDE.
• Experience with certificates encryption keys and key management.
• Experience with SQL Server partitioning and large databases.
• Experience working with Windows Server and Active Directory dependencies.
• Strong troubleshooting and problem-solving abilities.
• Ability to work closely with developers and infrastructure teams.
• Ability to work independently and manage multiple priorities in a production environment.
• Excellent written and verbal communication skills.

Advantageous Experience

• Financial services insurance or another regulated environment.
• Azure SQL Database Azure SQL Managed Instance or SQL Server on Azure VMs.
• Veeam or other enterprise backup platforms.
• PowerShell automation.
• SAN-backed SQL Server platforms.
• VMware-hosted SQL Server environments.
• SQL Server auditing vulnerability remediation and compliance.
• Knowledge of PostgreSQL MySQL or other database technologies.
• Experience with change incident and problem management.

How To Apply:

• Contact Hire Resolve today for your next career-changing move
• Our client is offering a highly competitive salary for this role based on experience.
• Send your CV to: or connect with Mischa Bornman via LinkedIn.
• Alternatively you can also contact me directly at Hire Resolve
• We will contact you telephonically in 3 days should you be suitable for this vacancy. If you are not suitable we will put your CV on file and contact you regarding any future vacancies that arise.