Senior SQL DBA – Hybrid Cardiff, Performance

Amber Resourcing Ltd; Cardiff; Hybrid; GBP 60,000 - 65,000; Full time

Job summary

Amber Resourcing Ltd in Cardiff is seeking a Senior SQL Database Administrator to join our technology team, focusing on SQL Server estates across dev/test/prod.

You will own performance, availability, security and reliability, collaborating with development, infrastructure and production support. This senior role requires expertise and a proactive approach to automation and DR. Hybrid work with two days in the office.

Qualifications

• Proven experience as a Microsoft SQL Server DBA across multiple environments.
• Strong knowledge of SQL Server performance monitoring and optimisation (DMVs, Extended Events, Query Store).
• Experience with HA/DR technologies (Always On, Failover Clustering, Log Shipping).
• Experience with Windows Server and Active Directory.
• Understanding of Azure SQL Database and Azure SQL Managed Instance.

Responsibilities

• Manage SQL Server databases across development, test and production environments.
• Configure, maintain and monitor database servers for performance, availability and security.
• Lead investigation and resolution of complex database issues.
• Act as escalation point for production support and incidents.
• Collaborate with development teams on application and schema issues.
• Provide expertise on query tuning, indexing and schema optimisation.
• Identify opportunities to automate DBA tasks and maintenance.
• Plan and support database maintenance, releases and changes.
• Manage database security, access controls, auditing and data protection.
• Support backup, recovery and DR strategies.
• Support Power BI data sources and performance.
• Contribute to data modelling and integration activities.
• Participate in on-call/out-of-hours support.
• Share knowledge and mentor junior DBAs.

Skills

SQL Server DBA

Performance tuning

High availability

Azure SQL

PowerShell

Terraform

Security & compliance

Windows Server

Azure storage

Data modelling

Power BI data sources

Tools

Azure DevOps Pipelines

SSDT

Flyway

Terraform

Bicep/ARM templates

Azure DevOps

Job description

Amber Resourcing Ltd in Cardiff is seeking a Senior SQL Database Administrator to join our technology team, focusing on SQL Server estates across dev/test/prod.

You will own performance, availability, security and reliability, collaborating with development, infrastructure and production support. This senior role requires expertise and a proactive approach to automation and DR. Hybrid work with two days in the office.