Database Administrator (Senior Technical Role)
Job summary
An opportunity has arisen for an experienced Database Administrator (DBA), to join the central Information Services team at Sheffield Teaching Hospitals NHS Trust.
The DBA will be responsible for the maintenance and efficiency of the data warehouse. Therefore, you will need to have
- Practical experience utilising MS SQL Server 2018 upwards.
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
- Ability to manage and maintain SSAS, SQL scripts, stored procedures, database agent jobs, Windows scheduled tasks.
- Strong knowledge of index management, integrity checks, configuration. How statistics work, how indexes are stored, how they can be created and managed effectively.
- Working knowledge of database shrink operations, DBCC commands.
- Solid understanding of SQL Server Reporting Services (SSRS).
For more details, please refer to the job specification.
Our service hours are between 8:30 am and 5:00 pm. However, we do offer hybrid working (office/home) and flexible working patterns.
If you require any further details regarding the position please contact Michelle Furniss, Head of Information via email michelle.furniss@nhs.net or Pete Singleton, Information Service Manager pete.singleton1@nhs.net .
Main duties of the job
The primary responsibilities include -
- Monitoring the performance of the server and identifying bottle necks.
- Identifying long running processes and inefficient queries
- Identifying and creating missing indexes
- Identifying and removing unused indexes
- Identifying and removing unused data items
- Building new tables
About us
You will be working for an organisation which values and respects all of its staff and the community it serves. The Trust is a leader in the NHS and research sectors and provides excellent benefits for its staff. This includes commitments to professional development but also many policies to support employees in balancing their personal and professional lives.
The Information Service's role is to -
Provide information to support the business planning, negotiation and monitoring of the legally binding contract for the Trust.
Provide information support to the clinical coding service to ensure that the activity undertaken by the Trust is coded completely and accurately to ensure that the Trust secures the income that properly reflects its case mix complexity.
Provides the necessary high-quality data, information and analysis to enable performance management of the Trust at a local, regional and national level.
Provides a central resource/support for Clinical Staff/Operational Directors/Deputy Operational Directors/Service Managers/TEG.
Maintain and manage the cost per case database to ensure the recovery of income.
Ensures that the Trust complies with the data quality aspects of the Information Governance requirements.
Job description
Job responsibilities
Please view the attached Job Description and Person Specification documents for full details regarding this post.
When completing your application please ensure that you clearly demonstrate how you meet the role criteria.
Person Specification
Qualifications
- Educated to Masters Degree level, or significant relevant practical experience as a Database Administrator utilising MS SQL Server
- Microsoft SQL Server certification
Experience
- Strong experience in Database Administration from SQL Server 2018 upwards
- Experience in communications and stakeholder management
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
- Experience in Performance Tuning, and Query Optimization including strong knowledge of query plans.
- Expert experience in implementing operational automation
- Manage and maintain SSAS, SQL scripts, stored procedures, database agent jobs, Windows scheduled tasks.
- Experience of working with third party suppliers.
- Experience in the Acute Sector
- Previous experience in project management and planning
Knowledge
- Strong knowledge of indexes, index management, integrity checks, configuration. How statistics work, how indexes are stored, how they can be created and managed effectively.
- Working knowledge of database shrink operations, DBCC commands.
- Solid understanding of SQL Server Reporting Services (SSRS).
- A good understanding of the health and social care environment and roles and responsibilities within it
SKills
- Ability to work alongside IT services to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
- SQL Development - ability to write and troubleshoot SQL Code and design (Stored procs, functions, tables, views, triggers, indexes, constraints).
- Ability to gather, analyse, interpret and report on information and knowledge, related to ideas and concepts in relation to database administration to influence key decisions.
- Develop others' knowledge & practice in area of work
- Ability to influence IT and lead others in the development of knowledge, ideas and work practice relating to database technologies.
- Ability to establish and maintain peer review SQL scripts to identify performance issues and rectify or provide support and guidance.
- Ability to configure ODBC links to other data sources.
Other Factors
- A clear understanding of the Trust PROUD Values.
- Ability to work under pressure and to tight deadlines.
- Proactive and personally motivated
- Excellent team player, positive attitude, tenacious, co-operative, flexible, hard working. Shows initiative. Professional attitude.
- Accurate with attention to detail.
- Commitment to continuing professional development.
- Communicates with individuals and groups about difficult or highly complex matters at all levels and both technical and non-technical audiences
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.
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website.
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants.
Employer details
Employer name
Sheffield Teaching Hospitals NHS Foundation Trust
Address
Northern General Hospital
Herries Road
Sheffield
S5 7AU
https://www.sth.nhs.uk
- Company
- Sheffield Teaching Hospitals NHS Foundation Trust
- Location
- Sheffield, United Kingdom S5 7AU
Hybrid / WFH Options - Employment Type
- Permanent
- Salary
- £46148.00 - £52809.00 a year
- Posted
- Company
- Sheffield Teaching Hospitals NHS Foundation Trust
- Location
- Sheffield, United Kingdom S5 7AU
Hybrid / WFH Options - Employment Type
- Permanent
- Salary
- £46148.00 - £52809.00 a year
- Posted