Job summaryWe 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 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 and demonstrable, practical experience in SQL, managing complex systems and technical system support including best practices for business continuity and disaster recovery.Main duties of the jobA 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 to provide the Trust with specialist skills and knowledge, in particular, application requirements, managing database applications, servers and backup processes to ensure a robust safe solution for critical systems. To plan and organise broad range of complex activities; formulates, adjusts plans or strategies including investigating complex technical issues and enquiries by providing support andadvice as required.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.About usYorkshire 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:o Flexible working including part-time hours, job shares and flexible hours, agile working (role dependant)o 27 days annual leave, increasing to 33 with service.o Contributory Pension.o NHS Discounts including shops, restaurants, gyms etc.o Car lease and other salary sacrifice schemes.o Dedicated employee assistance and counselling service.o Opportunities for research participation, career progression and ongoing development.o Well respected, committed and supported staff networks for our workforce.Check out our YAS One Team Simulation! https://www.nwyhelearning.nhs.uk/elearning/yorksandhumber/yas/yasoneteam/index.htmlJob descriptionJob responsibilitiesSystems & 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 SupportSQL Version 2012 and higher SQL Cluster SQL Mirror and Replication, Availability GroupsWindows Server 2016 / Windows 10 and above for desktops and user laptopsCAD (999) / PTS / IUC (111) / Estates / Finance / Data Warehouse / ePRPerson SpecificationEssential and desirableEssentialDetailed knowledge of Server configuration and Microsoft Database ApplicationsKnowledge of Microsoft SQL, Oracle, SQL queries/scriptingEvidence of systems and database continuity planning and testingPrevious experience working in a systems and database administrationExperience of specifying, configuring and managing a variety servers, operating systems and database applicationsEvidence of reviewing, documenting, and administrating a variety of applicationsDesirableEvidence of working closely with Suppliers, other NHS organisations and IT staff to successfully deliver mission critical projectsISEB ITIL Foundation CertificateExperience of participation and partnership workingDisclosure and Barring Service CheckThis 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.Employer detailsEmployer nameYorkshire Ambulance Service NHS TrustAddressYAS HQSpringhill 2, Brindley WayWakefieldWF2 0XQEmployer's websitehttps://www.yas.nhs.uk/ (Opens in a new tab)