Senior Database Adminstrator
Job summary
The post holder will have specialist knowledge of SQL Server and be responsible for the security and support of the databases underpinning the Trusts Information and Clinical systems and reporting tools used in the capture/provision of high quality clinical and management information to end users throughout the Trust. To provide systems support and enhancements for core hospitals systems.
This is a Group-wide role across multiple sites. The Information Services teams are based at Castle Hill Hospital in Cottingham Hull and New Beacon House, Scunthorpe. Teams run a hybrid of office and remote working arrangements.
Main duties of the job
-
- Responsible for ensuring that any SQL Server instances that the department are responsible for remain secure, reliable and available
- Responsible for monitoring of SQL Server to ensure it has not been compromised and that all required security patches are applied in a controlled manner, liaising with key individuals as appropriate if downtime is required
- Provide advice and guidance on the design, configuration, optimisation and secure use of SQL Server databases and associated data services
- Responsible for the installation; patching; and configuration of SQL Server
- Responsible for performance tuning and query optimization
- Responsible for configuration and maintenance of backups, including regular testing of backup and restore procedures
- Responsible for the configuration and monitoring of high-availability and disaster recovery features
- Responsible for configuring and monitoring security and ensuring that security configuration complies with relevant standards and audit recommendations
- Provide assistance to the Business Intelligence team with ETL operations and report creation.
- Provide assistance to the Business Intelligence and Systems Development teams with ETL operations, report creation and database design
- Create and maintain documentation of the SQL server estate and related processes
About us
The Humber Health Partnership is one of the largest acute and community Partnership arrangements in the NHS, seeing well over one million patients every year and managing a budget of over £1.3 billion.
Made up of two Trusts - Northern Lincolnshire and Goole NHS Foundation Trust (NLAG) and Hull University Teaching Hospitals NHS Trust (HUTH) - our Partnership has significant ambitions and is committed to delivering world-class hospital and community services for the 1.65 million people we serve.
Together we employ nearly 20,000 staff. Our five main hospital sites are Diana, Princess of Wales Hospital, Scunthorpe General Hospital and Goole and District Hospital, for NLAG and Hull Royal Infirmary and Castle Hill Hospital for HUTH.
As Teaching Hospitals working with the Hull York Medical School, we both lead and contribute to research in many areas - biomedical research, primary care, palliative medicine, cardiovascular and respiratory medicine, vascular surgery, cancer surgery and oncology.
We believe that by developing a diverse, inclusive, innovative, skilled and caring workforce, we can deliver excellent care to our patients and a great future for our employees, our Partnership and our community.
Job description
Job responsibilities
For more detailed information, please read the job description linked below.
Please note that, in line with UKVI regulations, this vacancy does not meet the eligibility criteria for sponsorship under the Skilled Worker Visa route. As a result, we are unable to issue a Certificate of Sponsorship for this position.
We remain committed to fair and equal recruitment practices and encourage applications from all suitably qualified candidates who have the right to work in the UK.
We reserve the right to close the advert early in the event of high levels of interest. Therefore early applications are encouraged.
Person Specification
Application Completion
- ALL sections of application form FULLY completed
Education/ Qualifications
- Educated to degree standard or demonstrable equivalent experience
- Qualification in Computer Programming
- Evidence of on-going personal development
- Microsoft Certified DBA (MCDBA)
Experience
- Minimum of two years' experience working in a Database Administrator role or comparable role
- Demonstrable experience of Database Administration
- Minimum of five years' experience working in a Database Administrator or comparable role
- DBA experience with other database platforms, such as Oracle and Cache
- Understanding of hospital systems such as Patient Administration Systems an advantage
- Proven experience of the line management of staff
Skills/ Knowledge and Abilities
- Excellent communication skills
- Effective organisational and time management skills
- Project management
- Expert knowledge of SQL Server 2008 R2 onwards
- Expert knowledge of SQL Server high availability technologies such as Always on, Log Shipping, Replication
- Ability to apply analytical skills to complex problem solving in a structured manner
- Ability to test statistical methodology and techniques when analysing complex data and make appropriate recommendations
- High level awareness of data quality and its importance in delivering high quality information
- Good knowledge of change management & project management
- Experience of data analysis and interpretation in a clinical environment
- Knowledge of the NHS Agenda and IT/Information related issues would be an advantage
- Awareness of current technologies and opportunities available to the Trust to develop its information systems
- Knowledge of the complex and varying patient pathways in a variety of services across the Trust would be an advantage
Other Requirements
- Creative and solution orientated
- Diplomatic, persuasive and influential
- Full driving licence and access to personal transport
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.
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.
Employer details
Employer name
Hull University Teaching Hospitals NHS Trust
Address
Castle Hill Hospital
Castle Road
Cottingham
HU16 5JQ
United Kingdom
Employer's website
https://www.hey.nhs.uk/