Senior Oracle Database Administrator

TheCorporate LLC; Town of Oakland (WI); On-site; USD 140,000 - 190,000; Full time

Job summary

TheCorporate LLC in Oakland, CA is seeking a Senior Oracle Database Administrator to lead design, implementation, and optimization of enterprise Oracle databases. You will drive high availability using RAC, Data Guard, and GoldenGate, while guiding modernization efforts and automation across platforms.

The ideal candidate has 10+ years of Oracle DBA experience, deep expertise in performance tuning, large migrations, SQL/PL/ Shell scripting, and IaC with Ansible.

Qualifications

• Bachelor's degree in a related discipline.
• 10 years of Oracle DBA experience in large enterprise environments.
• Extensive hands-on Oracle 19c including RAC, ASM, Grid Infrastructure, Data Guard, GoldenGate 26ai, RMAN, OEM.
• Strong expertise in performance tuning, SQL/PLSQL, scripting, and large migrations.

Responsibilities

• Install, configure, and maintain Oracle Grid Infrastructure, RAC, ASM, and Clusterware.
• Design highly available Oracle architectures using RAC and Data Guard.
• Perform provisioning, patching, cloning, upgrades, and lifecycle management.
• Design and maintain Data Guard configurations and migrations.
• Execute advanced performance tuning at multiple levels (database, SQL, RAC, OS).
• Optimize SQL, partitioning, and workload management; troubleshoot RAC issues.
• Manage schema upgrades and cross-environment data synchronization.
• Data conversions, re-platforming, and secure data transfers (TTS, Data Pump).
• Design and maintain GoldenGate 26AI microservices architecture and components.
• Develop and maintain IaC and automation with Ansible; automate deployments/maintenance.
• Support UC4 workload automation where applicable.

Skills

Database performance tuning

Shell scripting

Large-scale migrations

SQL/PLSQL

Automation

Education

Bachelor's degree in Computer Science, IT, Engineering, or related

Tools

Oracle 19c

Oracle RAC

ASM

Grid Infrastructure

Data Guard

GoldenGate

RMAN

OEM

AIX

LINUX

Ansible

UC4

Job description

Job Title: Senior Oracle Database Administrator

**Location:**Oakland, CA

Job Description:

Position Summary

We are seeking an experienced Senior Oracle Database Administrator to lead the administration, engineering, modernization, and optimization of enterprise Oracle database environments. The successful candidate will possess deep expertise in Oracle RAC, ASM, Data Guard, GoldenGate, performance tuning, large-scale data migrations, and database automation.

This role is responsible for designing, implementing, maintaining, and optimizing highly available Oracle database platforms supporting business-critical applications. The ideal candidate will have strong troubleshooting skills, automation expertise, and experience managing multi-terabyte databases within complex enterprise ecosystems. The role aligns with enterprise Oracle environments that leverage RAC, Data Guard, GoldenGate, automation, and large-scale databases.

Job Responsibilities

• Install, configure, and maintain Oracle Grid Infrastructure, RAC, ASM, and Clusterware environments.
• Design and support highly available Oracle database architectures utilizing RAC and Data Guard technologies.
• Perform database provisioning, patching, cloning, upgrades, and lifecycle management.
• Design, implement, and maintain Oracle Data Guard configurations.
• Perform advanced Oracle performance tuning at database, SQL, RAC, ASM, and operating system levels.
• Optimize SQL execution plans, partitioning strategies, and workload management.
• Troubleshoot RAC interconnect, cluster, locking, and contention issues.
• Manage schema upgrades and cross-environment data synchronization activities
• Perform data conversions and database re-platforming initiatives.
• Engineer secure data transfer mechanisms utilizing Transportable Tablespaces (TTS), Data Pump (EXPDP/IMPDP), and advanced migration methodologies.
• Design and manage data conversion, transformation, and database engineering solutions.
• Install, configure, and administer Oracle GoldenGate 26AI Microservices architecture.
• Develop GoldenGate Extracts, Replicats, Distribution Services, and Performance Metrics.
• Troubleshoot replication lag, data inconsistency, and integration issues.
• Implement encryption technologies including TDE, SSL certificates, and encrypted data transport mechanisms.
• maintain advanced partitioning strategies including range, interval, reference, and composite partitioning.
• Design Information Lifecycle Management (ILM) solutions.
• Design and maintain storage optimization, archival, and data retention policies.
• Support advanced Oracle object administration and schema engineering.
• Develop and maintain advanced Shell, SQL, and PL/SQL scripts.
• Implement Infrastructure as Code (IaC) and automation solutions using Ansible.
• Automate database deployment, monitoring, patching, and maintenance activities.
• Support UC4 workload automation where applicable.

Minimum Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related discipline.

• 10 years of Oracle Database Administration experience in large enterprise environments.

• Extensive hands-on experience with: Oracle 19c Administration

  o Oracle 19c RAC, ASM, Grid Infrastructure, Data Guard, Golden Gate 26ai, RMAN, OEM, AIX, LINUX, High Availability and Disaster Recovery architectures, Ansible Automation and Infrastructure as Code.

• Strong expertise in:

  o Database performance tuning, SQL and PL/SQL development, Shell scripting, Large-scale database migrations

Preferred Qualifications

• Oracle Certified Professional (OCP) or Oracle Certified Master (OCM).
• Experience with Oracle GoldenGate 26AI Microservices.
• Knowledge of Database Migration Services (DMS)
• Experience with UC4 workload automation solutions.