SQL DBA Lead

Title: SQL DBA Lead

Location: Manchester- fully onsite

Clearance required: BPSS+ SC

Role Context

• The SQL DBA will act as a subject matter expert for Azure and on-prem Microsoft SQL Server and MySQL environments. The role supports enterprise-level database operations across production, UAT, and development environments, ensuring performance, availability, and security.
• This role will be based full time in the Manchester secure room.

Key Responsibilities

• Administer and maintain MS SQL and MySQL databases, including clustering, replication, backups, and performance tuning.
• Provide third-line support and resolve incidents via call management systems.
• Perform planned releases, patching, and upgrades across environments.
• Monitor and optimise database performance, including space management and alert log checks.
• Mentor junior DBAs and contribute to knowledge sharing across the team.

Skills and Experience Required

• Well versed in Microsoft SQL Server (2016 onwards)
• Significant experience with T-SQL, stored procedures, triggers
• Experience with Azure VMs, Windows Server and Azure DevOps
• SSIS - experience in creating, maintaining and deploying packages through SQL Server Integration Services
• Power BI - knowledge of Power BI report server, and an ability to troubleshoot issues around access and performance issues, perform upgrades and install SSL certificates
• Basic working knowledge of SCOM and/or Azure Monitor
• Experience working with ServiceNow or a similar ITIL system
• Nice to have: Powershell

Qualifications

• Microsoft Certified: Azure Database Administrator Associate or equivalent certification (preferred).
• ITIL Foundation certification (preferred).