Systems & Database Technical Specialist

We have a vacancy available for a Systems and Database Technical Specialist within the ICT department at Yorkshire Ambulance Service, the role will involve working within the Systems, Online and Development Support Teams.
As a Systems and Database Technical Specialist within the ICT department at Yorkshire Ambulance Service, the role will involve working within the Systems, Online and Development Support Team where you will provide the systems administration and technical support associated with a wide range of systems within the Trusts ICT Services. You'll find that the work is varied and challenging and will include system administration, enhancements, performance improvements, configuration, fault finding, bug fixing and system design and data warehouse implementation and support within a structured healthcare environment.
For this role, in addition to digital systems technical experience, you'll need to have a good understanding of relational database design, data warehouse design and demonstrable, practical
experience in SQL, managing complex systems and technical system support including best practices for business continuity and disaster recovery.
A System and Database Tech Specialist main duties are to provide and receive highly complex, sensitive, or contentious information; agreement or co-operation required; present complex, sensitive or contentious information to large groups usually involving communicating a range of ICT issues which can be complex and multi-stranded and negotiate priorities on system design and development, reporting processes with non-ICT managers.
The role is also responsible for the planning, development, review, update, upgrade and introduction of major new ICT systems to meet user, business and operational requirements, e.g. redevelopment of aspects of patient care system, business systems, infrastructure, and information systems including the YAS Data Warehouse.
To help to ensure the security of systems equipment, software licence compliance and compliance with NHS IT security requirements. To continually monitor service performance, taking timely and effective action to ensure agreed performance levels are maintained or exceeded.
Yorkshire Ambulance Service (YAS) NHS Trust geographically covers nearly 6,000 square miles of varied terrain, from isolated moors and dales to urban areas, coastline and inner cities.
We serve a population of over five million people across Yorkshire and the Humber and strive to ensure that patients receive the right response to their care needs as quickly as possible, wherever they live.
We employ more than 7,100 staff, who together with over 1,300 volunteers, enable us to provide a vital 24-hour, seven-days-a-week, emergency and healthcare service.
Our ambition is to be an employer of choice, and we are continuously working across our partnership to improve our collective offer to staff in areas like health and wellbeing, benefits and flexible working incl. hybrid working.

**Benefits**:

- Flexible working including part-time hours, job shares and flexible hours, agile working (role dependant)
- 27 days annual leave, increasing to 33 with service.
- Contributory Pension.
- NHS Discounts including shops, restaurants, gyms etc.
- Car lease and other salary sacrifice schemes (salary dependent)
- Dedicated employee assistance and counselling service.
- Opportunities for research participation, career progression and ongoing development.
- Well respected, committed and supported staff networks for our workforce.
- Systems & SQL Database Administration, Design and Support.
- System & Database continuity planning and testing.
- Proactively monitor complex systems & database servers and respond to escalated alerts from 2nd line to 3rd line.
- System Technical Support.
- Data Warehouse administration and support.

**Roles & Responsibilities**:

- Own, investigate and see through to resolution incidents assigned to the team.
- Provide support for the Trusts systems, data warehouse and databases.
- Involvement in project work, including scoping requirements and creating technical documentation.

Systems, Databases and Architecture Supported
- SQL Version 2012 and higher - SQL Cluster - SQL Mirror and Replication, Availability Groups
- Windows Server 2016 / Windows 10 and above for desktops and user laptops
- CAD (999) / PTS / IUC (111) / Estates / Finance / Data Warehouse / ePR