Job summary
Barts Health ICT is looking for an experienced Database Administrator, to lead on the Trust's large SQL database applications and work as part of the ICT Server Team.
As a Database Administrator, you will be working within the ICT Server Team to support and lead on maintaining, configuring and developing the Trust's database infrastructure. You will need to ensure the availability, performance, integrity and the security of all databases within the organisation are meeting all requirements.
To be successful in this role you will have experience of Database Administration in SQL server including performance tuning, maintenance, troubleshooting and design. You will also need to have experience of virtualisation technologies and their configurations.
Main duties of the job
- Review, develop, deliver and promote efficiency and stability across the Rational Database Management environment and ensure databases are protected and secured.
- Act as a subject matter expert/technical lead for designing and implementation of the RDBM environment, ensuring the environments (live, test) is optimal at all times by monitoring and tuning the database environment, to ensure system integrity and performance.
- Develop and apply specialist knowledge in database environments, acting as anSME ensuring all environments are maintained with the agreed service levelsensuring availability, capacity, resilience and security.
- Analyse, troubleshoot, respond to and resolve database problems and complex issues to ensure system availability and that application and system outages, downtimes and slowdowns are resolved as quickly as possible to provide the service back to staff.
- Establish policies and procedures pertaining to the management, security, maintenance and use of the database management system.
- Lead on the technical aspects of RDMS projects to ensure delivery within time, budget and quality, including raising any risks/issues with proposed mitigations.
- Responsible for performing software installation and configuration tasks including
- liaison with third party support where necessary to complete the work successfully.
About us
Barts Health is one of the largest NHS trusts in the country, and one of Britain's leading healthcare providers.
The Barts Health group of NHS hospitals is entering an exciting new era on our improvement journey to becoming an outstanding organisation with a world-class clinical reputation. Having lifted ourselves out of special measures, we now have the impetus and breathing space to chart a fresh course in which we are continually striving to improve all our services for patients.
Our vision is to be a high-performing group of NHS hospitals, renowned for excellence and innovation, and providing safe and compassionate care to our patients in east London and beyond. That means being a provider of excellent patient safety, known for delivering consistently high standards of harm-free care and always caring for patients in the right place at the right time. It also means being an outstanding place to work, in which our WeCare values and behaviours are visible to all and guide us in how we work together.
We strive to live by our WeCare values and are committed to promoting inclusion, where every staff member has a sense of belonging. We value our differences and fully advocate, cultivate and support an inclusive working environment.
Job description
Job responsibilities
The full job description provides an overview of the key tasks and responsibilities of the role, and the person specification outlines the qualifications, skills, experience, and knowledge required. For both documents, please view the attachment/s below.
Job description
Job responsibilities
The full job description provides an overview of the key tasks and responsibilities of the role, and the person specification outlines the qualifications, skills, experience, and knowledge required. For both documents, please view the attachment/s below.
Person Specification
Experience
Essential
- Significant knowledge, expertise and experience of working in a large organisation supporting over 1000 users, with proven and extensive DB Admin experience
- Experience in writing SQL and maintaining multiple business critical databases
- Experience of troubleshooting technical and performance problems with SQL Server architectures
- Has demonstrable experience/ability in the analysis of complex user and systems requirements and the translation of these requirements into the successful design, build, and implementation of information systems
- Significant experience of database performance tuning, optimisation and indexing
- Significant experience of working in an ITIL environment
- Demonstrable experience in reviewing database solutions and making recommendations
Desirable
- Previous experience in a similar position within the NHS or healthcare provider supporting over 10,000 users
Skills
Essential
- Able to resolve urgent, complex technical problems in live systems in a structured and consistent manner and in a way that minimises risk to systems, patients and staff
- Demonstrated capability to plan over short, medium and long-term timeframes and adjust plans and resource requirements accordingly
- Able to handle multiple tasks simultaneously and resolve problems in a sometimes stressful and pressurised environment
- Highly skilled in investigating and analysing complex data and statistics in order to resolve database errors or performance issues for Trust users
- Proactively analyse large data sets to gain insights that help drive product development and service support
- Able to develop, document and maintain support processes using highly developed analytical and judgement skills
- High level of interpersonal and organisational skills - self starter
- Able to interpret and execute action plans and ensure timely delivery
- Demonstrable analytical approach to fault diagnosis
Desirable
- Experience in providing IT technical training
Knowledge
Essential
- Specialist knowledge of, and highly proficient in: Microsoft SQL Server 2012/2016/2019 MS Access DBA HTML Web services TCP/IP and DNS services Data warehouses Data integration, data exchange and data migration Database migration
- Excellent knowledge of computer languages
- Excellent knowledge of computer program design methods and techniques
- Excellent knowledge of Trust based technologies
- Sound knowledge of ICT security principles
- Good awareness and understanding of emerging IT developments and potential implications
Desirable
- Additionally proficient in: Classic ASP and VB Script Microsoft IIS JavaScript, JQuery
Qualifications
Essential
- Educated to degree level in an IT related subject (or equivalent experience)
- Attended recognised professional training courses (e.g. SQL) or equivalent experience
- ITIL Foundation Certificate (or equivalent experience)
Desirable
- Postgraduate qualification such as an MSc, MBA or other appropriate business, engineering or scientific qualification
- MCSA Database Administration, MSCE: Data Management or similar
- PRINCE2 or similar
Person Specification
Experience
Essential
- Significant knowledge, expertise and experience of working in a large organisation supporting over 1000 users, with proven and extensive DB Admin experience
- Experience in writing SQL and maintaining multiple business critical databases
- Experience of troubleshooting technical and performance problems with SQL Server architectures
- Has demonstrable experience/ability in the analysis of complex user and systems requirements and the translation of these requirements into the successful design, build, and implementation of information systems
- Significant experience of database performance tuning, optimisation and indexing
- Significant experience of working in an ITIL environment
- Demonstrable experience in reviewing database solutions and making recommendations
Desirable
- Previous experience in a similar position within the NHS or healthcare provider supporting over 10,000 users
Skills
Essential
- Able to resolve urgent, complex technical problems in live systems in a structured and consistent manner and in a way that minimises risk to systems, patients and staff
- Demonstrated capability to plan over short, medium and long-term timeframes and adjust plans and resource requirements accordingly
- Able to handle multiple tasks simultaneously and resolve problems in a sometimes stressful and pressurised environment
- Highly skilled in investigating and analysing complex data and statistics in order to resolve database errors or performance issues for Trust users
- Proactively analyse large data sets to gain insights that help drive product development and service support
- Able to develop, document and maintain support processes using highly developed analytical and judgement skills
- High level of interpersonal and organisational skills - self starter
- Able to interpret and execute action plans and ensure timely delivery
- Demonstrable analytical approach to fault diagnosis
Desirable
- Experience in providing IT technical training
Knowledge
Essential
- Specialist knowledge of, and highly proficient in: Microsoft SQL Server 2012/2016/2019 MS Access DBA HTML Web services TCP/IP and DNS services Data warehouses Data integration, data exchange and data migration Database migration
- Excellent knowledge of computer languages
- Excellent knowledge of computer program design methods and techniques
- Excellent knowledge of Trust based technologies
- Sound knowledge of ICT security principles
- Good awareness and understanding of emerging IT developments and potential implications
Desirable
- Additionally proficient in: Classic ASP and VB Script Microsoft IIS JavaScript, JQuery
Qualifications
Essential
- Educated to degree level in an IT related subject (or equivalent experience)
- Attended recognised professional training courses (e.g. SQL) or equivalent experience
- ITIL Foundation Certificate (or equivalent experience)
Desirable
- Postgraduate qualification such as an MSc, MBA or other appropriate business, engineering or scientific qualification
- MCSA Database Administration, MSCE: Data Management or similar
- PRINCE2 or similar
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).
UK Registration
Applicants must have current UK professional registration. For further information please see
NHS Careers website (opens in a new window).
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).
UK Registration
Applicants must have current UK professional registration. For further information please see
NHS Careers website (opens in a new window).
