Senior SQL Database Administrator | Lancashire & South Cumbria NHS Foundation Trust
| Posting date: | 28 October 2024 |
|---|---|
| Salary: | Not specified |
| Additional salary information: | £46,148 - £52,809 per annum |
| Hours: | Full time |
| Closing date: | 27 November 2024 |
| Location: | Bamber Bridge, PR5 6AW |
| Company: | Lancashire Care Foundation Trust |
| Job type: | Permanent |
| Job reference: | 6758684/351-CS2661-MS |
Summary
The Digital Department is a leading innovator in healthcare, dedicated to delivering cutting-edge solutions to our patients. We are seeking an experienced Senior SQL Database Administrator to join our dynamic team and contribute to our mission of driving technological excellence and operational efficiency.
The Senior SQL Database Administrator will be responsible for managing and maintaining our on-premise and cloud based SQL databases, ensuring their performance, security, and availability. The ideal candidate will have a strong background in database administration, experience with Azure SQL, and a proactive approach to problem-solving.
We are seeking an enthusiastic, committed individual to join the Database Administration Team to provide professional expertise ensuring the Trust's Microsoft SQL estate is reliable, resilient and secure.
Applications from job share partners are welcome and other forms of flexible working will be considered for all posts.
We welcome applications from people regardless of age, disability (especially people who have experience of accessing mental health, or Learning Disability Services or caring for someone who has accessed mental health services or Learning Disability Services), ethnicity, gender, religion or belief or sexual orientation.
The post holder will be responsible for providing professional technical expertise to ensure LSCFT’s Microsoft SQL and Azure SQL database environments are reliable, resilient and secure. Administering, maintaining and supporting both on-prem and cloud based SQL Databases and servers. Monitoring database performance, implementing changes and applying new patches and versions when required. Managing database security, backups and recovery processes. Identifying and resolving performance issues in both on-prem and cloud based databases. Optimising queries, indexes and database configuration for maximum efficiency. Conducting regular performance tuning and capacity planning. Implementing and maintaining database security measures to protect sensitive data. Ensuring compliance with data governance and NHS regulatory requirements. Performing regular security audits and vulnerability assessments. Developing and maintaining automation scripts for database administration tasks. Utilising tools and technologies to automate routine database maintenance and monitoring. Designing and implementing disaster recovery plans. Conducting regular testing of backup and recovery procedures.
The individual will need excellent communication and organisational skills, and have the ability to work on your own initiative. Work closely with development and IT teams to support application development and deployment. Provide technical support and guidance to team members and stakeholder.
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.
Please see attached the job description and person specification for more information about this role.
This advert closes on Monday 11 Nov 2024