Senior SQL DBA — Hybrid Cardiff | SC Eligible | Azure/HA

CPS Group (UK) Limited; Cardiff; Hybrid; GBP 65,000 - 90,000; Full time

Job summary

CPS Group (UK) Limited, in partnership with a global IT consultancy, seeks an experienced Senior SQL Server DBA to support a key public sector client. The role is based in Cardiff on a hybrid model, requiring 1–2 days in the office weekly and involvement across development, test and production environments.

You will manage and optimise SQL Server databases, implement HA/DR with Always On, handle backups and security, work with Azure SQL, and automate tasks using PowerShell, collaborating closely

Qualifications

• Extensive SQL Server administration and performance tuning experience.
• Experience with Always On/HA-DR, backups and recovery.
• Knowledge of SQL Server security and encryption.
• Experience with Azure SQL.
• PowerShell scripting for automation.
• Windows Server/Active Directory knowledge.
• DevOps/CI-CD or IaC experience would be advantageous.
• SC clearance or eligibility to obtain SC clearance.

Responsibilities

• Manage and support SQL Server databases across multiple environments.
• Monitor and optimise database performance, including query tuning and indexing.
• Manage backups, restores, recovery and HA/DR solutions including Always On.
• Support database security, access controls, auditing and encryption.
• Work with Azure SQL Database and Azure SQL Managed Instance.
• Automate administration and maintenance using PowerShell.
• Support production issues, deployments and database changes.
• Work closely with development and infrastructure teams, acting as a senior technical escalation point.

Skills

SQL Server DBA

Performance tuning

PowerShell

CI/CD

Windows Server

SC clearance

Tools

Azure SQL

Job description

CPS Group (UK) Limited, in partnership with a global IT consultancy, seeks an experienced Senior SQL Server DBA to support a key public sector client. The role is based in Cardiff on a hybrid model, requiring 1–2 days in the office weekly and involvement across development, test and production environments.

You will manage and optimise SQL Server databases, implement HA/DR with Always On, handle backups and security, work with Azure SQL, and automate tasks using PowerShell, collaborating closely