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.
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.
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.
Job description
Job responsibilities
Please refer to the job description and person specification for further details and information regarding this role.
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.
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.
Additional information
UK Registration
Applicants must have current UK professional registration. For further information please see
NHS Careers website (opens in a new window).
.png){kind=logo}
