Database Administrator - Data Archiving

Integrated Care System; Plymouth, Torquay; Hybrid; GBP 55,000 - 63,000; Full time

Job summary

A healthcare provider is seeking a Database Administrator to design and manage database platforms for archiving solutions. The role requires expertise in SQL Server and relevant healthcare experience. The successful candidate will ensure compliance with data retention policies, manage user security, and monitor database performance. This position will require onsite work across Torquay and Plymouth. Salary ranges from £55,690 to £62,682 annually.

Qualifications

• 5+ years in healthcare environments.
• Expert SQL Server skills in operational settings.
• Knowledge of NHS Information Standards essential.

Responsibilities

• Manage data repositories supporting archiving needs.
• Install, configure, and maintain databases.
• Ensure compliance with Trust Governance Procedures.

Skills

SQL querying

Database management

Problem solving

Scripting knowledge

Education

Degree in a relevant subject

Certification in managing SQL Server

Professional qualification at master's level

Tools

MS SQL Server

Oracle

Job description

Go back Torbay and South Devon NHS Foundation Trust

Database Administrator - Data Archiving

The closing date is 03 August 2025

We are seeking a skilled and detail-oriented Database Administrator / Developer to design and develop a robust database platform for the archive solution for UHP and TSD Trusts. In this role you will be responsible for database administration tasks such as database restores and development tasks such extract development with a strong focus on understanding legacy source systems data models, optimizing data storage, retrieval, and long-term data retention strategies.

You will play a key role in managing the lifecycle of archived data, ensuring it is secure, accessible, and compliant with Trusts data retention policies. Working closely with infrastructure teams, application developers, and business stakeholders, you will help design efficient data models and implement automation to streamline archival processes.

This is role is being advertised pending the outcome of the formal Job Evaluation process. The advertised band and salary for the role is therefore indicative at this stage and may change subject to the formal outcome.

Main duties of the job

• Responsibility for managing the data repositories that support the Trust's archiving needs.
• Create and manage the MS SQL Server database environments that serve archiving needs.
• Strong SQL querying skills.
• Install, configure, and maintain databases to ensure optimal performance and integrity.
• Set up and maintain tables, database views and indexes as needed.
• Manage user security for the SQL Server database environments.
• Maintain database backups and verify restores.
• Monitor database size and fragmentation levels.
• Create and maintain database objects as required
• Proactive monitoring and management of the environments to ensure optimal performance and integrity that meets the agreed availability and quality.
• Manage SQL Server and upgrades and updates to production and non-production environments.
• Collaborate with the server administrators to ensure that security updates are current.
• Conduct regular risk assessments of the solution to recommend actions to ensure that delivery of the Trust's digital system is not compromised.
• Maintain and test failover procedures to ensure high availability.
• Attend digital seminars, user groups and meetings on relevant topics.
• Ensure compliance with the Trust Governance Procedures, Policies and Standards for data loads and interfaces.

About us

Why Work With Us

The successful candidate will be expected to work onsite on a regular basis and divide their working days between Torquay and Plymouth to suit the needs of the Programme.

This role is available on a Fixed Term Contract or Secondment basis from a start date to be agreed until 30th September 2026.

Job responsibilities

Details of the main responsibilities of the role can be found in the attached Job Description and Person Specification.

Person Specification

Qualifications & Training

• Degree in a relevant subject or extensive equivalent experience
• Professional qualification at master's level or equivalent experience to Masters level (gained at senior digital/management level)
• Certification in managing and administering SQL Server

Knowledge & Experience

• Expert SQL Server skills in a critical operational environment
• Expert in at least one RDBMS (Oracle, MS SQL Server, Informix etc)
• Excellent scripting knowledge with a particular focus understanding data models with no to little supporting documentation
• At least 5 years' experience in working in healthcare environments.
• Knowledge of NHS Information Standards and their application in technical infrastructure
• Considerable experience of database administration and design in the delivery of a corporate system
• Experience of managing mission critical systems to a high level.
• Experience of the IT security and other relevant areas of NHS Information Governance and DSPT requirements

Specific Skills

• A deep understanding of SQL syntax, DDL (Data Definition Language), DML (Data Manipulation Language) and DCL (Data Control Language) is crucial.
• Innovative, able to problem solve and make decisions.
• Able to work in a pressurised environment.

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Employer name

Torbay and South Devon NHS Foundation Trust

£55,690 to £62,682 a yearper annum, This salary is indicative pending formal Job Matching