Job summary
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, practicalexperience in SQL, managing complex systems and technical system support including best practices for business continuity and disaster recovery.
Main duties of the job
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 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 and advice 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, 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 us
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: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 Contributory NHS Discounts including shops, restaurants, gyms Car lease and other salary sacrifice schemes (salary dependent)o Dedicated employee assistance and counselling Opportunities for research participation, career progression and ongoing Well respected, committed and supported staff networks for our workforce.
Check out our YAS One Team Simulation!
Job description
Job responsibilities
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 & 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
Person Specification
Interview criteria
Essential
1. Extensive knowledge of database management and systems support
2. Detailed knowledge of Server configuration and Microsoft Database Applications
3. Evidence of systems and database continuity planning and testing
4. Evidence of reviewing, documenting and administrating a variety of applications
5. Ability to prioritise tasks and to manage conflicting demands on time and resources, to deliver objectives.
6. Ability to develop effective working relationships and demonstrate professional credibility with colleagues at all levels
7. Degree in Computer Science / Business IT or Equivalent Industry experience