Overview
Database Administrator Jobs in Greater Plymouth Area at Torbay and South Devon NHS Foundation Trust
Title: Database Administrator
Company: Torbay and South Devon NHS Foundation Trust
Location: Greater Plymouth Area
The Database Administrator will report to the Solution Architect and be responsible for the implementation and administration of the Trust’s Database, Caboodle and Business Objects environments, which run on MS SQL Server as well as the multipurpose SQL Servers. Caboodle and Business Objects form the core of the Trust’s Data Warehouse and are therefore critical core components of the Epic system.
Maintaining high levels of availability and performance are a key to the success of the solution.
The post holder will be responsible for configuring and managing the reporting environments, and will work closely with the Business Intelligence (BI) teams in order to ensure that the environments are functioning as per the reporting requirements of the Trust. Proactive monitoring and the implementation of defined and documented processes and procedures will be required to ensure availability and performance SLAs are met.
The post holder will be required to be proactive in terms of responding to issues, engaging in capacity planning exercises, collaborating across the technical teams as well as with Epic, automating processes where possible, and participating in Disaster Recovery and Business Continuity tests.
Create and manage the SQL Server database environments, including Clarity and Caboodle, that serve reporting, production, and non-production needs;
Install, configure, and maintain databases to ensure optimal performance and integrity;
Set up and maintain tables, database views and indexes as needed;
Manage user security for the SQL Server database environments;
Maintain database backups and verify restores;
Create and maintain database objects, especially as related to Epic and system updates and upgrades;
Proactive monitoring and management of the environments in order to ensure optimal performance and integrity that meets the agreed availability and quality;
Manage SQL Server and upgrades and updates to production and non-production environments. EPR upgrades occur on an 8 week cycle;
Provide ongoing BAU support for the system both in-hours and out-of-hours as part of the on-call team;
Work with the server administrators to ensure that security updates are current;
Carry out regular risk assessments of the solution in order to recommend actions to ensure that delivery of the Trust’s digital system are not compromised;
Maintain and test failover procedures to ensure high availability;
Be an Epic EPR subject matter expert (SME) on the Caboodle/Clarity database technologies;
Ensure compliance with the Trust Governance Procedures, Policies and Standards for data loads and interfaces;
Why Work With Us
This vacancy is being advertised by Torbay and South Devon NHS Foundation Trust however applications from individuals employed by Royal Devon University Healthcare NHS Foundation Trust and University Hospitals Plymouth NHS Trust are encouraged.
By applying for one of these vacancies you are agreeing for your application and personal information to be shared between the three organisations as necessary to complete the recruitment process.
For further details / informal visits contact: Name: Kenny Starkey Job title: Resourcing Manager – EPR Programme Email address: [email protected]
