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.
For further information please refer to the job description and person specification document attached.
About us
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.
Job description
Job responsibilities
- Manage the MS SQL Database Farm which houses over 100 clinical 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
- Analyses, investigates and resolves complex IM&T queries and issues/problems including, System errors, breaches of security or confidentiality, user requirements, which may require configuration of software and hardware, unusual data trends, training requirements, based on needs analysis.
- Develop software which is needed to support and complement the Trusts 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
- To act as a technical liaison person for third party suppliers.
- Implements ICT policies and proposes changes to improve service
- To troubleshoot ETL issues and Cogito platform issues when required.
- To deploy EPIC cogito upgrades
- 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.
Professional, technical and innovative skills:
- Ability to provide and present information ranging from simple to highly complex to an audience of any size that will contain listeners of differing levels of understanding
- Ability to analyse and form an opinion on solutions ranging from simple to highly complex when presented by several different suppliers
- Ability to accurately produce written documents relating to standards and technical specifications
- Stakeholder engagement the ability to engage with the local organisations and third party suppliers
- Resource management ability to identify resource needs
- Ability to work with and deliver within a fixed project timescale
- Willingness to roll-up the shirt sleeves and deliver
- Communication skills the ability to communicate clearly and effectively within the local organisation and External Suppliers.
- Ability to manage and undertake formal testing activities
- Ability to suggest and implement novel software and hardware solutions to particular clinical and non-clinical IT related issues
System Support
- To troubleshoot SQL farm and Cogito platform issues and resolve system issues quickly and responsibly.
- Installation and support of Database/cogito Systems Software.
- Monitor the Database Farm and cogito platform, identifying any issues and respond to them appropriately.
- To be the key contact for 3rd party suppliers support teams.
- Ensure that the good relationships that Kings and GSTT has with its suppliers are maintained.
- Ensure that the databases and services are running efficiently and effectively.
- Ensure that the procedures for the management of all of the Farm servers meets the need of the system(s).
- Ensure that all databases are properly backed-up and the disaster recovery procedures are effective and up to date.
- Regular health checks of the software & database
For further information please refer to the job description and person specification document attached.
Job description
Job responsibilities
- Manage the MS SQL Database Farm which houses over 100 clinical 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
- Analyses, investigates and resolves complex IM&T queries and issues/problems including, System errors, breaches of security or confidentiality, user requirements, which may require configuration of software and hardware, unusual data trends, training requirements, based on needs analysis.
- Develop software which is needed to support and complement the Trusts 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
- To act as a technical liaison person for third party suppliers.
- Implements ICT policies and proposes changes to improve service
- To troubleshoot ETL issues and Cogito platform issues when required.
- To deploy EPIC cogito upgrades
- 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.
Professional, technical and innovative skills:
- Ability to provide and present information ranging from simple to highly complex to an audience of any size that will contain listeners of differing levels of understanding
- Ability to analyse and form an opinion on solutions ranging from simple to highly complex when presented by several different suppliers
- Ability to accurately produce written documents relating to standards and technical specifications
- Stakeholder engagement the ability to engage with the local organisations and third party suppliers
- Resource management ability to identify resource needs
- Ability to work with and deliver within a fixed project timescale
- Willingness to roll-up the shirt sleeves and deliver
- Communication skills the ability to communicate clearly and effectively within the local organisation and External Suppliers.
- Ability to manage and undertake formal testing activities
- Ability to suggest and implement novel software and hardware solutions to particular clinical and non-clinical IT related issues
System Support
- To troubleshoot SQL farm and Cogito platform issues and resolve system issues quickly and responsibly.
- Installation and support of Database/cogito Systems Software.
- Monitor the Database Farm and cogito platform, identifying any issues and respond to them appropriately.
- To be the key contact for 3rd party suppliers support teams.
- Ensure that the good relationships that Kings and GSTT has with its suppliers are maintained.
- Ensure that the databases and services are running efficiently and effectively.
- Ensure that the procedures for the management of all of the Farm servers meets the need of the system(s).
- Ensure that all databases are properly backed-up and the disaster recovery procedures are effective and up to date.
- Regular health checks of the software & database
For further information please refer to the job description and person specification document attached.
Person Specification
Qualifications/ Education
Essential
- Educated to Degree level or equivalent qualification
- Postgraduate qualification or equivalent experience
Desirable
- Masters degree or equivalent postgraduate qualification
- EPIC accreditation
Previous experience
Essential
- Significant Experience of working in a Hospital environment
- Considerable experience of working with databases
- Expert Experience of managing mission critical software
Desirable
- Demonstrable experience working with various database formats
Skills/Knowledge/ Ability
Essential
- Expertise in problems solving, able to analyse and interpret highly complex Database problems using own initiative and ability to support others to develop this skill.
Desirable
- In depth specialist knowledge of NHS Information Technology procedures and expertise in NHS ICT system management
- Expert knowledge of the key issues around system implementation
Person Specification
Qualifications/ Education
Essential
- Educated to Degree level or equivalent qualification
- Postgraduate qualification or equivalent experience
Desirable
- Masters degree or equivalent postgraduate qualification
- EPIC accreditation
Previous experience
Essential
- Significant Experience of working in a Hospital environment
- Considerable experience of working with databases
- Expert Experience of managing mission critical software
Desirable
- Demonstrable experience working with various database formats
Skills/Knowledge/ Ability
Essential
- Expertise in problems solving, able to analyse and interpret highly complex Database problems using own initiative and ability to support others to develop this skill.
Desirable
- In depth specialist knowledge of NHS Information Technology procedures and expertise in NHS ICT system management
- Expert knowledge of the key issues around system implementation
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
