Database Administrator

2 weeks ago


Plymouth, United Kingdom Livewell Southwest Full time

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


  • Administrator

    1 month ago


    Plymouth, United Kingdom Techniche Global Ltd Full time

    Techniche Global are supporting an engineering defence contractor to appoint an Administrator. You will be supporting across a variety of administrative tasks, so experience of working in a secretarial role with diary management responsibilities will beessential, as will the ability to work with mínimal supervision. Rate: £12.48p/hr PAYE Hrs: Mon - Fri, 36...


  • Plymouth, United Kingdom Inspiring On Full time

    **Full Job Description**: Inspiring on are specialist recruiters in the Health and Social Care sectors providing temporary staffing to work within a variety of 24 hour supported accommodation services and Care homes across the southwest. We have a great opportunity for an excellent administrator to work within the Healthcare team providing administration...

  • Administrator

    2 weeks ago


    Plymouth, Plymouth, United Kingdom i-Jobs Full time

    An opportunity for an Administrator has arisen with the local authorities on a 6 Month contractPay Rate: 12.18 Per Hour (PAYE) plus Holiday pay.Location: PL1 3BJWorking Hours: 35 hours per week, Monday to Friday, 09:00 AM - 5:00 PMTypical involvement will include:Undertake telephone and reception duties Provide general support to the team including input of...


  • Plymouth, United Kingdom Qiagen Full time

    **About the role** Balfour Beatty are currently looking for an **Security Administrator** to join our Regional team based in Devonport, Plymouth. **What you'll be doing** As an **Security Administrator**, you will have the following accountabilities: - Maintain a live database of security cleared personnel and currency of bas - Provide guidance and support...


  • Plymouth, United Kingdom University Hospitals Plymouth NHS Trust Full time

    University Hospitals Plymouth NHS Trust is looking for an experienced administrator to join our busy Research & Development Team based at Derriford Hospital. Research has been at the forefront of the Covid-19 pandemic and consequently we are looking to expand our administrative team. Your duties would be to provide administrative and clerical support to our...


  • Plymouth, Devon, United Kingdom HM Land Registry Full time

    Contract type : Permanent Flexible working, Full-time, Part-time It is an exciting time for HM Land Registry (HMLR) as we continue to embark on a major transformation programme. HMLR's ambition is to become the worlds leading land registry for speed, simplicity and an open approach to data. We are looking for an Infrastructure Engineer (Load and...


  • Plymouth, United Kingdom Plymouth University Full time

    An exciting opportunity is available for a driven and resilient individual to join the professional services team within the Faculty of Health. You will contribute to the delivery of customer focused, cost effective and efficient administrative support of the School of Psychology undergraduate and postgraduate programmes. This is an expanding and...


  • Plymouth, United Kingdom Plymouth University Full time

    An exciting opportunity is available for an enthusiastic and dedicated administrator to join the professional services team in the Peninsula Dental School (one of England's top Dental Schools), responsible for supporting dental students and academic staff throughout the student journey. We are seeking an experienced, highly motivated, and well organised...


  • Plymouth, United Kingdom Brook Street Full time

    Do you have a passion for public and customer services and want to make a difference? If so we would like to hear from you. Brook Street are proud to advertise a temporary position for an **Administration Officer Customer Service Centre - UK Central Government Department (AO Grade)** Temporary role ongoing assignment, **£11.30 per hour pay rate**, Monday...

  • Case Administrator

    1 month ago


    Plymouth, United Kingdom Ministry of Justice Full time

    Salary 1 - £20,126 - £24,225, pro-rata Number of jobs available 1 - 1 Detail of reserve list 1 - 12 Months Region 1 - South West City/Town 1 - Plymouth Building/Site 1 - NPS ST CATHERINES HOUSE PLYMOUTH, PL1 2TS Grade 1 - Other Organisation Grade for HMPPS 1 - NPS Pay Band 2 National Post Type 1 - Permanent Working Pattern 1 - Part Time Role Type...


  • Plymouth, United Kingdom Plymouth University Full time

    The University of Plymouth has a sound reputation in establishing and maintaining educational collaborations which are valuable for both partners and students. A University ambition is to maximise its current partnerships through development of its existing partnership network, both in the UK and overseas. Through the Partnerships team, students are able to...


  • Plymouth, United Kingdom Novus Recruiment Full time

    Well respected company based in Plymouth, Devon are looking to recruit an experienced HR Administrator on a part-time3 month ftc basis. **Job Purpose** The HR Administrator undertakes the full range of contractual administrative and payroll/pension-related tasks and supports the wider HR Team with employee queries, maintaining and updating employee...


  • Plymouth, United Kingdom Plymouth University Full time

    This is an exciting chance to be part of a progressive and cutting-edge University in a beautiful location, where you can really make a difference. At the University of Plymouth, you’ll find the space to develop your talents, the freedom to bring the changes and the opportunity to grow as part of our welcoming and inclusive community. Based in Research...


  • Plymouth, United Kingdom Devonport High School for Girls Full time

    **Devonport High School for Girls** **Temporary Sixth Form Administrator** **Post Title**: Temporary Sixth Form Administrator **Grade**: Grade C, Point 5 **Hours/weeks per annum**: 30 hours per week, 40 weeks per annum **Hours of work**: Monday 8.00am - 5.00pm, Tuesday and Thursday 8.00am - 4.00pm and Friday 8.00am - 3.00pm. (Hours/days can be...


  • Plymouth, United Kingdom University Hospitals Plymouth NHS Trust Full time

    Research and Governance1. Assist the clinical research team in co-ordinating a portfolio of studies.2. Participate in Good Clinical Practice (GCP) training and ensures GCP compliance of self and team.3. With support, coordinate the study set up process including: Assist in completing Expression of interest / study selection documentsLiaise with the study...


  • Plymouth, United Kingdom University Hospitals Plymouth NHS Trust Full time

    University Hospitals Plymouth NHS Trust is looking for someone with a keen interest in finance administration to join our busy Research and Development Team based at Derriford Hospital. For someone with a keen interest in finance there will be the opportunity to access further training in financial management in due course. **Preference will be given to...


  • Plymouth, United Kingdom University Hospitals Plymouth NHS Trust Full time

    University Hospitals Plymouth NHS Trust is looking for people with a keen interest in data to join our busy Research & Development Team based at Derriford Hospital. Research has been at the forefront of the Covid-19 pandemic and as a consequence we are looking to expand our data management team. Your duties would involve data management and general...


  • Plymouth, United Kingdom FORTEL SERVICES LTD. Full time

    Nexus is a leading, international construction and infrastructure group, currently looking for a Data Entry Administrator, to join their busy and friendly team, in the Plymouth area. Your role as Data Entry Administrator will be construction site based. **Duties include**: - Administrative support to the site teams - Creating and maintaining databases -...


  • Plymouth, United Kingdom Learning Curve Group Full time

    **Introduction**: Learning Curve Group are a national training and education specialist we work with further education providers, employers, and learners to help them achieve success. We have strong values which are all centred around our learners - and that is how we believe it should be, as we impact on over 100,000 of them every year. Our ‘Purple...

  • HR Admin Assistant

    4 weeks ago


    Plymouth, United Kingdom DK Recruitment Full time

    **Main purpose of the role**: - Respond and support to employee enquires. - Assist with Recruitment processes, writing contracts of employment. - Support with Payroll. - Maintenance of the HR Database/Systems. - Updating records and HR system with sickness, lateness etc. - Supporting Occupational Health with updating records. - Managing administration...