Oracle Apps DBA

Coherent Corp.; Hyderabad; On-site; INR 1,300,000 - 2,100,000; Full time

Job summary

Coherent Corp. is seeking an experienced Oracle Database Administrator to design, implement, and manage Oracle DB environments across OCI, SaaS, and on-premises. You will lead migrations, ensure high availability, and maintain security and performance.

The role requires strong hands-on experience with RMAN, Data Guard, GoldenGate, and Oracle EBS environments, plus deep knowledge of OCI services and networking. Hybrid cloud and enterprise-scale support are key aspects.

Qualifications

• Extensive experience designing and administering Oracle databases (19c/21c/23ai/26ai) across hybrid cloud and on-premises.
• Proficient in RMAN, Data Guard, GoldenGate, and cross-platform migration methodologies.
• Experience with Oracle E-Business Suite (EBS) environments.
• Strong knowledge of OCI services and OCI networking.
• Ability to plan zero-downtime migrations and DR strategies.

Responsibilities

• Design, implement, and administer Oracle database environments across OCI, SaaS and on-premises.
• Lead Oracle application/database migrations from on-prem to OCI.
• Provide day-to-day DB administration, monitoring, and production support.
• Implement high availability, DR, and backup strategies.
• Monitor performance and tune SQL with AWR/ASH.

Skills

Oracle Database Administration

OCI Cloud Expertise

Migrations & Upgrades

Performance Tuning

SQL/PLSQL scripting

High Availability & DR

Tools

Oracle Enterprise Manager (OEM)

RMAN

GoldenGate

Data Guard

EBS Administration

Dell EMC Avamar

Commvault

Job description

Job Description:

Job Description

Primary Duties & Responsibilities

• Design, implement, and administer Oracle database environments across Oracle Cloud Infrastructure (OCI), Oracle SaaS applications such as ERP Fusion, SCM and PLM along with on-premises platforms, ensuring high availability, scalability, and security.
• Lead and support end-to-end Oracle application and database migrations from on-premises environments to OCI, including assessment, planning, execution, validation, and post-migration support.
• Provision, configure, and manage OCI services including Compute, Virtual Cloud Networks (VCN), Block Volumes, Object Storage, Load Balancers, IAM, Autonomous Database, VPN/FastConnect, and Backup & Recovery services supporting Oracle workloads.
• Optimize OCI infrastructure by right-sizing compute resources, storage, networking, backups, licensing, and overall cloud cost and performance.
• Design and implement high availability and disaster recovery solutions using Oracle Data Guard, RAC, Oracle GoldenGate, and OCI-native services.
• Plan and execute zero or near-zero downtime database migrations using Oracle GoldenGate, Data Guard, RMAN Duplicate, Data Pump (expdp/impdp), Transportable Tablespaces, and cross-platform migration methodologies.
• Design, implement, administer, and optimize Oracle Database (19c/21c/23ai/26ai) environments, including Single Instance and RAC deployments across cloud and on-premises infrastructure.
• Install, configure, patch, upgrade, clone, and maintain Oracle databases and Oracle E-Business Suite (EBS) production and non-production environments.
• Support Oracle E-Business Suite (EBS), Oracle databases, engineering databases, and other enterprise applications as part of a global DBA team.
• Provide day-to-day administration, monitoring, troubleshooting, and production support for Oracle Applications and databases, ensuring high availability and operational stability.
• Perform Oracle EBS environment refreshes, cloning, application patching, and technology stack maintenance using Oracle-recommended tools and utilities.
• Weblogic Installation, upgrade and administration
• Implement, maintain, and validate backup and recovery strategies using RMAN and enterprise backup solutions such as Dell EMC Avamar, Commvault, or NetApp Snapshot technologies.
• Monitor database and application health using Oracle Enterprise Manager (OEM), and custom monitoring solutions; proactively resolve performance, capacity, and availability issues.
• Perform Oracle database performance tuning, SQL optimization, indexing strategies, AWR/ASH analysis, and capacity planning.
• Develop and maintain Shell, SQL, and PL/SQL scripts to automate database administration, monitoring, and operational tasks.
• Manage database security, user access, SSL certificates, encryption, and compliance with organizational security standards and best practices.
• Execute database changes through