ITCS Database Administrator

Job summary

We are a small team of 3 responsible for maintaining the SQL farm for King’s College Hospital (KCH) as well as the EPIC Cogito data warehouse for Guy’s and St Thomas Hospital (GSTT) utilised by the individual Business Intelligence teams.

This is an opportunity for an experienced SQL database administrator with prior clustering experience to join our team, become EPIC Cogito accredited and support our SQL farm and Cogito estate.

The role will require working across sites based in both Denmark Hill and Waterloo and also requires some occasional out‑of‑hours working to support overnight SQL ETL processes as well as some late night Cogito software deployments.

• To maintain the Microsoft SQL Database Farm
• To support the EPIC Cogito databases and infrastructure and provide support to Caboodle business intelligence developers via code migrations, ETL support and deployment of EPIC upgrades.
• To troubleshoot ETL issues and Cogito platform issues when required.
• Act as a training resource for developers, EPIC, and other Secure Data System support roles.
• Provide 3rd line support for Database Farm technical issues.
• Help define system requirements for new developments in conjunction with clinicians, clinical analysts and project managers.
• Provide expert advice to other Trust system managers and the Trust in relation to procurement of high‑cost data systems.
• Develop software which is needed to support and complement the Trust’s databases.
• Provide expert technical documentation to support systems and system development.
• Demonstrate software solutions to other technical and clinical staff.
• Act as a technical liaison person for third‑party suppliers.
• Implement ICT policies and propose changes to improve service.
• When out‑of‑hours support is required for the SQL farm or Cogito platform, the post-holder would be required to do overtime/on‑call and to escalates serious problems to senior members of the team.

• Manage the MS SQL Database Farm which houses over 100 clinically important databases and any associated systems.
• To support the EPIC Cogito databases and infrastructure and provide support to Caboodle business intelligence developers via code migrations, ETL support and deployment of EPIC upgrades.
• To troubleshoot ETL issues and Cogito platform issues when required.
• Act as a training resource for developers, EPIC, and other Secure Data System support roles.
• Provide 3rd line support for Database Farm technical issues.
• Help define system requirements for new developments in conjunction with clinicians, clinical analysts and project managers.
• Provide expert advice to other Trust system managers and the Trust in relation to procurement of high‑cost data systems.
• Analyse, investigate and resolve complex IM&T queries and issues including system errors, breaches of security or confidentiality, user requirements and configuration of software and hardware.
• Develop software which is needed to support and complement the Trust’s databases.
• Test and research new hardware and software platforms to ascertain suitability for Trust deployment.
• Provide expert technical documentation.
• Demonstrate software solutions to other technical and clinical staff.
• Act as a technical liaison person for third‑party suppliers.
• Implement ICT policies and propose changes to improve service.
• Deploy EPIC Cogito upgrades.
• When out‑of‑hours support is required for the SQL farm or Cogito platform, the post-holder would be required to do overtime/on‑call and to escalates serious problems to senior members of the team.

• Ability to present information ranging from simple to highly complex to an audience of any size.
• Ability to analyse and form an opinion on solutions from multiple suppliers.
• Ability to produce accurate written documents relating to standards and technical specifications.
• Stakeholder engagement ability to engage with local organisations and third‑party suppliers.
• Resource management ability to identify resource needs.
• Ability to work within a fixed project timescale.
• Willingness to deliver and roll‑up the shirt sleeves.
• Communication skills to communicate clearly and…