Database and Integration Engineer (B8a)
Flexible working arrangements may be considered and discussions with the recruiting manager regarding this are encouraged.
Job overview
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.
Working for our organisation
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.
Detailed job description and main responsibilities
Please refer to the attached job description and person specification to view the full details for this opportunity at Birmingham Women’s and Children’s 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 criteria- 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
- 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 criteria- 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 criteria- 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
- Previous experience administrating Epic Cogito systems
Professional/Managerial/Specialist Knowledge
Essential criteria- 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
- Previous experience supporting Epic ODBA support role
Other requirements
Essential criteria- 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 criteria- 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.
Should any new information become available, you will be kept informed of this throughout your recruitment process.
As a Trust employee you are required to comply with all legislation and guidance relating to safeguarding children and adults with care and support needs, and promoting their health and welfare. You are required to inform the Head of Safeguarding of any safeguarding concerns about your own children or children you live with.This information will be treated in a confidential manner.