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 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 Trusts databases.
* Provide expert technical documentation to support systems and system development.
* Demonstrate software solutions to other technical and clinical staff.
* To act as a technical liaison person for third party suppliers.
* Implements ICT policies and proposes changes to improve service.
* On occasions where out-of-hours working is required to support either SQL farm or Cogito platform, the post-holder would be required to do overtime/on-call and elevate any serious problems to senior members of the team.
King's College Hospital NHS Foundation Trust (KCH) and Guy's and St Thomas' NHS Foundation Trust (GSTT) are advancing their digital transformation ambitions in a period of increasing operational demand, technological complexity, and rising expectations of service responsiveness.
#J-18808-Ljbffr