Warning
Mae'r hysbyseb swydd hon wedi dod i ben ac mae'r ceisiadau wedi cau.
SQL Database Administrator
| Dyddiad hysbysebu: | 25 Mehefin 2024 |
|---|---|
| Cyflog: | £50,952.00 i £57,349.00 bob blwyddyn |
| Gwybodaeth ychwanegol am y cyflog: | £50952.00 - £57349.00 a year |
| Oriau: | Llawn Amser |
| Dyddiad cau: | 26 Gorffennaf 2024 |
| Lleoliad: | Plymouth, PL6 8BT |
| Cwmni: | NHS Jobs |
| Math o swydd: | Parhaol |
| Cyfeirnod swydd: | C9216-24-1177 |
Crynodeb
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. Liaising with 3rd parties' programmers & DBAs, applications/operational staff, IT project managers and other technical staff. 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.