Senior SQL DBA Developer

Job description

Job responsibilities

Analyse a problem or situation systematically to understand its component parts and their relationships.

Communicate system design to interested parties - both technical and non-technical.

Keep up to date with the latest technical advances within the agreed technical specialism including Power BI.

Provide expert technical consultancy to management and staff.

Research new technologies, white papers and leading industry concepts and processes.

Ensure the monitoring, operation, and creation of best practice software engineering processes.

Suggest changes to the team processes and approach to bring about improvements in the teams ability to deliver.

Demonstrate/present potential solutions to customers, including senior clinical and non- clinical users, identifying additional requirements and changes.

Proactively suggest ways in which the department could add value to Trust Systems, or realise cost improvements, including making use of newer technologies and approaches.

Helps identify appropriate technologies, tools, and methodologies to improve the effectiveness of the team and the quality of the product and able to take the lead in their planned introduction.

Maintain and enhance existing applications to enable changing business processes.

Define outcome-based test criteria for requirements and participating in rigorous testing of developed applications to ensure both fit against requirement and to eliminate faulty code.

Undertake code reviews to ensure quality and adherence to our software standards.

Present Show & Tell sessions to demonstrate what has/is being developed to deliver assigned work.

Mentor other members of the PSD team, to improve their technical skills and to enable them to develop their careers.

Act as Domain Expert in designated technical or application related areas, taking the lead for the Development team.

COMMUNICATION

Extensive collaboration with internal and external customers, such as Senior Clinicians, Clinical Directors and senior managers within the trust and other stakeholder organisations.

Communicating complex technical issues and risks to non-technical people, requiring the ability to translate technical impacts into a language understood by business and clinical areas. Ensuring that communications have been successful.

Undertake sensitive negotiations around changes in scope and handling the contentious priorities of balancing changing needs with the need to deliver to time and budget.

Communicating with external system providers to ensure that systems development and interfacing is undertaken in a high quality, well-managed manner. This requires communication on highly complex technical issues and negotiation of the solutions to be implemented.

Attending and actively partaking in formal meetings, such as User Group Meetings, Project Meetings and Change Approval Boards etc.

Challenging and influencing decisions made by senior technical staff within the department as well as external and internal customers, to ensure that technical risks and issues are identified and managed appropriately.

Overcoming barriers to communication due to working remotely from technical system suppliers.

Working closely with colleagues to identify and implement the most appropriate solutions to problems.

Actively partaking in the sharing of technical knowledge and best practice within the department, including presenting of ideas and partaking in robust debates. Resolving conflicts, confrontations, and disagreements positively and constructively.

Giving timely and specific feedback on what has been done well and where there is room for improvement through participation in retrospectives and taking responsibility for actions in order to improve processes and ways of working.

Responsibility for Analysis and Judgement

Analysing user needs, designing systems, developing code, testing, and maintaining systems, many of which are of high importance to the Trust and wider healthcare community.

Analysis of business needs, requiring specialised skills to ask the right questions, check understanding, challenge assumptions and identify how a system could enhance care pathways, the clinical record or business processes. Interpretation of those requirements into highly complex system design recommendations.

Influencing senior technical manages regarding the architecture and design.

Implementing the system to a high quality. Being adaptable to changing business needs and the impact that has on analysis, requirements understanding, design and implementation.

Undertaking all work with a clear customer focus. Ensuring that all developed solutions are designed to be relevant to the user-base with appropriate levels of end-user documentation, implementation planning, communication, etc.

Acquiring an understanding of a problem or situation by breaking it down systematically into its component parts and identifying the relationships between these parts, selecting the appropriate method/tool to resolve the problem, and reflecting on the result, such that learning is identified and absorbed.

Handling, manipulating, and presenting data extracted from systems using appropriate tools.

Analysing faults, identifying potential solutions, and selecting the most appropriate route given a contentious list of requirements.

In depth analysis of highly complex issues with systems and/or data. Considers alternative solutions before moving to resolve an issue. Makes a well- reasoned response even when faced with incomplete or contradictory information. Evaluates the chosen course of action to determine whether it has resolved the problem.

Undertaking detailed analysis of how complex applications currently work.

Analysis of how existing applications may no longer meet business needs and how these shortcomings might be best plugged.

Handle sensitive information pertaining to patients if necessary to resolve incidents.

Proactively identifying and addressing highly complex technical risks and presenting that information to non-technical decision makers.

Responsibility for Planning and Organisation

Planning own workload and dealing with competing priorities to meet service/project/team deliverables throughout the full development lifecycle.

Working with the team to define the teams workload and ensuring that the team meets its commitments through removing the impediments of other team members and mentoring them as necessary.

Providing estimates of the work involved in achieving the business aims to enable a business case to be considered.

Manage and deliver change requests and work packages vital to the operation and development of the system/service within agreed timescales to specified quality criteria.

Contributing to strategic planning across the department.

Identifying new and alternative approaches to performing activities in order to optimize and improve the current working practices and contribute to continuous improvement across the department. This includes the analysis of processes, assessment of the potential benefits of the approaches considered, documentation of the processes and implementation of them.

Recognising and highlighting potential points of failure in own and team processes whilst recommending appropriate change and solutions.

Acting independently and taking action when dealing with uncertain situations or optimising opportunities. Recommending appropriate change and solutions whilst proactively engaging with the wider organisation to identify areas for improvement and taking the necessary action to implement the changes.

Dealing effectively with uncertain situations and optimising opportunities but understanding the need to seek clarity when unsure.

Provides technical ownership of a number of production systems/services, or sizable components of large-scale systems/services.

Proactively identifies technical issues which need addressing. Responsible for the technical decisions and quality of all changes made to the system.

Proactive in identifying barriers to change and seeking ways to overcome them.

Person Specification

Education and Experiance

Essential

• Educated to postgraduate degree level in a suitable technical discipline, or possess an equivalent qualification, or relevant experience
• Substantial knowledge of for the following technical areas: oDatabase Design oOracle database (11g/12c) development oOracle PL/SQL oAdvanced SQL and SQL tuning oOracle Forms or Oracle APEX
• An awareness of other technologies and current industry developments
• Knowledge of The Trusts infrastructure
• Proven capability in utilising SQL scripts and SSIS packages to update databases on the server

Desirable

• Working knowledge of: oSQL Loader and other Oracle server utilities oTOAD and TOAD Data Modeller or SQL Developer oVersion control tools oJavascript oHTML/CSS oOBIEE oBI Publisher oXML oHL7 / FHIR oREST API oJSON
• Familiarity with Data Centre operating standards and specifications

Skills

Essential

• Extensive experience of software architecture and development, technical support (including performance monitoring) and technical assurance in a complex technical environment.
• Extensive experience of the complete development project lifecycle
• track record of implementing systems with: oRelational database management systems oUnit and systems testing oContinuous Integration oUse of ICT in a knowledge-based organisation and in cross-team working. oFormal change control processes oAll aspects of Software Development Lifecycle
• Experience in design, code, test, correction, and documentation of large and/or complex programs and program modifications from supplied and implicit specifications using agreed standards and tools, to achieve a well-engineered result.
• Have the confidence and skills to quickly gain a good working knowledge of new product releases and new development tools

Disclosure and Barring Service Check

This 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.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Employer details

Employer name

Mid and South Essex NHS Foundation Trust

Address

Basildon Mental Health Unit

Basildon

SS16 5NL

Employer's website

https://www.mse.nhs.uk (Opens in a new tab)