Database Administrator

Job description

Job responsibilities

MAIN DUTIES/RESPONSIBILITIES

Data Warehouse Management & SQL Development

5.1Lead on the management, administration, maintenance and development of the SQL Server instances and databases that provide the Livewell Southwest Data Warehouse, reporting platform and business intelligence platform.

5.2Investigate, analyse, design, develop, test, document, communicate, implement, support, and decommission databases.

5.3Maintain specialist knowledge of the database structures within the SQL Server and other Relational Database Management Systems (RDBMS) systems within the organisation utilising knowledge of Transact-SQL, SSIS, SSAS, SSRS, PowerShell, .NET Framework and XML programming and data manipulation and actively monitoring and maintaining best practice.

5.4Will be expected to investigate,technically advise and implement the development of the SQL Server using the latest techniques, best practice and tools Including but not restricted to SQL Server version upgrades, Data Migrations, Data Modelling and Source Controlling

5.5To work alongside and communicate effectively with a variety of professionals both technical and non-technical working on projects and programmes as required.

5.6Will be responsible for the creation, maintenance and future development of both technical guidance and process flows relating to the development and maintenance of the structures within the SQL Server data warehouse.

5.7Will be responsible for the development and implementation of security policies that ensure that access to the database conforms to bothNHS Information Governance policies and associated legislation and also any locally agreed Information sharing protocols.

5.8Monitor and analyse the Data Warehouse, to ensure efficiency through effective data transformation and indexing. Performing routine checks and maintenance, to ensure business continuity. Deliver second & third-line database platform support as demand dictates. Work with all relevant staff to resolve reported issues in an efficient manner.

5.9A high level of expertise in SQL coding with the ability to proactively maintain existing and develop new procedures for information provision with One Version of the Truth and the troubleshooting of server and ETL issues; including the ability to allow for integration with other technologies such as powershell, web development and other application developments

5.10Expected to provide training in the various SQL Server functions across the BI team.This will require training to be provided in SQL Server coding techniques, the proper use of source control and associated tools and in the areas of administration and general database housekeeping tasks

5.11Will support other team members with development and maintenance of the reporting requirements of the Livewell Southwest Data Warehouse.

5.12The ability to plan and balance workload between projects, support and urgent requests that may involve several complex pieces of work that have parallel timelines

5.13Contribute to the delivery of project plans with the ability to analyse complex requests and issues, translating into a solution where appropriate. Allocating tasks as appropriate, identifying risks, issues and dependencies, considering best practice and current options and ultimately making recommendations.

5.14Support the processes that ensure all statutory data set requirements are met e.g., Secondary Uses Service (SUS), Mental Health Services Data Set (MHSDS) and the Community Services Data Set (CSDS) submissions and extractions

6 Business Development

6Pro-actively developing, identifying and generating opportunities for the Business Intelligence Team to deliver continually improving systems across all functions of the organisation, ensuring theongoing improvement and effectiveness of the Business Intelligence team.

6.1Assist with the Research, review and analysis of the effectiveness and efficiency of existing requirements gathering processes and developing strategies for enhancing or further leveraging these processes. This will include advising other senior managers on the procurement of new software or systems.

6.2Liaise with other senior members of the Business Intelligence Team to ensure that the delivery of Business Intelligence is consistent across the service.

7GENERAL

7.1To undertake other relevant duties as may be required by the Data Warehouse Manager

7.2To be responsible for training or demonstrating skills for junior or new staff.

7.3To attend training identified as necessary for the successful delivery of the role.

8. COMMUNICATIONS AND RELATIONSHIPS

There will be regular communication with a diverse range of staff within Livewell and representatives of other organisations for the purpose of requirements gathering and informing of new reporting mechanisms.In house training is delivered to other staff where they have a need to be aware of more technical aspects of report building and SQL coding.

7. PHYSICAL DEMANDS OF THE JOB

This is a hybrid working role, predominantly home based but with access to and an expectation to attend when required in an open plan, air conditioned environment with disabled access and facilities.Work is largely involving the use of a computer and is desk based.There is a requirement to be able to concentrate for long periods of time using VDU devices and will be of a repetitive nature

Person Specification

Qualifications

• A technology based Degree or substantial equivalent experience in a similar role with relevant knowledge and skills.
• Completion of industry standard recognised courses in SQL Server and evidence of the development of systems using relational database systems and related technologies

• Any industry standard certification, e.g. Microsoft Certified Professional series, Cisco Networking standards
• Completion of industry standard recognised courses in any database or programmable language.
• Recognised healthcare qualification in information security or management

Experience

• Specialist experience of using Microsoft SQL Server within a large organisational setting.
• Experienced in developing applications using Microsoft SQL Server, SSIS, Powershell SSRS and the Microsoft Office suite of products including Microsoft Visual Studio and PowerBI
• Experience of implementing and maintaining source control methods
• Experience of working and engaging with staff at all levels
• Experience of developing / compiling complex policies and procedures

• Demonstrable experience of other relational database technologies.
• Experience of project management work
• Experience of using Microsoft Visual Studio
• Experience of project management work

Knowledge

• Specialised understanding of the principles and use of relational database technologies.
• Understanding of the Data Protection Act and allied legislation and its implications on the design of systems used on a multi-agency basis.
• Specialist Knowledge and understanding of internet delivery technology, Microsoft SQL Server

• Knowledge of risk appraisal and management of risk
• Understanding of the principles and use of relational database technologies within a healthcare setting.
• Knowledge of information systems utilised by partner agencies

Specific Skills

• Highly skilled in the application of technology to business problems in order to offer solutions that are useable by staff at all levels. Advanced keyboard skills for the use of inputting and manipulating data.
• Excellent verbal and written communication and presentation skills
• Highly organised and able to plan and prioritise own workload
• High Degree of competence in communication and negotiation skills
• Ability to work in partnership with managers across the organisation and within stakeholder organisations.

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.

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.

Employer details

Employer name

Livewell Southwest

Address

Crownhill Court

Tailyour Road

Plymouth

Devon

PL6 5DH

https://www.livewellsouthwest.co.uk/