SQL Database Administrator (DBA)

Warwickshire Police; Leek Wootton; On-site; GBP 45,000 - 65,000; Full time

Job summary

Warwickshire Police is seeking a SQL Database Administrator (DBA) to maintain and secure its SQL Server databases across Records Management and related systems. The role requires a minimum of 3 years’ experience in a 24/7 operational environment, with focus on security, backup, performance tuning and data governance.

You will participate in on-call rotas, support changes through CAB, and ensure documentation and audit readiness while travelling within Warwickshire as required.

Qualifications

• 3+ years of relevant SQL Server experience.
• Experience with 24/7 operational policing databases.
• Strong knowledge of database security, encryption, and access control.
• Familiarity with ITIL foundations and change/incident management.
• Ability to design and test high availability and disaster recovery solutions.
• Experience with data governance, retention, and audits.
• Excellent technical documentation and runbooks.

Responsibilities

• Administer, configure, monitor and support SQL Server databases.
• Ensure performance, stability, and capacity meet 24/7 policing demands.
• Implement database security, access controls and encryption.
• Ensure compliance with data governance, retention, and audit requirements.
• Design, maintain, and test high availability and disaster recovery solutions.
• Support secure system integrations with internal and national systems.
• Deliver database changes through formal change control and CAB processes.
• Maintain technical documentation, runbooks, and audit evidence.
• Provide on-call and major incident DBA support for live systems.
• Support projects and change requiring DBA input.
• Undertake other duties commensurate with the post.

Job description

Please note, if this is a paid role and the role is part time then the salary quoted will be pro rata based on the hours worked per annum.

37

Competency and value framework (CVF) level? 2

24/09/2026, 12:00

SQL Database Administrator (DBA)

PermanentFull TimeLeek Wootton

The main purpose of the role is to maintain and manage the security, integrity, recoverability, capacity and availability of Warwickshire Police’s databases in accordance with standards and policies.

Main Responsibilities:

1. Administer, configure, control, monitor and support SQL Server databases including (but not limited to) Warwickshire Police’s Records Management System.

2. Ensure database performance, stability, and capacity meet 24/7 operational policing demands. Use database management system software and tools to analyse and investigate database problems, resolving these within agreed SLAs.

3. Implement and enforce database security, access controls, and encryption in line with Warwickshire Police standards and policies

4. Ensure compliance with policing data governance, retention, and audit requirements.

5. Design, maintain, and test high availability and disaster recovery solutions.

6. Support secure system integrations with internal and national systems.

7. Deliver database changes through formal change control and CAB processes.

8. Maintain technical documentation, runbooks, and audit evidence.

9. Provide on-call and major incident DBA support for live operational systems.

10. Support projects and change requiring DBA input.

11. To undertake other duties commensurate with the nature, level of responsibility and grading of this post, as required.

Special Conditions:

Requirement to participate in on call rota.

Regular travel throughout Warwickshire.

Person Specification:

Knowledge:

Microsoft SQL Server architecture (2019+) and administration.

Database security controls including encryption, auditing, and access control

Data lifecycle management including retention, archiving and data rehydration

Holds or possesses demonstrable knowledge of ITIL Foundation Level.

Holds or possesses demonstrable knowledge of typical SQL DBA tooling e.g. TempDB

Knowledge of, or willingness to learn

OFFICIAL-SENSITIVE data handling requirements and MOPI

ISO standards and principles

Experience:

At least 3 years of relevant experience

Supporting business-critical SQL Server systems in a 24/7 environment.

Managing backup, restore, and disaster recovery testing.

Performance tuning of large, high-volume transactional databases.

Working within formal ITIL change and incident management.

Supporting systems subject to regulatory, legal, or forensic audit.

Key Skills:

Advanced SQL Server troubleshooting and performance optimisation.

Strong analytical and problem-solving capability under pressure.

High standards of technical documentation and audit readiness.

Secure system access control and role-based permissions management.

Clear communication with technical and operational stakeholders.

Ability to operate calmly in critical incident and on-call environments.

We want our organisation to be as diverse as the community it serves. We welcome applicants from all sections of the community.

You will be required as part of Warwickshire Police recruitment process to successfully complete vetting and credit checks.

We support the "Happy to talk flexible working" campaign, which aims to encourage uptake of flexible working for individuals, the flexible working options that may be considered for this role include; Remote Working.

Please note, you will require the following detail to complete this application form; NI Number, ID detail, address information, referee information, full employment history including dates and any qualifications you may have attained. You may also be requested to provide photos of any visible tattoos you have. The application system only remains active on a single page for a period of 60 minutes. Please therefore ensure you allow time to complete this fully as part complete pages will not be saved.