Summary: The role of Oracle DBA for the Department for Work and Pensions (DWP) involves supporting Oracle databases in a hybrid work environment, specifically in Manchester, Newcastle upon Tyne, or Blackpool. The position requires SC Clearance and focuses on maintaining highly available mission-critical databases while implementing security procedures in public cloud environments. Candidates with active security clearance and relevant experience will be prioritized due to the urgent nature of the role. This is a 12-month contract classified as inside IR35.
Key Responsibilities:
- Support Oracle RDBMS 11.2-23ai, including Oracle RAC, ASM, AFD, HANFS, and TAF.
- Manage RMAN Backup and recovery, OEM, and OCI’s Db Management.
- Perform patching and upgrades, ensuring high availability of mission-critical databases.
- Set up and configure Dataguard and utilize data migration tools like Datapump and Golden Gate.
- Work with Exadata and Base Database configuration in OCI.
- Implement Infrastructure as Code using Terraform and Ansible.
- Maintain security procedures, including network segregation and transport encryption.
- Conduct migration testing and implement secure authentication for GitLab runners.
- Manage and update repositories with Git.
Key Skills:
- Experience with Oracle RDBMS 11.2-23ai and Oracle RAC.
- Proficiency in Linux/Aix OS environments.
- Knowledge of RMAN Backup and recovery, Dataguard, and data migration tools.
- Experience with public cloud technologies, particularly OCI and AWS.
- Ability to write Infrastructure as Code and debug Terraform and Ansible.
- Understanding of security procedures and database encryption options.
- Experience with Git for repository management.
Salary (Rate): undetermined
City: Manchester
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
On behalf of DWP, we are looking for a Oracle DBA for a 12 Months Inside IR35 contract based Hybrid Newcastle upon Tyne, Blackpool or Manchester SC Clearance is an essential requirement for this role, as a minimum you must be willing & eligible to undergo checks. Please note, due to the exceptional requirements of this position (short-term nature of this role and speed at which we require a postholder in situ) preference may be given to candidates who meet all of the essential criteria and hold active SV clearance.
The Department for Work and Pensions (DWP) is responsible for welfare, pensions, and child maintenance policy. As the UK’s biggest public service department, it administers the State Pension and a range of working age, disability and ill health benefits to around 20 million claimants and customers. As such, we operate on a scale that is almost unmatched anywhere in Europe and most people in Britain come into contact with us at some point in their lives.
Working with DWP, you will be helping us to drive our priorities to:
- Help people to move into work and support those already in work to progress, with the aim of increasing overall workforce participation
- Help people to plan and save for later life, while providing a safety net for those who need it now
- Provide effective, efficient, and innovative services to the millions of claimants who rely on us every day, including the most vulnerable in society
- Improve experience of our services while maximising value for money for the taxpayer.
As a Oracle DBA, your main responsibilities will be:
Essential:
- Oracle RDBMS 11.2-23ai experience of supporting Oracle RAC including ASM, AFD, HANFS, TAF. Additional experience of multitenant, TDE and TLS desirable.
- Specifically in a Linux/Aix OS environment
- RMAN Backup and recovery
- OEM, OCI’s Db Management
- Patching and Upgrade experience
- Track record of supporting highly available mission critical databases
- Dataguard setup and configuration
- Data migration tooling Datapump, Golden Gate, ZDM
- Exadata and Base Database configuration experience in OCI
- Oracle Database technologies (RAC, Dataguard, RMAN Backup and Recovery) and Public Cloud Technologies (particularly OCI and AWS)
- Writing Infrastructure as Code and debugging Terraform and Ansible
- Managing and maintaining Security procedures including:
- Implementing network segregation in a public cloud environment (preferably AWS)
- Incorporating transport encryption to protect data in transit (preferably Oracle)
- Understanding implementation of database encryption options (preferably Oracle)
- Conducting Migration Testing (preferably through Oracle and AWS) and implementing secure authentication with OIDC for GitLab runners
- Maintaining and updating repositories with Git
Desirable:
Please be aware that this role can only be worked within the UK and not Overseas.
Disability Confident
As a member of the Disability Confident Scheme, DWP guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. This scheme encourages candidates with a disability and/or neurodivergence to apply.
Armed Forces Covenant
DWP guarantees to interview veterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, we will interview the best candidates from within that group. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.
In applying for this role, you acknowledge the following "this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different".
