Senior Oracle Database Administrator

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.
• 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.
• 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.

Requirements

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.

Skills

• Data Guard
• Automation
• Advanced
• Design
• Oracle
• Data
• Oracle Database
• SQL
• Databases
• Goldengate