Principal Oracle DBA

HelloKindred

8d•Remote

About The Position

Our client in the Information Technology and Services industry is looking for a Principal Oracle DBA to join the DBA team supporting the Legal Aid Agency, part of the Ministry of Justice. The organisation is on a mission to modernise, maintain, and improve digital services for the Legal Aid Agency. The Principal DBA will provide guidance and support to Lead and Senior DBAs while helping drive the modernisation of the team toward true DevOps. The successful candidate will be part of a multidisciplinary team, placing emphasis on automation of operational tasks, improved monitoring and alerting, while using traditional operations experience to ensure underlying databases remain stable, secure, and capable of supporting change at the speed of business. Oracle databases are hosted in AWS and underpin applications built with several Oracle products, mainly Oracle E-Business Suite, SOA, Portal, IAM, WebLogic, OHS, and APEX.

Requirements

Expert experience working with AWS Cloud services, including EC2, RDS, Lambda, and S3.
Expert experience setting up and maintaining continuous delivery and deployment pipelines.
Expert experience upgrading and migrating PL/SQL-based applications.
Strong experience with Oracle Database versions 10g, 11g, and 12c on Unix/Linux.
Expert experience in Oracle SQL tuning, including execution plans, indexes, hints, and legacy optimiser quirks.
Expert experience with schema design and data modelling in a legacy ERP context.
Experience with Oracle database installation, patching, and upgrades.
Practitioner-level experience working with RMAN and OEM.
Expert experience working with Oracle E-Business Suite R12.
Expert experience working with SOA, WebLogic, Portal, and IAM.
Expert experience with EBS concurrent managers.
Experience with WebLogic clustering and JVM tuning.
Experience automating administrative tasks through scripting.
Practitioner-level knowledge of Git.
Ability to create and utilise AWS CloudFormation templates to automate the creation of AWS images.
Practitioner-level experience working within Agile product delivery teams.
Excellent mentoring, coaching, and skills transfer capabilities.
Strong troubleshooting skills and a mindset of continuous improvement.
Adaptable team player with a passion for learning and problem-solving.
Ability to obtain Ministry of Justice SC Clearance.

Nice To Haves

Experience with database version control tools such as Flyway or similar.

Responsibilities

Lead Oracle database administration and modernisation activities within a multidisciplinary DBA team.
Guide and support Senior DBAs across database administration, troubleshooting, and operational activities.
Drive the adoption of true DevOps practices across DBA operations.
Automate operational and administrative database tasks through scripting and infrastructure-as-code approaches.
Establish and maintain continuous delivery and deployment pipelines.
Upgrade and migrate PL/SQL-based applications.
Administer and maintain Oracle databases across Unix/Linux environments.
Perform Oracle SQL tuning using execution plans, indexes, hints, and knowledge of legacy optimiser behaviour.
Design and maintain schemas and data models within a legacy ERP context.
Perform Oracle database installation, patching, and upgrades.
Manage RMAN and Oracle Enterprise Manager (OEM) activities.
Support Oracle E-Business Suite R12 environments.
Administer and troubleshoot SOA, WebLogic, Portal, and IAM environments.
Manage EBS concurrent managers.
Configure WebLogic clustering and perform JVM tuning.
Create and utilise AWS CloudFormation templates to automate the creation of AWS images.
Apply Git and version-control practices within database development and delivery.
Implement improved database monitoring and alerting capabilities.
Collaborate within Agile product delivery teams.
Mentor, coach, and transfer technical knowledge to DBA team members.
Promote continuous improvement, effective troubleshooting, and operational stability.