Senior SQL Server DBA at Hire Resolve

Job Description

• 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.