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