Guy's and St Thomas' NHS Foundation Trust
Job Summary
We are a small team of 3 responsible for maintaining the SQL farm for King’ 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.
Main duties of the job
- 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 escalate any serious problems to senior members of the team.
To apply for this job please visit apps.trac.jobs.