Oracle Database Administrator

Job Title: IT Oracle Database Administrator
Duration: 6 months
Location: Reading/Havant/Perth

Job Description:
We are seeking an experienced Oracle Database Administrator to manage, optimise, and secure Oracle database environments on Red Hat Enterprise Linux (RHEL) as well as Azure and AWS cloud platforms. The ideal candidate will have strong expertise in Oracle administration, performance tuning, automation, and cloud-native deployments.

Key Responsibilities
Database Installation & Configuration

• Install, configure, and upgrade Oracle Database software on Red Hat Enterprise Linux (RHEL) systems.
• Configure and manage database storage structures including tablespaces, data files, and Oracle Automatic Storage Management (ASM).
• Support cloud database deployments and hybrid setups in Azure and AWS (IaaS, PaaS, lift-and-shift, storage integration).

Security & Access Management

• Administer users, roles, privileges, and authentication.
• Implement encryption, auditing, and compliance controls.
• Apply quarterly CPU/RU patches across environments.

Performance Monitoring & Tuning
Monitor and analyse performance using:

• AWR (Automatic Workload Repository) - for gathering performance statistics and generating reports on system load.
• ASH (Active Session History) - for Real Time session-level performance diagnostics.
• ADDM (Automatic Database Diagnostic Monitor) - for automated analysis and tuning recommendations.
• OEM (Oracle Enterprise Manager) - for centralised monitoring, alerting, and automation.
• OS-level tools such as top, vmstat, sar, iostat, netstat, lsof, dstat, and systemd journal logs to diagnose CPU, memory, disk I/O, and network issues.
• Tune SQL, SGA/PGA memory, CPU, and I/O performance.

Backup, Recovery & High Availability

• Perform RMAN backups and Data Pump operations.
• Validate backups and ensure DR readiness (Data Guard, cloud backups).
• Support HA/DR architectures across on-prem, Azure, and AWS.

Automation & Scripting

• Automate DBA tasks using Shell Scripts and cron jobs.
• Create scripts for monitoring, backup checks, and maintenance.

Troubleshooting

• Resolve complex issues related to I/O, memory, CPU, and network performance.
• Work with Linux, cloud, storage, and application teams to resolve cross-stack issues.

Cloud & DevOps Collaboration

• Support deployments, migrations, and integration activities across Azure and AWS (EC2, RDS, S3, Azure VM, Azure Backup, Azure Storage).
• Work closely with application developers, DevOps engineers, and infrastructure teams on schema changes, CI/CD pipelines, and environment provisioning.

Compliance & Documentation

• Ensure compliance with GDPR, ISO, and internal governance standards.
• Maintain documentation for configurations, procedures, and DR runbooks.

Certifications

• Oracle Certified Professional (OCP) or equivalent certification preferred.
• Cloud certifications such as Azure Administrator, AWS Solutions Architect Associate, or Database Specialty are advantageous.

Guidant, Carbon60, Lorien & SRG - The Impellam Group Portfolio are acting as an Employment Business in relation to this vacancy.