Description
We are looking for SQL DBA in Birmingham location for contract with one of our leading client.
JOB INFORMATION:
The post holder will be part of a dedicated team responsible for the implementation and management of all the underlying infrastructure and platforms. This consists of the application delivery platform, web Servers, printing infrastructure, virtualisation, storage, and database management.
In order to ensure appropriate support and management for environments and subsystems, it is critical to establish close communications with the full infrastructure and BAU teams.
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 DR and business continuity tests.
PROFESSIONAL
Installation and management of the various infrastructure and platform elements which provide the foundation of the Epic solution. Including, but not limited to, application deployment platforms, web Servers, database Servers, data warehouse environment, backup system, storage, virtualisation platform, print server management and end user computing.
RESPONSIBILITIES:
Creating and managing the ODB environments that serve production, reporting, disaster recovery, training and non-production needs;
Proactive monitoring of the environment in order to ensure an availability SLA of 99.9% and performance within the agreed SLA;
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;
Management and deployment of Caché and Epic upgrades and updates to production and non-production environments.
Provision of on-going BAU support for the system both in-hours and out-of-hours as part of the on-call team;
Document and maintain processes, procedures, and architectural documentation related to the solution actively;
Work with the infrastructure teams in order to promote understanding of the ODB role within the Epic system, and to ensure that the BAU teams are able to take on a supporting role in the on-going management of the solution;
Follow 3rd party vendor and Epic best practices for hardware and software configuration;
Attend Epic seminars, user groups and meetings on relevant topics;
Be an Epic EPR subject matter expert on the Chronicles technologies;
Ensure compliance with the Trust Governance Procedures, Policies and Standards for data loads and interfaces;
Undertake additional, specific project work in support of the Taurus programme under the direction of the Head of ICT, Programme Manager, Digital Transformation Programme Lead and/or Technical Design Lead.
COMMUNICATION AND WORKING:
Develop good working relationships and communications between the Technical Design Team, Application Design and Delivery Team and the ICT BAU teams.
Establish productive working relationships with Epic technical leads.
Ensure that robust, documented change control procedures are Embedded into the programme of work for the delivery of Epic.
Ensure effective communication throughout the implementation, and beyond, with the BAU teams to ensure a successful go-live and effective support thereafter.
Negotiate, advise and instruct where required with BAU teams to ensure they understand the requirements of Epic and work closely to ensure successful go-live
Effectively translate highly technical aspects of the of the ODB architecture design into understandable concepts and language for other members of the Programme teams
ANALYTICAL AND JUDGEMENT:
Analyse highly complex performance models to to optimise database performance and ensure non-stop availability.
Analyse where tasks (ranging from highly complex to simple) can be automated or scripted 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.
PLANNING AND ORGANISATIONAL SKILLS:
Create and adapt complex plans for the delivery of the strategic EPR operational environments to meet the agreed warranted environment standards.
Plan and deliver handover sessions for the BAU teams to promote understanding of the solution and provide for effective support following the implementation.
Manage system monitoring reports actively to analyse root causes for problems and implement plans to remediate them.