Oracle Database Administrator

Job Description Job Title: IT Oracle Database AdministratorJob Location(s): Perth, Havant, Readingworking model: HybridJob 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 ResponsibilitiesDatabase Installation & ConfigurationInstall, 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 ManagementAdminister users, roles, privileges, and authentication.Implement encryption, auditing, and compliance controls.Apply quarterly CPU/RU patches across environments.Performance Monitoring & TuningMonitor 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 AvailabilityPerform 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 & ScriptingAutomate DBA tasks using Shell scripts and cron jobs.Create scripts for monitoring, backup checks, and maintenance.TroubleshootingResolve 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 CollaborationSupport 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 & DocumentationEnsure compliance with GDPR, ISO, and internal governance standards.Maintain documentation for configurations, procedures, and DR runbooks.CertificationsOracle Certified Professional (OCP) or equivalent certification preferred.Cloud certifications such as Azure Administrator, AWS Solutions Architect Associate, or Database Specialty are advantageous.

Created: 2025-12-12