Job Summary
The Trust are recruiting an expert in SQL, to administrator, monitor, maintain, and assist development of the trusts in use SQL databases/instances, and help realise the deliverables and ambitions of the trusts digital strategy.
The Trust has several main supplier applications where SQL database instances are in use, this senior role will help inform technical architectural decisions around setup, high availability, performance and suitability. The position is to lead on SQL setups, both in the cloud and on-premise, the creation and implementation and best practices of maintenance plans, backups, H/A, and performance of the trusts SQL databases.
This role will join a Cloud Infrastructure team within Digital and Data Services, with the team responsible for all aspects of the trusts Cloud tenant and on site server equipment.
This role will be based in the recently re-furbished Seaton Delaval offices, and will benefit from part at home, and part in the office working pattern, to ensure priorities, objectives and team culture are achieved and maintained.
Main duties of the job
- Reporting to the Lead Technical Architect. You will have a trust wide level responsibility for the installation, implementation, maintenance, availability and development of SQL server instances.
- Responsible for both cloud SQL installations and on premise installations.
- Assess and make suggestions of improvement across all SQL instances.
- To be a key stakeholder and senior lead advisor in all SQL implementations, from either internal development or supplier 3rd party, installations.
- To role model compassionate and inclusive leadership in order to shape the creation of a collective leadership culture within the trust. This means demonstrating a consistent leadership style which (a) engages, enable and empowers others (b) uses coaching to promote ownership of learning and quality improvement and (c) facilitates team working and collaboration within teams / departments and across organisational boundaries.
Job description
Job responsibilities
- Use high levels of expertise to research and plan the required technical SQL database solutions, in line with the trust’s digital strategy, and implement to published and Trust guided best practices in your field of expertise.
- Design, document, implement and peer-approve the architecture setup for the trust’s SQL infrastructure, both cloud native, cloud hosted and on-premises.
- Expert familiarity with on-premise and cloud-based SQL environments, such as Azure SQL, AWS RDS for SQL Server, and the Microsoft back office SQL current and legacy versions.
- Experience with high-availability (HA) and disaster recovery (DR) solutions such as Always On Availability Groups, Clustering, Replication, Log Shipping, and Backup/Restore strategies for SQL and have awareness of the wider technical requirements and impacts.
- Responsibility for the effective management, data integrity and performance of the organisations reporting and SQL Server environments.
- Trust wide responsibility for Installing, configuration, and management of SQL Server databases in hosted, cloud and on-premise environments.
- Working closely across other teams throughout the trust to ensure any project work and SQL infrastructure changes are in the interest of all parties. Also that they are in accordance with IG, Clinical safety and security procedures. To be active in the CAB board, relating to SQL technical changes.
- Oversee and carry out reporting and data related requests as part of the BAU and individual project streams.
- Trust wide responsibility for defining the overall SQL structure and current systems platform architecture directly linked to the use of Microsoft SQL.
- Implement and maintain robust security measures to protect sensitive healthcare data in compliance with global data protection regulations (e.g., HIPAA, GDPR).
- Uses their up-to-date knowledge of IT infrastructure to identify opportunities to use emerging technology to increase efficiency, reliability and flexibility across the entire technical estate.
- Collaborate with application developers to design database schemas, stored procedures, and functions. Provide support for database-related application development.
- To work with and lead supplier engagements where liaison and technical solution is required, along with technical supplier management and senior level escalation management.
- Work closely with various Digital teams, data analytics, and business intelligence teams to support data-related initiatives and troubleshoot issues.
- Proactive resource management and utilisation forecasting.
- Work closely with development teams to review and optimize SQL code, ensuring efficient data retrieval and minimizing performance issues. Provide guidance and best practices on writing optimised SQL queries and database interactions.
- The ability to investigate issues with other relational database platforms when required.
- Set up and manage monitoring systems to proactively identify and address issues. Perform and or train staff to perform regular maintenance tasks, including updates and patch management when required.
- Maintain comprehensive documentation of database configurations, processes, and procedures. Ensure documentation is up-to-date and accessible.
- To ensure high availability, security and usability of the SQL infrastructure in place is transparent to users and ensure Service Level Agreements can be maintained.
- Part of the CITI 24/7 365 best endeavours callout rota for emergencies that relate to digital system downtime.
- A member of the digital services call out rota within the skills discipline.
- To be an active member of the license compliance work, pertaining to the SQL environment
Person Specification
Qualifications / Professional Registration
Essential
- Educated to degree level or equivalent experience plus additional in depth specialist knowledge and expertise in IM&T, project management procedures and techniques.
Desirable
- Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Analyst Associate
- Hands-on experience with API-based integrations and middleware
Experience and knowledge
Essential
- Proven experience with SQL Availability Clustering
- Proven experience as a SQL DBA, with a strong track record of managing mission-critical databases.
Desirable
- Experience in a healthcare or telehealth organization
- Proven experience in working within regulatory frameworks like HIPAA, GDPR, or HITECH.
- Knowledge of or experience in coaching and mentoring practices and tools.
- Knowledge of or experience in Quality improvement tools, techniques and methods.
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).
Closing Date: 13 March 2025
