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 Oracle 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 the 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), Oracle Data Pump (EXPDP/IMPDP), and advanced migration methodologies.
• Develop and maintain GoldenGate Extracts, Replicats, Distribution Services, and performance metrics.
• Troubleshoot replication lag, data inconsistencies, and integration issues.
• Implement encryption technologies, including Transparent Data Encryption (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.

Requirements

Minimum Qualifications:

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
• 10+ years of Oracle Database Administration experience in large enterprise environments.
• Extensive hands-on experience with:
• Oracle Database 19c Administration
• Oracle 19c RAC, ASM, Grid Infrastructure, Data Guard, Oracle GoldenGate 26AI, RMAN, Oracle Enterprise Manager (OEM), AIX, Linux, High Availability (HA), Disaster Recovery (DR) architectures
• Ansible automation
• Infrastructure as Code (IaC)
• 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

• Oracle database
• Advanced
• Design
• Automation
• Data guard
• Goldengate
• PL/SQL
• SQL
• Linux
• Oracle
• Data
• DATABASE