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 to patient information for doctors. IM&T are able to offer a fantastic opportunity to join the Software Development team and work with both other IM&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 Trust's 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
Working for our organisation
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 our 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.
Detailed job description and main responsibilities
* Liaising with programmers, applications/operational staff, IT project managers and other technical staff
* 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
* Educated to Degree in a computer related discipline, or equivalent work experience
* Evidence of continuing professional development, either academic (e.g. MSc) or in an industry standard qualification (e.g. MSCD)
Knowledge, Skills, and Training
* 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
* Knowledge of hospital information systems, particularly patient administration and clinical management systems
Experience
* 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
* NHS or private healthcare experience
* Knowledge of replication
* Knowledge of SQL clusters
* SQL Tuning/Performance
* SQL Security
* SQL profiler
Personal Qualities
* 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 ongoing basis
* Willing to work out of hours if required
Employer certification / accreditation badges
Name: Heidi Poole
Job title: Deputy Director of IM&T
Email address: heidi.poole@uhnm.nhs.uk
Telephone number: 01782 679596
Additional information:
Please contact via email:
Phil.harrison@uhnm.nhs.uk (Database Administrator)
simon.talbot@uhnm.nhs.uk (Technical Architect)
#J-18808-Ljbffr