Job summary
Band 8a Database Administrator (permanent role)
UHNM has a strong record of successful internal developments, in particular a notable success with its clinical portal supporting timely access topatient information for doctors. IM&T are able to offer a fantastic opportunity to join the Software Development team and work with both with otherIM&T teams as well as passionate clinicians in driving forward technology to support their clinical decision-making.
The post holder will develop and maintain multiple 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.
Liaises 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 databases including Table management, procedures, views, indexes and triggers
- Working with database software to find ways to store, organise and manage data
- Troubleshooting
- Keeping databases up to date
- Helping with database design and development
- Managing database access
- Designing maintenance procedures and putting them into operation
- Ensuring that databases meet user requirements
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
- Liaising with programmers, applications/operational staff, IT project managers and other technical staff
- Managing database security/integrity
- Implementing security measures
- 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
- Create and maintain existing SQL jobs
Job description
Job responsibilities
- Liaising with programmers, applications/operational staff, IT project managers and other technical staff
- Managing database security/integrity
- Implementing security measures
- 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
- Create and maintain existing SQL jobs
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).
