Main duties and responsibilities:​

• To work as part of the Digital Operations Infrastructure team to build, manage, monitor and develop the database environment.

• Ensure the integrity of the database estate and design and build adequate back-up solutions.

• Contribute to business continuity and disaster recovery planning.

• Maintain an in-depth knowledge of SQL Server, and provide expert advice regarding its application, act as a point of escalation for investigation and resolution of complex technical issues.

• Review requirements and specifications and define test conditions for proposed new databases and upgrades.

• Monitor service component capacity and initiate actions to resolve any shortfalls according to agreed procedures.

• Ensure that services and components meet and continue to meet all agreed performance targets and service levels.

• Assess, analyse, develop, document and implement changes based on requests for change, and implement approved and ratified changes.

• Prepare and maintain operational documentation for database software.

• Plan, monitor, measure and report providing regular feedback to stakeholders

• Plan and delegate activities for direct reports.

• The post holder will review complex information identifying trends that may denote where improvements may be required.

• Provide reports and proposals for improvement to other specialists, users and managers.

• Always build and develop effective relationships with internal and external stakeholders and role model excellent customer service.

• To provide high quality 3rd line technical support to all users connected to the SQL environment using diagnostic tools and fault-finding techniques to identify root causes.

• Maintain an in-depth knowledge of the SQL infrastructure, provides expert advice and acting as a point of escalation for investment and resolution of complex technical issues.

• Review requirements and specifications and define test conditions for proposed new systems and upgrades.

• Ensure that services and components meet and continue to meet all their agreed performance targets and service levels.

• Assess, analyse, develop, document and implement changes based on requests for change, and implement approved and ratified changes.

• Prepare and maintain operational documentation and provide reports and proposals for improvement to specialists, users and managers.

• To identify, recommend and implement changes to IT systems to improve capacity and performance and address potential risks as agreed with internal teams and customers.

• To be responsible for managing own workflow through the department using the IT Service Management tool, ensuring incidents, problems & changes are resolved within the agreed performance criteria. This will include working in line with the departmental procedures for the prioritisation, escalation and resolution of logged tickets.

• Management of team, ensuring resources are efficiently utilised to meet strategic objectives. Ensure there is effective resourcing to meet the needs of the Users and to support IT delivery on a timely basis.

• Assessing staff performance against agreed performance standards/objectives and/or competencies at least annually and develop meaningful and achievable personal development plans and objectives.

• Be responsible for the self-development of skills and competencies through participation in learning and development activities, and to maintain up to date technical and professional knowledge relevant to the post.

• Ensure all actions are accurately documented in a timely fashion using the IT Service Management tool and reference libraries for reporting purposes and future reference.

• To work in accordance with the IT department’s Service Level Agreements.

• To ensure all operational processes are documented in accordance with Trust and departmental standards and policies.

• Handle confidential and sensitive information, both staff and patient, in line with Trust policies and procedures including Information Governance, Data Protection and Caldicott guidelines.

• Adhere to all Trust and local policies including the timely completion of Statutory and Mandatory training appropriate to the role.

• The role requires the post holder to be a member of the IT On-Call Team, providing out of hours support on a rota basis.

• Undertake any other appropriate duties as specified by the Technical Operations Manager & the Digital Operational Management Team.

​

​