SQL Database Administrator

Lancashire & South Cumbria NHS Foundation Trust

This job is now closed

Job summary

An exciting opportunity has arisen within our applications management team for an experienced SQL Server Database Administrator.

Lancashire & South Cumbria NHS Foundation Trust is a great place to work and has a sound future as a leading provider of excellent services. The Trust invests in its staff and seeks to provide them with opportunities for training and personal development.

Lancashire & South Cumbria NHS Foundation Trust are seeking an enthusiastic, committed individual to join the Database Administration Team to provide professional expertise ensuring Lancashire & South Cumbria NHS Foundation Trusts Microsoft SQL estate is reliable, resilient and secure.

Main duties of the job

The overall aim of the role:

- Develop, manage and maintain LSCFT complex Microsoft SQL environments.- Analyse and optimise the various LCFT Microsoft SQL 2016, 2019 and 2022 environments.- Provide expert technical guidance and advice to LSCFT staff on SQL technologies and other trust database software.- Deputise for the trust Senior SQL Database Administrator.- Develop and maintain trust Microsoft SQL high availability estate including failover clustering, Always on Availability Groups and Replication.- Develop and maintain technical documentation for the LSCFT Microsoft SQL Server estate.- Liaise with 3rd party suppliers and provide support and expertise for installing and maintaining these systems.- When required act as SQL technical lead on LSCFT projects.

About us

Lancashire & South Cumbria NHS Foundation Trust provides a range of services including secondary mental health care across this area. Specialist provision comprises inpatient child and adolescent mental health services, perinatal mental health and forensic services including low and medium secure care.The Trust also provides a range of physical health and well-being services in the community alongside a range of partners in the Lancashire, Cumbria and Sefton area.Lancashire & South Cumbria Foundation Trust encourages flexible working, we believe that a positive work/life balance benefits NHS employees through improved health and wellbeing. We would consider working patterns such as; term time, part time, compressed hours, flexi-time and career breaks. We encourage applicants to state clearly on their application forms this request and discuss these options at interview.For more information please visit our website via Lancashire & South Cumbria NHS FT

Date posted

02 July 2024

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year per annum

Contract

Permanent

Working pattern

Full-time

Reference number

351-CS2626-LW

Job locations

Sceptre Point

Preston

PR5 6AW

Job description

Job responsibilities

Please see attached the job description and person specification for more information about this role.

Job description

Job responsibilities

Please see attached the job description and person specification for more information about this role.

Person Specification

Qualifications

Essential

Educated to Degree Level or equivalent experience of working in a similar role gaining the specialist knowledge and skills listed below.
Relevant IT qualification e.g. Microsoft Certification, ITIL Foundation or working towards Microsoft Certification.

Knowledge

Essential

Thorough specialist working knowledge of Microsoft SQL server 2016, 2019 and 2022.
Knowledge of using, installing and supporting Microsoft Operating Systems
Extensive knowledge of T-SQL for query writing and optimisation using Microsoft SQL Server 2016, 2019 and 2022

Experience

Essential

Extensive experience of configuration of Microsoft SQL 2016, 2019 and 2022.
Experience of working in a complex IT networked environment
Worked in an ITIL driven environment.

Skills

Essential

Well organised, methodical in your approach to problem solving.
Customer focused and excellent communication skills.
Able to prioritise your workload, ensuring that targets and critical deadlines are always met.

Person Specification

Qualifications

Essential

Educated to Degree Level or equivalent experience of working in a similar role gaining the specialist knowledge and skills listed below.
Relevant IT qualification e.g. Microsoft Certification, ITIL Foundation or working towards Microsoft Certification.

Knowledge

Essential

Thorough specialist working knowledge of Microsoft SQL server 2016, 2019 and 2022.
Knowledge of using, installing and supporting Microsoft Operating Systems
Extensive knowledge of T-SQL for query writing and optimisation using Microsoft SQL Server 2016, 2019 and 2022

Experience

Essential

Extensive experience of configuration of Microsoft SQL 2016, 2019 and 2022.
Experience of working in a complex IT networked environment
Worked in an ITIL driven environment.

Skills

Essential

Well organised, methodical in your approach to problem solving.
Customer focused and excellent communication skills.
Able to prioritise your workload, ensuring that targets and critical deadlines are always met.

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.