Description

• 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.
• Implement and 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: 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: 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

Key Skills

Education

Bachelor's degree