Database Administrator - Plymouth, United Kingdom - Livewell Southwest

Livewell Southwest

Verified Company

Plymouth, United Kingdom

1 week ago

Posted by:

Tom O´Connor

beBee Recruiter

Description

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

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.

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