Band 7 Senior Engineer - Databases

Job description

Job responsibilities

Work towards being a subject matter expert on the database technologies hosted at the trust to ensure these are optimised for maximum efficiency and in accordance with manufacturers guidance and recommendations for best practice.

Responsible for the management of tickets within the Service Desk system (diagnosing and resolving faults) in accordance with service level agreements and escalating any likely breaches to the Principal Specialists

Will be required to analyse infrastructure problem areas and exercise judgement to resolve technical issues identified through a range of communications methods like IT ServiceDesk, emails, or diagnostic monitoring alerts. This may involve collaboration with personnel from other Digital Services teams and from managed or external system providers.

Provide technical support to other Digital services colleagues, end users; trust and non-trust members: vendors and satellite sites to other NHS organisations.

Proactively monitor the environment by taking necessary interventions indicted by Alerts, Dashboards, and other tools to ensure SLAs, availability and uptime are maximised and align with business RPOs and RTOs.

Provide regular reports on the capacity and performance of the clinical/non-clinical systems and the trusts infrastructure systems to the Principal Systems Specialist for evaluation to ensure these are achieving expectations, identify any constraints or area of improvements.

Ability to organise own workload independently and make autonomous decisions. Must be able to plan, organise and manage complex tasks/projects adjusting priorities when required and be flexible.

Be well practiced in writing detailed technical documentation and ensure that all configuration documentation is maintained and current.

Research and keep up to date with new technologies to improve Digital services.

Be prepared to support planned and unplanned work out of normal working hours as and when necessary. This includes evenings and weekends to cause minimum disruption to the trust.

Will be required to work at any of the three main hospitals on a rota. You may also be required to travel to other office sites for group meetings.

The role will require the post holder to participate in the out of hours on-call rota providing support to key systems.

Person Specification

Royal Free World Class Values

Essential

• Demonstrable ability to meet the Trust Values

Education & professional Qualifications

Essential

• Educated to master's level or equivalent or experience.

Desirable

• o ITIL4 Foundation - IT Service Management Certification
• MCSA database administration
• Project management qualification

Experience

Essential

• Management & facilitation of following ITIL 4 Framework - Availability management - Monitoring and event management - Capacity and performance management - Change control - Incident management - Monitoring and event management - Problem management - Service configuration management - Portfolio management - Supplier and Contracts management - Measurement and reporting - Major Incident Management - Continual improvement - Knowledge management
• Working knowledge of Windows Server Platform with emphasis on Windows Server Failover Cluster (WSFC) to support SQL failover cluster and SQL always On availability groups
• Working experience with VMWare vCentre version 6.5 onwards

Database Skills

Essential

• Experience in Database Administration in SQL Server 2012 up to SQL Server 2022 in a large complex environment.
• Administering and configuring SQL Server for optimal use
• Proficient in managing databases in SQL Server and SQL instances using SQL Server Management Studio (SSMS) or t -SQL to include these activities: - Manage security roles and permissions - Maintain Backups, Database Integrity checks, restores and recovery processes. - Setup maintenance plans - Database migrations - Monitoring activities through server and SQL logs for troubleshooting - Reporting Services (SRRS) - Performance Tuning, and Query Optimisation - Experience in T -SQL Code - Working experience of SQL Server Integration Services (SSIS) and SQL Server

Desirable

• Knowledge of creating and managing SQL clustering capabilities. - Failover Cluster Instances - SQL Server Always on Availability Groups
• Experience in troubleshooting and resolving database problems.
• Exposure of Oracle and open - source databases like MySQL, SQL Base, MongoDB, PostgreSQL

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 (Opens in a new tab).

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 (Opens in a new tab).

UK Registration

Applicants must have current UK professional registration. For further information please see NHS Careers website (opens in a new window).

Employer details

Employer name

Royal Free London NHS Foundation Trust

Address

Royal Free Hospital

Pond Street

London

NW3 2QG

Employer's website

https://www.royalfreelondonjobs.co.uk/ (Opens in a new tab)