Lead Database Adminstrator
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 senior database administrator who is looking to further progress their career or, existing lead database administrators with great team leadership skills 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 management peers. They will also play an influential role in the definition, development, and maintenance of the 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 mentor and lead members of the Database Operations Team and as such must be able to contribute to technical discussions based around, but not limited to, knowledge 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
Storage technologies
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
- Patient First - Customer Excellence
- Aspirational
- Collaborative
- Insightful
- Respectful
Education
- Educated to masters' level or equivalent level of experience of working at a senior level in specialist area
- Evidence of post qualifying and continuing professional development
- Further training or significant experience in relevant subject, project management, financial management or supporting change management processes
- Member of relevant professional body
Knowledge & Experience
- Experience in communications and stakeholder management
- Experience of leading a team across multiple workstreams, managing conflicting priorities.
- Experience of conducting staff performance reviews
- Strong experience in Database Administration in SQL Server 2008 Upwards
- Understanding of the public sector
- A good understanding of the health and social care environment and roles and responsibilities within it
Skills & Capabilities
- Developed communication skills for delivering key messages to a range of stakeholders/customers both internal and external (including outside the NHS) to the organisation, some at very senior level
- Good presentational skills for conveying complex concepts
- Ability to make decisions autonomously, when required, on difficult issues, working to tight and often changing timescales and within financial constraints
- Evidence of planning and delivering programmes, projects and services on time using established project management techniques
- Excellent customer service skills; Team working skills; Self-motivated; Ability to move between details and the bigger picture. Demonstrates honesty and integrity and promotes organisational values
- Experience in managing systems using scripting tools such as PowerShell and T-SQL.
- Experience of the design, documentation and successful implementation of new or changed operational processes.
- Ability to interpret contracts and SLAs to ensure effective delivery within the terms of the agreement
- Must be able to provide and receive complex, sensitive or contentious information, negotiate with senior stakeholders/customers on difficult and controversial issues, and present complex and sensitive information to large and influential groups/customers
- Excellent understanding of infrastructure management, backup methodologies and implementation.
- Excellent understanding of Storage area network technologies
- Expert in Performance Tuning, and Query Optimization
- Expert in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Expert Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
- Expert knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
- Expert experience in implementing operational automation.
- Expert 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)
- Expert 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
Bristol
Bristol
BS1 6AG
https://www.scwcsu.nhs.uk/
- Company
- NHS South Central and West Commissioning Support Unit
- Location
- Bristol, United Kingdom BS1 6AG
- Employment Type
- Permanent
- Salary
- £50952.00 - £57349.00 a year
- Posted
- Company
- NHS South Central and West Commissioning Support Unit
- Location
- Bristol, United Kingdom BS1 6AG
- Employment Type
- Permanent
- Salary
- £50952.00 - £57349.00 a year
- Posted