Database Administrator (Senior Technical Role)

at  Sheffield Teaching Hospitals NHS Foundation Trust

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

Please refer the Job description for details