Database Administrator (Senior Technical Role) inSheffield inSheffield PUBLISHED
TUE 22 OCT 2024
The role offers flexible and hybrid working arrangements, with service hours from 8:30 am to 5:00 pm. Ideal candidates should possess strong knowledge of index management, SQL Server Reporting Services (SSRS), and general SQL Server operations, including DBCC commands and database shrink operations. Interested candidates are encouraged to review the full job specifications and provide comprehensive details in their application to demonstrate their suitability for the role.
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 2upwards.
- 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 or Pete Singleton, Information Service Manager .
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
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 wait...this will take a moment...