Job summary Major transformation programme seeks enthusiastic, committed individuals to join its dedicated EPR team We are recruiting a new team to work on our exciting new Electronic Patient Record (EPR) programme. Birmingham Women's and Children's NHS Foundation Trust is bringing in a new Electronic Patient Record. This is major transformation programme that will affect almost all Trust employees, supporting them to provide better quality care for our patients and families. We are currently recruiting for a Database and Integration Engineer (B8a) for Birmingham Women's and Children's Hospital. We're looking for the right people to join us on this exciting digital journey and be part of our vision to be a world-leading team, providing world-leading care. The EPR will be a big change for all our patient-facing teams, so we are looking for people with the energy, passion and resilience to manage the complexities and high risks involved to help us deliver this critical programme of work. Main duties of the job This post is a BWC wide post with operational responsibility across the whole organisation for all databases including Epic support activities. The department's Database and Integration Engineer is tasked with the support and maintenance of all 900 or so databases hosted / managed by the ICT department. The department utilises mainly Microsoft Structure Query Language (SQL) technology as such the post holder should possess excellent knowledge of this technology and act as the departments Subject Matter Expert (SME) on SQL database technology. Most of the Trust electronic data are stored in databases. The post holder will set the Trust's database technology strategy and vision with the HOD and will make decisions on the operations of all Trust SQL Database Management Systems (DBMS). The post holder, will when required, lead junior or contract staff. This post has responsibilities for continually improving database performance and maintaining their data quality and integrity, namely accuracy, completeness, consistency and validity. As the department regularly updates the Trust systems, the post holder is expected to regularly plan and manage several database projects, often simultaneously, throughout the year and which may exceed 50 in a year. The post holder will also design and implement new database systems. About us Birmingham Women's and Children's NHS Foundation Trust is the first of its type in the UK. Our Trust was formed in February 2017 to drive forward our commitment to provide the highest quality, world-class physical and mental health care for our women, children and families. Uniting our hospitals means more seamless care; more investment to make greater advances in our specialist treatment and world-leading neo-natal and fetal work. Importantly, it also gives us a greater voice in shaping the future of family-centered care. Birmingham Children's Hospital is a UK leading specialist paediatric centre with an international reputation in several areas. Birmingham Women's Hospital is one of two dedicated women's hospitals in the UK, with the busiest single site maternity unit, delivering more than 8,200 babies a year offering a full range of gynaecological, maternity and neonatal care. Forward Thinking Birmingham (FTB) Mental Health Services are a unique, innovative community and inpatient mental health partnership. Alongside partners FTB offers care pathways of mental health assessment and treatment for young people aged 0-25 years old. Our Trust is committed to creating the best place to work. We believe in promoting and enhancing inclusion, diversity and equality and encourage applications from all areas of the community, who meet the criteria for the role, regardless of age, gender identity, disability, race, religion or sexual orientation. Date posted 28 January 2025 Pay scheme Agenda for change Band Band 8a Salary £53,755 to £60,504 a year n/a Contract Permanent Working pattern Full-time, Flexible working, Home or remote working Reference number 284-25-6909428-COCM Job locations Birmingham Women's and Children's Hospital NHS 90 Vincent Drive Birmingham B15 2TT Job description Job responsibilities Please refer to the attached job description and person specification to view the full details for this opportunity at Birmingham Womens and Childrens NHS Foundation Trust. When completing your application, please ensure you have evidenced how you meet the job description and person specification to include transferable experience, qualifications, skills along with professional registration details (if applicable). Occasionally we receive a large number of applications for our roles and when that happens we sometimes bring the closing date forward, so please apply promptly to avoid disappointment. Job description Job responsibilities Please refer to the attached job description and person specification to view the full details for this opportunity at Birmingham Womens and Childrens NHS Foundation Trust. When completing your application, please ensure you have evidenced how you meet the job description and person specification to include transferable experience, qualifications, skills along with professional registration details (if applicable). Occasionally we receive a large number of applications for our roles and when that happens we sometimes bring the closing date forward, so please apply promptly to avoid disappointment. Person Specification Qualifications Essential Evidence of Masters Level or equivalent postgraduate degree in Computer Science or related field Qualified in a recognised Project Management and IT Service Management methodology with established links with professional bodies (ITIL, Prince2, ITSM, BCS accreditation preferred) Specialist training in MS SQL Database Server Administration and Maintenanc Desirable Rhapsody certification in HL7 messaging (Practitioner and/or Foundation). Process recognised relevant IT qualifications (e.g. MSCE, MCTS etc). Knowledge and Nature of Experience Essential Experience in the delivery of customer service. Experience in working in team environments. Substantial experience in managing a significantly sized database environment. Significant MS SQL Database Administration 2014 / 2016/ 2017/ 2019 experience. Significant experience in Administration, Maintenance and development of MS SQL Database 2014 / 2016 / 2017 / 2019 Significant experience with reconfiguring unsupported or legacy systems to connect to new database locations. Experience of managing concurrent projects and conflicting priorities. Moderate experience in object oriented programming development (e.g. using Java, C#, JSP, C++) Extensive experience of scripting languages and protocols in particular PowerShell, JavaScript, JScript, VBScript, PHP, XML and HTML. Substantial experience of coSubstantial experience and knowledge of developing or implementing and configuring SQL Server Services (SSIS, SSAS, SSRS and PBIRS) and their tasks. mmunicating complex issues and data concepts to a range of people. Experience in the use of Power BI. Considerable experience in the use of Excel and InfoPath for SharePoint and interfacing them with databases. Experience in developing and managing a SharePoint server. Understanding of SQL data warehouse Understanding of SQL Server database cloud computing hosting such as AWS. Basic knowledge of IT networking. Awareness of ETL technology used in SQL Server data warehouse Analytical and Judgement Skills Essential Modest experience in supporting a system interface solution (e.g. Rhapsody, Ensemble etc). Considerable experience dealing with enquiries and investigating solutions in a modern IT environment Significant experience in maintaining technical documentation Excellent problem-solving skills. Can diagnose complex system or database issues and provide solutions. Pragmatic in making decisions for the business. Understand what is essential to the business Desirable Previous experience administrating Epic Cogito systems Professional/Managerial/Specialist Knowledge Essential Understanding of the NHS. Expert level of MS SQL knowledge. Expert level of database design skills. Sound level of enterprise system architecture. Proficient knowledge of data integration technology including HL7 standards. Understanding of specialist IT systems. Good level of technical skills, theory and practice, in designing systems, handling sensitive data and automating data processing. Structured and diagnostic approach to finding solutions to complex data issues. Good knowledge of Software development life cycles and managing their stages. Advanced skills in VB/VBA and Microsoft Access database Working knowledge of other database technologies (MySQL, PostgreSQL, Gupta SQLBase, Oracle Desirable Previous experience supporting Epic ODBA support role Other requirements Essential Understanding of rules around information governance, protecting patient data security and confidentiality. Excellent knowledge of data security, GDPR and confidentiality issues Respect Confidentiality of Patient Information. Personal Skills/Abilities and Attributes Essential Professional communication skills. Ability to work under pressure and concentrate for long periods of time. Ability to communicate complex technical issues effectively to non-technical staff. Ability to maintain a professional approach under all circumstances particularly with people who are stressed or angry. Ability and desire to learn. Ability to learn, work to and create standard protocols and procedures Excellent interpersonal skills Excellent communication skills Strong analytical skills. Ability to prioritise and effectively manage own workload and workload of others. Self-motivation and ability to work effectively on own or within a team. Attention to detail and ability to resolve problems effectively. Ability to use initiative Confident, decisive, tenacious, highly motivated and able to use own initiative in unfamiliar situations. Share knowledge with others in the department. Flexible and adaptable to change. Person Specification Qualifications Essential Evidence of Masters Level or equivalent postgraduate degree in Computer Science or related field Qualified in a recognised Project Management and IT Service Management methodology with established links with professional bodies (ITIL, Prince2, ITSM, BCS accreditation preferred) Specialist training in MS SQL Database Server Administration and Maintenanc Desirable Rhapsody certification in HL7 messaging (Practitioner and/or Foundation). Process recognised relevant IT qualifications (e.g. MSCE, MCTS etc). Knowledge and Nature of Experience Essential Experience in the delivery of customer service. Experience in working in team environments. Substantial experience in managing a significantly sized database environment. Significant MS SQL Database Administration 2014 / 2016/ 2017/ 2019 experience. Significant experience in Administration, Maintenance and development of MS SQL Database 2014 / 2016 / 2017 / 2019 Significant experience with reconfiguring unsupported or legacy systems to connect to new database locations. Experience of managing concurrent projects and conflicting priorities. Moderate experience in object oriented programming development (e.g. using Java, C#, JSP, C++) Extensive experience of scripting languages and protocols in particular PowerShell, JavaScript, JScript, VBScript, PHP, XML and HTML. Substantial experience of coSubstantial experience and knowledge of developing or implementing and configuring SQL Server Services (SSIS, SSAS, SSRS and PBIRS) and their tasks. mmunicating complex issues and data concepts to a range of people. Experience in the use of Power BI. Considerable experience in the use of Excel and InfoPath for SharePoint and interfacing them with databases. Experience in developing and managing a SharePoint server. Understanding of SQL data warehouse Understanding of SQL Server database cloud computing hosting such as AWS. Basic knowledge of IT networking. Awareness of ETL technology used in SQL Server data warehouse Analytical and Judgement Skills Essential Modest experience in supporting a system interface solution (e.g. Rhapsody, Ensemble etc). Considerable experience dealing with enquiries and investigating solutions in a modern IT environment Significant experience in maintaining technical documentation Excellent problem-solving skills. Can diagnose complex system or database issues and provide solutions. Pragmatic in making decisions for the business. Understand what is essential to the business Desirable Previous experience administrating Epic Cogito systems Professional/Managerial/Specialist Knowledge Essential Understanding of the NHS. Expert level of MS SQL knowledge. Expert level of database design skills. Sound level of enterprise system architecture. Proficient knowledge of data integration technology including HL7 standards. Understanding of specialist IT systems. Good level of technical skills, theory and practice, in designing systems, handling sensitive data and automating data processing. Structured and diagnostic approach to finding solutions to complex data issues. Good knowledge of Software development life cycles and managing their stages. Advanced skills in VB/VBA and Microsoft Access database Working knowledge of other database technologies (MySQL, PostgreSQL, Gupta SQLBase, Oracle Desirable Previous experience supporting Epic ODBA support role Other requirements Essential Understanding of rules around information governance, protecting patient data security and confidentiality. Excellent knowledge of data security, GDPR and confidentiality issues Respect Confidentiality of Patient Information. Personal Skills/Abilities and Attributes Essential Professional communication skills. Ability to work under pressure and concentrate for long periods of time. Ability to communicate complex technical issues effectively to non-technical staff. Ability to maintain a professional approach under all circumstances particularly with people who are stressed or angry. Ability and desire to learn. Ability to learn, work to and create standard protocols and procedures Excellent interpersonal skills Excellent communication skills Strong analytical skills. Ability to prioritise and effectively manage own workload and workload of others. Self-motivation and ability to work effectively on own or within a team. Attention to detail and ability to resolve problems effectively. Ability to use initiative Confident, decisive, tenacious, highly motivated and able to use own initiative in unfamiliar situations. Share knowledge with others in the department. Flexible and adaptable to change. 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. Certificate of Sponsorship 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. Certificate of Sponsorship 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). Employer details Employer name Birmingham Women's and Children's NHS Foundation Trust Address Birmingham Women's and Children's Hospital NHS 90 Vincent Drive Birmingham B15 2TT Employer's website https://bwc.nhs.uk/ (Opens in a new tab)