SQL Database Administrator
7 months ago
Primarily remote working with some on site duties as and when required.
**Preference will be given to internal Trust staff, as well as ‘ Priority ’ and 'At Risk' status including NHS At Risk staff throughout Devon who are able to display recent relevant experience as dictated by the Person Specification.**
To create and manage MS databases including Table Management, procedures, views, indexes, triggers, and replication.
Working with database software to find ways to store, organise, and manage data.
Run complex database queries to extract data for audit and performance monitoring.
Proactive troubleshooting and optimising using available monitoring tools.
Designing maintenance procedures and putting them into operation.
Ensuring that databases meet user requirements.
Create and maintain existing SQL jobs. Plus, archiving data.
Support the design and build of data pipelines from clinical systems to our Data Warehouses.
Support in the development of new ways to store and present data.
Identify areas of operational risk in the day-to-day running of the SQL environment. Reporting of risks to the Systems Manager and Head of Technical Services.
Collaborate with the Systems Manager and Head of Technical Services to develop and implement strategies and policies that align with the organisation's goals and objectives. This includes dealing with highly complex, sensitive, and contentious information.
- To create and manage MS databases including Table Management, procedures, views, indexes, triggers, and replication.
- Working with database software to find ways to store, organise, and manage data.
- Run complex database queries to extract data for audit and performance monitoring.
- Proactive troubleshooting and optimising using available monitoring tools.
- Work with Systems Operations Team to ensure that security updates are current, and that database access is approved and monitored.
- Helping with database design and development. This includes opportunities for automation.
- Designing maintenance procedures and putting them into operation.
- Ensuring that databases meet user requirements.
- Defining objectives through consultation with staff at all levels.
- Testing and modifying databases to ensure that they operate reliably. This includes testing failovers and ensuring documentation around Disaster Recovery and Business Continuity are kept up to date.
- Create and maintain existing SQL jobs. Plus, archiving data.
- Support the design and build of data pipelines from clinical systems to our Data Warehouses.
- Support in the development of new ways to store and present data.
- Communicate between technical and non-technical stakeholders as well as facilitate discussions within a multidisciplinary team.
- Keep abreast of best practice in data engineering across industry, research and Government and facilitating the adoption of standards.
- Ensure that data is processed in accordance with policies and procedures.
- Responsible for supporting senior and service management in the strategic planning within the department and audits. This includes meeting DSPT requirements.
TECHNICAL SUPPORT
- Using highly developed specialist knowledge, underpinned by theory and experience, to provide expert technical guidance and support to the Systems Teams in identifying and resolving complex infrastructure issues.
- Collaborate with the Systems Manager and Head of Technical Services to develop and implement strategies and policies that align with the organisation's goals and objectives. This includes dealing with highly complex, sensitive, and contentious information.
- Collaborate with the Systems Manager on a range of documentation; including but not limited to, business cases, infrastructure reviews, restructures, prioritisation work, and both internal and third-party audits.
- Identifying and testing technical improvements and opportunities for automation and monitoring to optimise the infrastructure's performance.
- Knowledge of creating and updating replication subscriptions with new articles.
For further details please see attached JD&PS.
-
Database Administrator
7 months ago
Plymouth, United Kingdom Livewell Southwest Full timeMAIN 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,...
-
Database Administrator
6 months ago
Plymouth, United Kingdom Livewell Southwest Full timeMAIN 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,...
-
Database Administrator
5 days ago
Plymouth, United Kingdom Footwork Solutions Full time**About us** Footwork Solutions is a web app development company, primarily designing software for client centered services in the health and social care sector. Footwork Solutions are searching for a **Database Administrator** to join an experienced close-knit team developing software for the Social and Healthcare sector. For this role, you will need to...
-
Data Administrator
1 week ago
Plymouth, United Kingdom AWD online Full time**Data Administrator / Database Administration Assistant**with an analytical eye and great attention to detail, experience of manual and computerised record/information systems such as MIS and HR systems and good IT skills including proficiencyin MS Office is required for a well-established Academy Trust based in Plymouth, Devon, South West...
-
Constituent Database Manager
3 weeks ago
Plymouth, Plymouth, United Kingdom University System of NH Full timeJob SummaryWe are seeking a detail-oriented Data Director to manage our constituent database and provide critical support to our fundraising efforts. This is an excellent opportunity to join a dynamic team and contribute to the success of the University System of New Hampshire.Key ResponsibilitiesOversee database maintenance, data cleansing, and...
-
Data Engineer, SQL, Ssrs, Ssis Mod, Defence}
6 days ago
Plymouth, United Kingdom Ernest Gordon Recruitment Limited Full time**Data Engineer, SQL, SSRS, SSIS** {MOD, Defence} Plymouth **£40,000** to **£60,000** + Company Benefits - Are you a Data Engineer with SQL experience looking to join a leading global engineering, aerospace, and defence company? Do you want to work on exciting and bespoke projects for organisations such as the MOD? Do you want clear progression and the...
-
Administrator
3 days ago
Plymouth, United Kingdom Techniche Global Ltd Full timeTechniche Global are supporting an engineering defence contractor to appoint a Time & Attendance Administrator. You will be responsible for the administration of employees Time and Attendance records. This could include but is not limited to changes inwork hours, sick absences, holiday, annual leave, traveling time and bookings. Rate: £12.48p/hr...
-
Administrator
5 days ago
Plymouth, United Kingdom Techniche Global Ltd Full timeTechniche 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 UMB Hrs: Mon - Fri, 36...
-
Administrator
5 days ago
Plymouth, United Kingdom Techniche Global Ltd Full timeTechniche 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...
-
Administrator
1 week ago
Plymouth, United Kingdom Techniche Global Ltd Full timeTechniche 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...
-
Administrator
7 months ago
Plymouth, United Kingdom Pertemps Network Group Full time**Job Description**: Administrator Permanent Salary Competitive Working on a busy project at Plymouth Dockyard, supporting the Office with general Administration and office support. Duties will include: - Support all the project team members with Administration support- Answer telephone calls, enquiries and requests- Support staff in assigned project-based...
-
Administrator
7 months ago
Plymouth, United Kingdom Vital Human Resources Full timeAdministrator required to join a service and maintenance administration team, based in a regional Plymouth Office. Main Duties: - Effectively deal with Reactive and PPM works, from initial raising of jobs through to invoicing, in a timely manner. - Accurate inputting of information on IMS database or other reports. - Maintaining excellent client...
-
Administrator
7 months ago
Plymouth, United Kingdom Vital Human Resources Full timeAdministrator required to join a service and maintenance administration team, based in a regional Plymouth Office. Main Duties: - Effectively deal with Reactive and PPM works, from initial raising of jobs through to invoicing, in a timely manner. - Accurate inputting of information on IMS database or other reports. - Maintaining excellent client...
-
Administration Assistant
7 months ago
Plymouth, United Kingdom University Hospitals Plymouth NHS Trust Full time1. Administrator Assistant responsibilities Receives and acts on instructions from the Administration Team Leader Greets visitors, including couriers with equipment deliveries and collections to the department Answers telephone queries and acts on / directs as appropriate or on guidance of team leader Logs requests into the Medical Devices database and adds...
-
Paralegal Administrative Assistant
1 month ago
Plymouth, Plymouth, United Kingdom Office Angels Full timeJob Summary:We are looking for a skilled Administrative Paralegal to join our team at Office Angels. As a paralegal, you will work closely with our lawyers to provide administrative support, manage client relationships, and maintain accurate records.Key Tasks:Provide administrative assistance to lawyers, including document preparation, data entry, and email...
-
Junior BI Analyst
5 days ago
Plymouth, United Kingdom BOWERFORD ASSOCIATES Full timeMy client an exciting and expanding business based in Plymouth, Devon is looking to hire an additional **BI Analyst /Business Intelligence Developer**for theirtheir growing team. To be considered for these roles you will ideally have some experience working as a BI Developer or Data Analyst, using a mixture of the following; **Technical Snapshot**: - Power...
-
Healthcare Administrator
7 days ago
Plymouth, Plymouth, United Kingdom Staff Partners Business Full timeIn this Medical Receptionist/Administrator role, you will be supporting a busy GP Practice in Plymouth.Your main duties will include answering phone calls, booking appointments, and managing patient information on the database.About the Role:Provide exceptional patient care and supportMaintain accurate and up-to-date patient recordsContribute to the smooth...
-
Medical Administrator
3 weeks ago
Plymouth, Plymouth, United Kingdom CV-Library Full timeAbout the Role:We are seeking a skilled Medical Administrator to support a GP Practice in Plymouth on a temporary or permanent basis. As a key member of our team, you will be responsible for taking inbound calls from patients, booking appointments, managing post and documents, and updating patient details onto the database.The ideal candidate will have...
-
Administrative Support Specialist
3 weeks ago
Plymouth, Plymouth, United Kingdom CV-Library Full timeJob OpportunityWe are recruiting for an Administrative Support Specialist to work in our Exeter office. The successful candidate will earn an annual salary of £24,500 and will be responsible for providing exceptional customer service.This role involves handling customer inquiries, updating records, and maintaining databases. The ideal candidate will possess...
-
Contract Administrator
7 months ago
Plymouth, United Kingdom Vital Human Resources Full timeAdministrator required to join a service and maintenance administration team, based in a regional Plymouth Office. Working for an established national Facilities Management and Maintenance provider. Main Duties: - Effectively deal with Reactive and PPM works, from initial raising of jobs through to invoicing, in a timely manner. - Accurate inputting of...