Gloucestershire Hospitals NHS Foundation Trust

Database Administrator - Band 7

This job is now closed

Job summary

We are looking for a keen and enthusiastic SQL Server Database Administrator to join the IT Department . Working for the Team Lead you be responsible for keeping the trusts Vital Applications available and up to date so that patients can receive the first class service they deserve.

Main duties of the job

This role is responsible for providing operational database services for the trust. This is a production DBA role but it will also include some developmental and migration activities. Some of the primary responsibilities include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents with SLAs, responding to database related alerts and escalations and leading on establishing strategic solutions to recurring problems.

The focus of this role is to manage the technical configuration and maintenance of the Trusts SQL Servers, and ensuring that the EPR and associated application Clusters are resilient and running correctly, and to consolidate and assist in the management of the road map for SQL and RDBMS services for the trust in the future.

About us

At Gloucestershire Health and Care NHS Foundation Trust, we are supportive of the people we care for in the community and aim to provide a fully responsive service to everyone who needs it. This is the same approach we take for our employees. We look to value the skills and experiences of those we work with, whether they are service users, carers, families or those looking to work with us.

Gloucestershire Health and Care NHS Foundation Trust is part of the NHS. We treat NHS patients according to NHS principles and standards. The difference is the Trust is accountable to local people, rather than to Government, and so we are able to work closely with our community to develop services in the way that best suits the needs of local people.

Our Staff Survey results showed people at our Trust feel they are engaged, part of a team and work for a compassionate and inclusive organisation.

Our overall scores were better than average in eight of nine themes and level in one - the best overall results for a community, mental health and learning disabilities Trust in the south west and first equal amongst all sector NHS providers within the region too.

Date posted

13 November 2023

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year per annum

Contract

Permanent

Working pattern

Full-time

Reference number

318-23-COR-R11774-A

Job locations

Gloucestershire Royal

Great Western Road

Gloucester

GL1 3NN

Job description

Job responsibilities

- Development and maintenance of an RDMBS strategy and associated programme of implementation

- Development and maintenance of an overall SQL environment to support clinical systems architecture

- Contributing to development and maintenance of wide digital strategies

- Proposing system developments to improve workflows, operational processes and release efficiencies during systems acquisitions or upgrades.

- Contribute to countywide application strategies and programmes as part of collaborative work (e.g. shared records portals)

- Keep abreast of research and knowledge in the healthcare development standards, interoperability and other technologies.

- Development of technical Output based specifications for agreed interfaces working with IT, IM, IT Security, IG, clinical, operational colleagues and system suppliers. This will include turning potentially vague user requirements into a robust specification working with business analysts or acting as the business analyst.

- Designing and developing fully working systems using structured and formal methods

- Development of test plans for end-to-end solution testing using a wide range of technical and non-technical users.

- Production of support documentation and pro-active handover to support personnel.

- Using structured process (e.g. change and release management) to move systems and updates into live operation.

- To advise on best practice on use of technology, systems and developments.

- Calculate resources required (people, hardware, software, third party) to design and build interfaces to help with production of business cases.

EPR Technical Application Maintenance

- To establish a proactive monitoring system to ensure SQL is operating as expected and an alerting mechanism when issues arise.

- Skilling, via documentation and training, systems support teams in the maintenance of custom scripts and systems to diagnose and fix issues within their skill set and scope of role.

- To be the point of escalation for resolution of issues where support teams are unable to resolve.

- Working with technical teams and external suppliers to diagnose and resolve issues.

- To take the lead on changes to existing system technical configuration as a result of changed requirements or systems change.

Application Development Management

- To take a role as a system owner for SQL and associated applications, ensuring pro-active monitoring solutions are in place to ensure they operate reliably and performance is acceptable. This will entail capacity management, service management and change and release management

- To ensure the security of the SQL & associated application platforms working with other IT and Security colleagues