NHS South Central and West Commissioning Support Unit

Senior Database Administrator

This job is now closed

Job summary

An exciting opportunity has arisen within the Data Management Services department for a Lead Database Administrator. This role would be suitable for a database administrator who is looking to further progress their career or, existing senior database administrators wanting to work with data at a very large scale, in order to help improve outcomes for patients and support the wider NHS.

The post holder will contribute to the performance of Database Operations, the wider IT Services community and SCW by actively engaging with peers. They will also need to understand and comply with existing RDBMS strategies.

SCW is committed to our process of redeployment of at-risk members of our existing workforce to new roles. As such, all job adverts are subject to this policy and we reserve the right to close, delay or remove adverts while this process is completed. If you do experience a delay in the shortlisting stage of the recruitment cycle, please bear with us while this process is completed, and contact the named contact if you have any questions.

Main duties of the job

The holder of the role will be expected to support the Database Operations Team and as such must have knowledge and experience of the following:

Working with SQL Server 2008 upwards

High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Performance Tuning and Optimization

Backup Solutions

Working with Windows server, including Active Directory

Physical and Virtual Server infrastructure

Best operational practices of a scale environment

About us

This is an exciting time to join NHS South, Central and West.

We are one of the largest commissioning support units in the country, providing support and professional expertise for over 70 NHS and non-NHS customers, including integrated care boards, NHS England, local authorities, foundation trusts, social enterprises and other health-related organisations.

We're supporting clients whose vision and quest for innovation requires us to be flexible, adaptable and open to adventure; giving us the freedom to work in new ways, looking at things from a different angle and challenging the norm.

We are committed to attracting and retaining the best people in order to provide the best possible services to our customers. Our staff enjoy challenging, rewarding roles, supporting our customers to improve their local health and care services.

We want our people to fulfil their potential so we offer a wide range of training, opportunities to gain qualifications as well as access to coaching and mentoring schemes.

If you join us, we will value your experience, your contribution and we will give you the knowledge to succeed as part of your specialist team and as part of our organisation.

To find out more about what SCW has to offer, please visit Our offer to you page.

Date posted

25 June 2024

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year Per Annum

Contract

Permanent

Working pattern

Full-time

Reference number

891-CSU-7836EB

Job locations

Omega House

Eastleigh

SO50 5PB

Job description

Job responsibilities

Please refer to the job description and person specification for further details and information regarding this role.

Job description

Job responsibilities

Please refer to the job description and person specification for further details and information regarding this role.

Person Specification

Values & Behaviours

Essential

Patient First - Customer Excellence
Aspirational
Collaborative
Insightful
Respectful

Education

Essential

Educated to degree level in relevant subject or equivalent level of experience of working at a similar level in specialist area

Desirable

Further training or significant experience in relevant subject, project management, financial management or supporting change management processes

Knowledge & Experience

Essential

Strong experience in Database Administration in SQL Server 2008 up to SQL Server 2016

Desirable

Experience in communications and stakeholder management
Previous experience in project management and planning
A good understanding of the health and social care environment and roles and responsibilities within it

Skills & Capabilities

Essential

Experience in Performance Tuning, and Query Optimization
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Expert experience in implementing operational automation.

Desirable

Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
SQL Development - ability to write and troubleshoot SQL Code and design (Stored procs, functions, tables, views, triggers, indexes, constraints)
Solid acquaintance with windows server, security delegation, SPNs, storage components.

Person Specification

Values & Behaviours

Essential

Patient First - Customer Excellence
Aspirational
Collaborative
Insightful
Respectful

Education

Essential

Educated to degree level in relevant subject or equivalent level of experience of working at a similar level in specialist area

Desirable

Further training or significant experience in relevant subject, project management, financial management or supporting change management processes

Knowledge & Experience

Essential

Strong experience in Database Administration in SQL Server 2008 up to SQL Server 2016

Desirable

Experience in communications and stakeholder management
Previous experience in project management and planning
A good understanding of the health and social care environment and roles and responsibilities within it

Skills & Capabilities

Essential

Experience in Performance Tuning, and Query Optimization
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Expert experience in implementing operational automation.

Desirable

Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
SQL Development - ability to write and troubleshoot SQL Code and design (Stored procs, functions, tables, views, triggers, indexes, constraints)
Solid acquaintance with windows server, security delegation, SPNs, storage components.

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 details

Employer name

NHS South Central and West Commissioning Support Unit

Address

Omega House

Eastleigh

SO50 5PB

Employer's website

https://www.scwcsu.nhs.uk/ (Opens in a new tab)

Employer details

Employer name

NHS South Central and West Commissioning Support Unit

Address

Omega House

Eastleigh

SO50 5PB

Employer's website

https://www.scwcsu.nhs.uk/ (Opens in a new tab)