Senior Oracle Database Administrator

Job Description

JRH is seeking a Senior Oracle Database Administrator to administer, secure, optimize, monitor, and support enterprise Oracle database environments for a federal health research customer. The role supports development, test, and production databases across on-premises and cloud environments and requires advanced expertise in standalone and multitenant architecture, Data Guard, RMAN, Data Pump, GoldenGate, SQL and PL/SQL, performance tuning, troubleshooting, security, backup, recovery, and data integration.

Key Responsibilities

· Administer Oracle databases in development, test, staging, disaster-recovery, and production environments.

· Support standalone and multitenant Oracle architectures across Windows, Linux, Unix, on-premises, and cloud environments.

· Install, configure, patch, upgrade, secure, monitor, and troubleshoot Oracle database software, clients, listeners, and supporting components.

· Design, implement, maintain, monitor, and troubleshoot Oracle Data Guard configurations and high-availability capabilities.

· Configure and administer Oracle GoldenGate replication, data synchronization, and related monitoring.

· Plan, execute, validate, and document RMAN backups, restores, point-in-time recovery, disaster-recovery testing, and recovery procedures.

· Perform Oracle Data Pump export/import, schema migration, data refresh, DDL/DML deployment, and environment synchronization activities.

· Write, review, optimize, and troubleshoot SQL, PL/SQL, stored procedures, packages, functions, triggers, views, and database jobs.

· Perform performance analysis and tuning using execution plans, indexing, statistics, memory configuration, wait events, workload data, and monitoring tools.

· Configure and monitor job scheduling, database health, replication status, storage, capacity, resource use, availability, and daily operational processes.

· Manage database users, roles, privileges, service accounts, authentication, auditing,...