Oracle Solutions Architect

bedigital; Remote; GBP 150,000 - 200,000; Full time

Job summary

A leading technology consultancy seeks an Oracle Solutions Architect for a government project. You will handle design, assurance, and troubleshooting of Oracle solutions in a secure environment. Candidates should have over 10 years of Oracle experience, particularly in high-transaction databases. Excellent communication skills are essential, along with the ability to work with remote teams. This is a remote opportunity offering a competitive rate of £600-£700 per day for 6 months.

Qualifications

• Ability to be Security Cleared.
• 10+ years of Oracle experience.
• Proven experience as Oracle DBA in a complex environment.
• Experience with high transaction Oracle platforms.
• Optimisation of PL/SQL and SQL code.

Responsibilities

• Design, assurance, and troubleshooting working on Oracle solutions.
• Work closely with other architects on defined tasks.
• Ensure communication of complex information effectively.

Skills

Ability to be Security Cleared

Thorough knowledge of Oracle (10 years+)

Proven experience as an Oracle DBA, particularly with Oracle 19c

Table analysis and index tuning

Optimisation of PL/SQL and SQL code

Oracle mTLS / TDE Experience

Oracle client software troubleshooting

Familiarity with database auditing and security best practices

Self-starter and ability to work under tight timescales

Ability to work within remote disparate teams

Working with COTS products

Strong understanding of RAC / ASM on OEL

Oracle secure views and partitioning

Tools

Oracle Database

Linux

Microsoft Windows

Ansible Automation Platform

Job description

Oracle Solutions Architect

UK, Remote, 6 months Outside IR35, £600-£700pd

Bedigital are partnered with a large central government department on a data warehouse re-platforming and optimisation programme.

This is a role for a seasoned Oracle Solution Architect with a grounding in working with COTS applications, their connectivity to a backend database etc. Having worked with large scale database systems, preferably from a data warehousing standpoint, you should also be comfortable with performance tuning of large Oracle RAC based systems in a secure environment.

This is a design, assurance and troubleshooting role, working closely with the Lead Solutions Architect and their team of architects to work through and advise on key defined tasks. This is working with on premise technology only with minimal exposure to public cloud technologies. Excellent communication skills, written and oral, and be able to present complex or sensitive information effectively is a must.

Essential skills and experience :

• Ability to be Security Cleared
• Thorough knowledge of Oracle (10 years+)
• Proven experience as an Oracle DBA, particularly with Oracle 19c, in a complex environment.
• Table analysis and index tuning, including optimisation of large-scale, high transaction Oracle Platforms
• Optimisation of PL / SQL and SQL code
• Oracle mTLS / TDE Experience
• Oracle client software troubleshooting
• Familiarity with database auditing and security best practices.
• Self-starter and ability to work under tight timescales
• Ability to work within remote disparate teams
• Working with COTS products
• Previous experience of working with large scale databases in a government, secure or similar environment is a must
• Strong understanding of RAC / ASM on OEL, Dataguard, and RMAN
• Oracle secure views and partitioning

Desirable Skills and experience :

• OEL and RHEL 7 / 8 Experience
• Oracle Database migration to Azure and / or OCI
• Exadata in OCI
• Experience working with Linux and Microsoft Windows based systems in a mixed environment
• Working with COTS products
• Ansible Automation Platform
• Any exposure to SAS analytical software
• Working in an AGILE environment
• Kerberos Security (Including Kerberos File Security)
• Firewall awareness and working in a secure environment
• Previous Government Department working experience