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 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 ongoing 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.
Key Responsibilities:
1. Creating and managing the ODB environments that serve production, reporting, disaster recovery, training, and non-production needs.
2. Proactive monitoring of the environment to ensure an availability SLA of 99.9% and performance within the agreed SLA.
3. Deliver suitable reporting mechanisms to assure the organization that the system meets the agreed availability and performance requirements, actively managing that reporting and monitoring to analyze root causes for problems and implement remediation plans.
4. Management and deployment of Cach and Trust upgrades and updates to production and non-production environments. Epic upgrades occur on an 8-week cycle.
5. Provision of ongoing BAU support for the system both in-hours and out-of-hours as part of the on-call team.
6. Document and maintain processes, procedures, and architectural documentation related to the solution actively.
7. Follow 3rd party vendor and Epic best practices for hardware and software configuration.
8. Be an Epic EPR subject matter expert on the Chronicles technologies.
9. Ensure compliance with the Trust Governance Procedures, Policies, and Standards for data loads and interfaces.
#J-18808-Ljbffr