SQL Database Administrator

Job description

Job responsibilities

To create and manage MS databases including Table Management, procedures, views, indexes, triggers, and replication.

Working with database software to find ways to store, organise, and manage data.

Run complex database queries to extract data for audit and performance monitoring.

Proactive troubleshooting and optimising using available monitoring tools.

Work with Systems Operations Team to ensure that security updates are current, and that database access is approved and monitored.

Helping with database design and development. This includes opportunities for automation.

Designing maintenance procedures and putting them into operation.

Ensuring that databases meet user requirements.

Liaising with 3rd parties' programmers & DBAs, applications/operational staff, IT project managers and other technical staff.

Defining objectives through consultation with staff at all levels.

Testing and modifying databases to ensure that they operate reliably. This includes testing failovers and ensuring documentation around Disaster Recovery and Business Continuity are kept up to date.

Create and maintain existing SQL jobs. Plus, archiving data.

Support the design and build of data pipelines from clinical systems to our Data Warehouses.

Support in the development of new ways to store and present data.

Communicate between technical and non-technical stakeholders as well as facilitate discussions within a multidisciplinary team.

Keep abreast of best practice in data engineering across industry, research and Government and facilitating the adoption of standards.

Ensure that data is processed in accordance with policies and procedures.

Responsible for supporting senior and service management in the strategic planning within the department and audits. This includes meeting DSPT requirements.

Using highly developed specialist knowledge, underpinned by theory and experience, to provide expert technical guidance and support to the Systems Teams in identifying and resolving complex infrastructure issues.

Collaborate with the Systems Manager and Head of Technical Services to develop and implement strategies and policies that align with the organisation's goals and objectives. This includes dealing with highly complex, sensitive, and contentious information.

Collaborate with the Systems Manager on a range of documentation; including but not limited to, business cases, infrastructure reviews, restructures, prioritisation work, and both internal and third-party audits.

Identifying and testing technical improvements and opportunities for automation and monitoring to optimise the infrastructure's performance.

Knowledge of creating and updating replication subscriptions with new articles.

For further details please see attached JD&PS.

Person Specification

Knowledge and Experience

• Graduate calibre professional with demonstrable experience supporting and managing enterprise scale SQL environments. Certification in managing and administering SQL Server Expert SQL server skills used in a critical operational environment.
• Significant demonstrable experience of database administration and design in the delivery of a corporate system; including configuration of Availability Groups and clustering. Excellent scripting and replication knowledge.
• Demonstrable experience of managing large-scale, complex SQL configurations and planning system upgrades/migrations/ refreshes including writing/review of high-level/low-level designs along with migration plans.

• Professional qualification. or equivalent demonstrable experience. to Masters level.
• Awareness: up to date with the NHS Programme for IT and other national directives. SQL Azure demonstrable experience.

Qualifications

• Educated to degree level or equivalent relevant demonstrable experience Technical courses specifically in the management, configuration, and support of SQL databases.

• Masters Degree Specialist training and relevant study to Master's degree or equivalent level Management/leadership qualifications

Aptitude & Abilities

• Ability to act on own initiative to solve highly complex technical problems within a short period, by looking at complex facts or situations; analysing, interpreting and comparing a range of available options.
• Ability to remain calm and cope effectively with critical network and system failures.
• Ability to plan, initiate and coordinate work programmes and make adjustments as required. The ability to work under pressure, to deadlines, and deliver.

• Excellent presentation skills

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

University Hospitals Plymouth NHS Trust

Address

Plymouth Science Park

11 Research Way

Plymouth

PL6 8BT

https://www.plymouthhospitals.nhs.uk/