Interview for Database Administrator (Senior Technical Role)

This question is optional.
You can skip it

jobsincare
Practice Interview

Practice Interview

Database Administrator (Senior Technical Role) • Sheffield
Sheffield Teaching Hospitals NHS Foundation Trust

Thank you for your interest in the position of Database Administrator (Senior Technical Role) in Sheffield with Sheffield Teaching Hospitals NHS Foundation Trust.

Interview Progress What to expect Continue below

You've already answered some of these questions.

We've marked the ones that you've done with a check

You can continue the interview below.

First, we'll enable your camera & microphone and then ask you to record a short introduction about yourself, about 30 seconds long, to make sure your camera is working ok.

Question here

Question ID Question GROUPING

This question is optional. You can skip it

Saving...

Please wait...

The preview image will be black while recording; please just continue to record your answer as normal.

Interview Summary
• Check and Send

Role: Database Administrator (Senior Technical Role) in Sheffield

Interviewed on Monday 25 November 2024 at 13:59.

If everything looks good then click below to send your interview.
Your interview will also be saved to your account.

jbnseneC Sheffield Teaching Hospitals NHS Foundation Trust {"required":[],"optional":[]}

Cancel Interview

{"interviewQueryText":"What are some good interview questions in British English for the job description below?\n\n-------------------------------------------\n\nDatabase Administrator (Senior Technical Role) with Sheffield Teaching Hospitals NHS Foundation Trust in Sheffield\n\n 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 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. "}