Job summary
The Operational Database Administrator (Cach System Manager) will report to the Solution Architect and be responsible for the implementation and administration of the strategic Operational Database (ODB) environments (Cach). The ODB is a critical core component of the Trust's systems and so maintaining high levels of availability and performance is key to the success of the solution. Any delays in the delivery of the warranted environment for Trust would adversely affect digital service delivery so implementation to tight timescales will be required.
The post holder will be responsible for the creation, configuration and on-going management of the ODB environments that serve production, reporting, DR, training and non-production requirements. Proactive monitoring and the implementation of defined and documented processes and procedures will be required to ensure 99.9% availability.
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 3rd party solution providers, automating processes where possible and participating in DR and business continuity tests.
This role is a key technical and operational role within the Applications, Platforms and Infrastructure Team.
Main duties of the job
o Creating and managing the ODB environments that serve production, reporting, disaster recovery, training and non-production needs;o Proactive monitoring of the environment in order to ensure an availability SLA of 99.9% and performance within the agreed SLA;o Deliver suitable reporting mechanisms such that the organisation can be assured of the system meeting the agreed availability and performance requirements, but more importantly to actively manage that reporting and monitoring in order to analyse root causes for problems and to implement plans to remediate them;o Management and deployment of Cach and Trust upgrades and updates to production and non-production environments. Epic upgrades occur on an 8 week cycle;o Provision of on-going BAU support for the system both in-hours and out-of-hours as part of the on-call team;o Document and maintain processes, procedures, and architectural documentation related to the solution actively;o Follow 3rd party vendor and Epic best practices for hardware and software configuration;o Be an Epic EPR subject matter expert on the Chronicles technologies;o Ensure compliance with the Trust Governance Procedures, Policies and Standards for data loads and interfaces;
About us
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.
Job description
Job responsibilities
Foster and develop good working relationships and communications between the Divisional teams and end users; Establish productive working relationships with 3 rd party technical leads; Ensure that robust, documented change control procedures are embedded into the programme of work for the Division; Ensure effective communication throughout all programme implementations, and beyond, with the BAU teams in order to ensure a successful go-live and effective support thereafter;
Analyse highly complex performance models to in order to optimise database performance and ensure non-stop availability; Analyse where tasks (ranging from highly complex to simple) can be automated or scripted in order to ensure consistency and efficiency, and write scripts and processes to implement that automation; Be an Epic EPR subject matter expert on the Chronicles operational database environment
Create and adapt complex plans for the delivery of the strategic Trust operational environments to meet the agreed warranted environment standards; Plan and deliver handover sessions for the BAU teams in order to promote understanding of the solution and provide for effective support following the implementation; Manage system monitoring reports actively in order to analyse root causes for problems and implement plans to remediate them; Be a significant influence in the capacity planning exercises with internal teams at all levels, as well as 3 rd party solution providers, in order to ensure availability and performance standards are not compromised by planned changes;
Job description
Job responsibilities
Foster and develop good working relationships and communications between the Divisional teams and end users; Establish productive working relationships with 3 rd party technical leads; Ensure that robust, documented change control procedures are embedded into the programme of work for the Division; Ensure effective communication throughout all programme implementations, and beyond, with the BAU teams in order to ensure a successful go-live and effective support thereafter;
Analyse highly complex performance models to in order to optimise database performance and ensure non-stop availability; Analyse where tasks (ranging from highly complex to simple) can be automated or scripted in order to ensure consistency and efficiency, and write scripts and processes to implement that automation; Be an Epic EPR subject matter expert on the Chronicles operational database environment
Create and adapt complex plans for the delivery of the strategic Trust operational environments to meet the agreed warranted environment standards; Plan and deliver handover sessions for the BAU teams in order to promote understanding of the solution and provide for effective support following the implementation; Manage system monitoring reports actively in order to analyse root causes for problems and implement plans to remediate them; Be a significant influence in the capacity planning exercises with internal teams at all levels, as well as 3 rd party solution providers, in order to ensure availability and performance standards are not compromised by planned changes;
Person Specification
Qualifications and Training
Essential
- Educated to degree level in a relevant subject plus Masters degree level or equivalent experience
Desirable
- Epic Certification in appropriate modules
Knowledge and Experience
Essential
- Expert Linux skills, particularly with RHEL 7, using the CLI
- Excellent scripting knowledge with a particular focus on the creation of reusable scripts for automating routine tasks
- Excellent technical knowledge and practical experience of server virtualisation technologies
- Application of appropriate theoretical and practical methods to the analysis and solution of digital problems
- Significant experience of database administration and design in the delivery of a corporate systems
- Experience of managing 24/7 x 365 critical systems to a high level
- Experience of managing structured application build and release
- Experience of the IT security and other relevant areas of NHS Information Governance and the DSPT requirements
Desirable
- Knowledge of NHS Information Standards and their application in technical infrastructure
- Understanding of ITIL processes
- Strong Cach skills in a critical operational environment
Specific Skills
Essential
- Connects with colleagues to collaborate effectively and recognise different organisational structures and cultures
- Effective engagement, promoting teamwork and a feeling of pride by valuing individuals' contributions and ideas
- Holding colleagues to account by creating clarity about expectations and what success looks like in order to focus people's energy
- Highly effective interpersonal, communication and people management skills when dealing with highly complex information
Person Specification
Qualifications and Training
Essential
- Educated to degree level in a relevant subject plus Masters degree level or equivalent experience
Desirable
- Epic Certification in appropriate modules
Knowledge and Experience
Essential
- Expert Linux skills, particularly with RHEL 7, using the CLI
- Excellent scripting knowledge with a particular focus on the creation of reusable scripts for automating routine tasks
- Excellent technical knowledge and practical experience of server virtualisation technologies
- Application of appropriate theoretical and practical methods to the analysis and solution of digital problems
- Significant experience of database administration and design in the delivery of a corporate systems
- Experience of managing 24/7 x 365 critical systems to a high level
- Experience of managing structured application build and release
- Experience of the IT security and other relevant areas of NHS Information Governance and the DSPT requirements
Desirable
- Knowledge of NHS Information Standards and their application in technical infrastructure
- Understanding of ITIL processes
- Strong Cach skills in a critical operational environment
Specific Skills
Essential
- Connects with colleagues to collaborate effectively and recognise different organisational structures and cultures
- Effective engagement, promoting teamwork and a feeling of pride by valuing individuals' contributions and ideas
- Holding colleagues to account by creating clarity about expectations and what success looks like in order to focus people's energy
- Highly effective interpersonal, communication and people management skills when dealing with highly complex information
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.
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).
Additional information
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.
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).
