Skills

Communication SQL Data Warehousing Oracle DBA Ansible Linux Windows Databases Azure Agile PL/SQL

Job Specifications

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 Back End 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 Government Department working experience
Previous experience of working withlarge 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

About the Company

bedigital delivers innovative solutions that provide efficiency and optimisation, enabling leaders at all levels to focus on what matters most - driving value and achieving their objectives. Our dedicated team of IT experts are committed to helping leadership teams navigate change seamlessly, optimising costs, and driving value. From managing IT assets to innovating with Artificial Intelligence, we're here to save you time and money. We prioritise effective communication, providing clear insights into budgeting, value, and R... Know more