The East of England Ambulance Service delivers class leading emergency care to the population of the East of England, this is und.....
The East of England Ambulance Service delivers class leading emergency care to the population of the East of England, this is underpinned by state of the art digital computer aided dispatch (CAD) and information systems centred around Data lake and PowerBI solutions.
An exciting opportunity has become vacant for a Digital Senior Database Administrator to join our fast growing and diversely skilled team to support, maintain and develop the Trusts Microsoft SQL databases and database instances residing in private datacentres and MS Azure.
The successful candidate will possess skills and experience that aligns with the essential requirements within the attached person specification and provide evidence of these within their application .
Please note that this vacancy currently meets the requirements for visa Sponsorship (Skilled Worker Visa), but may be impacted by the changes effective from 4th April 2024.
To deliver the role of Digital Senior Database Administrator utilising highly developed specialist knowledge across the range of work procedures and practices relating to IT database management.
Responsible, for the efficient and effective support and maintenance of IT databases and services throughout the Trust, providing installation or repair, and maintenance of EEAST Trust information or database assets.
Development of a database security awareness 'program' to raise awareness of database resilience, reliability, integrity, and security amongst staff, assisting in promoting an IT security culture.
Lead on ensuring and maintaining the confidentiality, resilience, reliability, integrity and security, and availability of Trust database systems.
Be the Trust’s subject matter expert in all matters of database management resilience, reliability, integrity, and security. Provide highly specialised advice to the Trust on how to relate raw operational data into meaningful feature-rich reports.
Provide input to the IM&T Strategy for database management.
The East of England Ambulance Service is a friendly, modern and inclusive organisation to work for, offering exceptional patient focused care across the east of England, covering some 7500 square miles. With over 130 stations and 4 main administrative hubs spanning 6 counties, Norfolk, Suffolk, Essex, Cambs, Herts and Beds. Hybrid and flexible working is supported and also available for this post.
1. Key Responsibilities of the Role
• Undertake the technical review and design of all databases, replication, backup and restore, reporting services, and supporting technical documentation.
• Prime responsibility for the formulation and implementation of policies, relating to the support and maintenance of SQL database servers which are used to provide Trust wide clinical services and financial services.
• Responsible for the installation build, patching, and security of SQL servers in various configurations, including enterprise, clustered, and standard configurations.
• Responsible for all configuration issues relating to SQL servers and database options, including logging, collation, paging, and indexing.
• Responsible for setting and maintaining complex database plans, backups, and administration options.
• In the event of problems, operational responsibility for making rapid personal decisions regarding the most appropriate action to ensure continued (24/7) availability of core systems.
• Providing software and hardware change and release management within the IT guidelines, policies, and procedures.
• Working at a highly complex level of technology, using a mixture of SQL server releases and operating systems, to undertake detailed analysis, design, programming and testing work on all SQL systems developed within Digital Services.
• Responsible for detailed research and analysis of sometimes complex, sensitive clinical/non-clinical information derived from IT systems, working at a wide variety of levels, such as Trust wide, clinical audits/research or individual patient/user, and information audits.
• Responsible for the monitoring of various system logs, to ensure that the systems operate correctly with optimised performance.
• Maintain complex IT database systems used in all areas across the Trust.
• Ensure all SQL server applications are fit for purpose in terms of routine operation throughout the Trust.
• To fully implement system upgrades for use across the Trust.
• To monitor, review and implement improvements, as required, following a full consultation process with users, both internal and external, in a controlled change management approach.
• Specify the details of database internal design and implementation, supervising and managing less senior staff, working closely with the other technicians (of all grades) within the Team to motivate and influence outcomes.
• To liaise with, and influence, other members of the Trust at all levels relating to the design, development and implementation of new or enhanced systems functionality, providing detailed and highly complex technical advice.
• Responsible for the analysis and presentation of highly complex clinical/information/audit data, in order to aid interpretation and further analysis by those requesting the information.
• To regularly test system applications and hardware, business continuity, and Disaster Recovery Plans.
• Responsible for personal development in SQL server programming, administration and performance tuning techniques, and in the underlying design of the systems developed within IT Services.
• Responsible for the detailed specification of hardware and software systems to be used in the service provision, for which Digital Services has responsibility.
• Coordinating work with members of the Team in order to ensure prompt resolution of problems relating to use of IT and information applications and systems.
• Routine monitoring of advances/changes in relevant technologies, with a view to potential extension/enhancement of current and future Trust systems. Where new technologies offer potential benefit to the organisation, responsible for further evaluation, incorporation within larger system designs, and implementation.
• Proactively keeping personal expertise updated with respect to relevant hardware, software packages, and operating systems.
• Promoting and maintaining the highest standards of professional conduct, responsibility and confidentiality, in respect of any data held, accessed, or processed by the Digital Directorate.
• Maintain associated technical documentation to the highest standards to aid in the support of systems/databases.
• Establish, lead, and work collaboratively as a Team member in multidisciplinary teams, building relationships, trust, and confidence. The teams will span organisational silos and include partners, other organisations, and run from initiation of design work through to managing delivery of solution(s), and training of technical staff.
• Participate in the development and maintenance of the policies, processes and standards to support the work of the Digital projects and programmes across the Trust, and contribute to business planning activities for the function. This includes designing the environment, standards, patterns and structures, to support better service design.
• Provide visibility of the work of the Team to the organisation, working in an open and transparent way, creating a culture of sharing and reflective learning, ensuring continuous improvement.
• Responsible for the Trust wide SQL licensing budget, managing instances appropriately to maximise return on the investment.
• Ensure effective planning and scheduling of a broad range of complex activities including resource planning and management. Maintain/update these plans in line with schedule changes/progress as required.
• Work autonomously on a wide range of complex activities.
• Have the mental agility to maintain concentration despite interruptions, juggling the analysis and design of multiple systems at any one time.
• Interpret and be guided by national policy and regulations, along with industry standard security requirements.
• Undertake any other tasks reasonably asked of you by your Line Manager.
1. Communications and Stakeholder Engagement
• To negotiate with, liaise with, coordinate, and monitor the activities of suppliers and internal ICT staff, as appropriate, to ensure all projects are implemented in a timely manner, to a high quality and to agreed standards.
• Present and discuss complex data to a range of audiences, including key stakeholders, large groups, and up to Director/Senior Management level.
• Establishment, ownership, and chairing of relevant meetings.
• To liaise with relevant parties to ensure that adequate, timely, and appropriate training is provided and, where necessary, that resources and timing are respectful of the Trust’s operational staff’s 24-hour nature.
• To communicate, publicise and promote project activities and progress to appropriate personnel, both inside and outside the Trust.
• Develop and maintain effective communication with staff, colleagues, and external contacts at all levels, both clinical and non-clinical.
• Clear communication of risks and issues, often dealing with difficult and complex situations, acting with diplomacy and tenacity, to ensure the required outcome is achieved.
• Develop and maintain collaborative relationships with other health and related organisations within the area, and take part in joint ventures, as appropriate.
• Hand over to Operational Support Teams in a manner consistent with the working practices and requirements of those areas.
• Ensure that third party support is handed over to the Operational Support Teams with clear escalation, together with service level agreement pathways and documents.
• Influence and persuade stakeholders and steering groups.
• Engage with stakeholders, users and decision makers, using workshops and formal presentations.
• Manage third party supplier relationships/account managers.
• Liaise with the Project Steering Group regarding its appointed project assurance roles to ensure the overall direction and integrity of the workstreams.
• Knowledge of project management skills gained through professional qualifications in leadership and management.
1. Strategic Leadership and Service Development
• Will be required to work within the Trust’s Standing Financial Instructions and associated policies and procedures. Significant financial management required.
1. Analytical, Judgmental and Decision Making
• To maintain appropriate database documentation, as required.
• To liaise with, and coordinate, user representatives and end users to ensure projects are effectively communicated and planned, such that there is minimal disruption to day-to-day working.
• To provide regular and ad hoc progress reports to management, and other appropriate personnel, as required.
• Agree technical and quality strategy with appropriate members of the Project Steering Group.
• Independently work to agreed objectives, the Digital project framework, and incorporated national guidelines, in line with Trust Digital Strategy.
• Formulating action plans to meet local and national requirements and mobilising teams to ensure actions take place.
• Ensure appropriate local change management plans are in place to embed sustainable solutions.
1. Resource Management
• Staff Management Responsibility
• Manage staff within the Digital Teams to ensure actions are agreed and performed as in the project plan.
1. Working Conditions and Additional Information
• Comply with the organisation’s Data Protection Policy and ensure that the organisation and systems comply with relevant current data protection regulations.
• To carry out other development, support and ad hoc consultancy projects, as required.
• Ensure Trust policies and procedures are aligned to any change or system implementation, or redirection, ensuring all non-Digital departments and external stakeholders are engaged.
This advert closes on Tuesday 2 Apr 2024
