About the job
Job summary
Within the Chemical, Biological and Radiological (CBR) Division our mission is to support the Ministry of Defence (MOD) Other Government Departments to ensure intelligent decision-making is at the heart of the UK government thinking. We work in partnership with the best suppliers from industry, academia and international allies to deliver creative cost effective S&T solutions that reduce the risk CBR materials pose to the UK.
The ORACLE Database Administrator sits within the Statistical Data Science and Software Team in the CB Advice Group. The team supports a diverse range of projects including the development of cutting edge modelling research and software development for CBRN decision support tools, development of novel statistical analysis and use of cutting edge data science techniques for chemistry and biology unique to Dstl. The capability provides support across the division providing and developing best practice, providing advice on tools and techniques and helping to oversee technical work with our industry and academic partners.
You will support the team and wider divisions work by maintaining and developing an existing ORACLE database alongside wider development of database technologies for data management and exploitation.
Dstl recognises the importance of diversity and inclusion as people from diverse backgrounds bring fresh ideas. We are committed to building an inclusive working environment in which each employee fulfils their potential and maximises their contribution.
We particularly welcome female and ethnic minority applicants and those from the LGBTQI community, as they are under-represented within Dstl at these levels.
Job description
In this role you will:
- Monitor database systems to ensure environments are stable and available
- Perform maintenance operations on Oracle databases to ensure efficient database operations
- Backups, migrations, and restorations of Oracle databases, including Oracle APEX applications
- Recover corrupted or lost data in test and production systems from backup.
- Identify automation and improvement opportunities e.g. new tool deployment, scripting/coding
- Engage with the lead user for each database application to understand their current and future requirements
Person specification
We are looking for someone who has:
- Knowledge of Oracle (12c), SQL Server and PostgreSQL.
