Job summary
Band 7 Database Administrator 8months fixed term contract to the 31st March 2025
The post holder will develop and maintain multiple MS databases to support the development of the Trusts in-house developed systems, as well as support the business critical patient care systems for the organisation, that are key to maintaining the continuity of the Trust's business and operational processes. The role will play a key part in designing and creating innovative database design with modern tools and techniques to support efficient and effective business processes for our clinical and non-clinical teams.
The successful candidate will also liaise with third party suppliers and staff across all levels of the Trust in the planning, design and development of highly complex database system solutions.
Main duties of the job
- To create and manage multiple databases including table management, procedures, views, indexes and triggers
- Troubleshooting procedural and performance related issues
- Business as usual - Dealing with data related user help desk calls.
- General house keeps and performance monitoring
- Ongoing performance and optimisation improvements
- Creating relational database designs and development from user requirements.
- Creating fully optimised stored procedures using T-SQL
- Creating low level and high level database design documentation
- Managing database role based access (RBAC)
- Create and maintain existing SQL jobs
- Create and maintain backups
About us
University Hospitals of North Midlands NHS Trust is one of the largest and most modern in the country. Based across two sites, Royal Stoke in Stoke-on-Trent and County Hospital in Stafford, we are proud to serve around three million people and we're highly regarded for our facilities, teaching and research. We are the specialist centre for major trauma for the North Midlands and North Wales.
All of our employees make a valuable contribution regardless of role here at UHNM and we are proud of our wide range of development packages aimed at ensuring that everyone has the opportunity to fulfil their true potential.
UHNM create and encourage a culture of inclusion, providing equal opportunities for career development that are fair and transparent. We are committed to being a diverse and inclusive employer and foster a culture in which all staff feel valued and respected. In return we ask all of our employees to make a commitment to the values, co-created by or staff, patients and carers, and that unite us as a Trust.
At University Hospitals of North Midlands NHS Trust we know that investing in, supporting and developing our staff has a direct impact on the quality of care that we deliver. Our employees are as important as our patients and the population that we serve.
Job description
Job responsibilities
Ensuring that databases meets the technical application requirements Ensure the flow of data from multiple disparate systems via replication and service broker for the user of core application with the trust. The ability to convey solutions at both a technical and non technical level. Managing database security/integrity Defining objectives through consultation with staff at all levels Testing and modifying databases to ensure that they operate reliably Archiving data. Able to run basic traces using SQL profiler
Job description
Job responsibilities
Ensuring that databases meets the technical application requirements Ensure the flow of data from multiple disparate systems via replication and service broker for the user of core application with the trust. The ability to convey solutions at both a technical and non technical level. Managing database security/integrity Defining objectives through consultation with staff at all levels Testing and modifying databases to ensure that they operate reliably Archiving data. Able to run basic traces using SQL profiler
Person Specification
Qualifications
Essential
- Educated to Degree in a computer related discipline, or equivalent work experience
Desirable
- Evidence of continuing professional development, either academic (e.g. MSc) or in an industry standard qualification (e.g. MSCD).
Knowledge, Skills, and Training
Essential
- Knowledge of indexing
- A logical approach to investigating, analysing and resolving data and programming problems.
- Communication of highly complex information to users at all levels internal to the organisation and with external clients, suppliers and vendors.
- Ability to accurately estimate task durations, organise and prioritise own workload and to provide a timely and accurate service
- Excellent computing keyboard skills and proven experience in using SQL Management studio
- An understanding of how applications/systems integrate and work together.
- Knowledge of modern relational database design and implementation
- Knowledge of data privacy laws and in particular NHS IM&T policies and procedures.
Desirable
- Knowledge of hospital information systems, particularly patient administration and clinical management systems
Experience
Essential
- Ability to create and manage MS databases including Table management, procedures, views, indexes and triggers
- Experience of manipulating highly complex data to produce automated reports.
- Experience within a broad and complex corporate IT operational environment.
Desirable
- NHS or private healthcare experience.
- Knowledge of replication
- Knowledge of SQL clusters
- SQL Tuning\Performance
- SQL Security
- SQL profiler
Personal Qualities
Essential
- Excellent written and verbal communication skills, capable of communicating with staff at all levels within the organisation
- Ability to work within a team, in a high pressure environment whilst maintaining operational and project targets.
- Self-motivated and able to work autonomously, with a proactive outlook in the resolution of customer issues.
- A conscientious complete/ finisher with attention to detail and a willingness to share information
- A desire to continue personal professional development, learn new technologies, updating skills and knowledge on an on-going basis.
- Willing to work out of hours if required
Person Specification
Qualifications
Essential
- Educated to Degree in a computer related discipline, or equivalent work experience
Desirable
- Evidence of continuing professional development, either academic (e.g. MSc) or in an industry standard qualification (e.g. MSCD).
Knowledge, Skills, and Training
Essential
- Knowledge of indexing
- A logical approach to investigating, analysing and resolving data and programming problems.
- Communication of highly complex information to users at all levels internal to the organisation and with external clients, suppliers and vendors.
- Ability to accurately estimate task durations, organise and prioritise own workload and to provide a timely and accurate service
- Excellent computing keyboard skills and proven experience in using SQL Management studio
- An understanding of how applications/systems integrate and work together.
- Knowledge of modern relational database design and implementation
- Knowledge of data privacy laws and in particular NHS IM&T policies and procedures.
Desirable
- Knowledge of hospital information systems, particularly patient administration and clinical management systems
Experience
Essential
- Ability to create and manage MS databases including Table management, procedures, views, indexes and triggers
- Experience of manipulating highly complex data to produce automated reports.
- Experience within a broad and complex corporate IT operational environment.
Desirable
- NHS or private healthcare experience.
- Knowledge of replication
- Knowledge of SQL clusters
- SQL Tuning\Performance
- SQL Security
- SQL profiler
Personal Qualities
Essential
- Excellent written and verbal communication skills, capable of communicating with staff at all levels within the organisation
- Ability to work within a team, in a high pressure environment whilst maintaining operational and project targets.
- Self-motivated and able to work autonomously, with a proactive outlook in the resolution of customer issues.
- A conscientious complete/ finisher with attention to detail and a willingness to share information
- A desire to continue personal professional development, learn new technologies, updating skills and knowledge on an on-going basis.
- Willing to work out of hours if required
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).
