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.
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.
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