Senior Oracle Apps DBA (OCI & Fusion Apps)

Coherent; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Coherent in Hyderabad, India is seeking an experienced Oracle DBA to design, implement and manage Oracle databases across OCI and on-premises environments, ensuring high availability, security and operational stability.

You will lead end-to-end migrations to OCI, optimize compute and storage, implement HA/DR using Data Guard, RAC and GoldenGate, and support Oracle E-Business Suite and engineering databases. Strong scripting and monitoring skills are required, with on-call rotations.

Qualifications

• Bachelor's degree in computer science or a related field.
• 5+ years of experience managing and administering Oracle databases (19c/21c) across on-premises, hybrid, and OCI environments.
• 3+ years hands-on OCI experience: provisioning, administration, migration, and support.
• Experience with Agile, EBS, and Oracle databases.

Responsibilities

• Design, implement, and administer Oracle database environments across OCI and on-premises, ensuring high availability and security.
• Lead end-to-end Oracle application and database migrations from on-premises to OCI.
• Provision, configure, and manage OCI services including Compute, VCN, Block Volumes, Object Storage, Load Balancers, IAM, Autonomous Database, VPN/FastConnect, and Backup & Recovery services.
• Optimize OCI infrastructure by right-sizing compute resources, storage, networking, backups, licensing, and performance.
• Design and implement high availability and disaster recovery solutions using Data Guard, RAC, GoldenGate, and OCI-native services.
• Plan and execute zero or near-zero downtime database migrations using GoldenGate, Data Guard, RMAN Duplicate, Data Pump, Transportable Tablespaces, and cross-platform methodology.
• Install, patch, upgrade, clone, and maintain Oracle databases and EBS environments.
• Support Oracle EBS, Oracle databases, and engineering databases as part of a global DBA team.
• Provide day-to-day administration, monitoring, troubleshooting, and production support for Oracle Applications and databases.
• Perform environment refreshes, cloning, patching, and stack maintenance using Oracle-recommended tools.
• Weblogic installation, upgrade and administration.
• Implement, maintain, and validate backup and recovery strategies using RMAN and enterprise backups.
• Monitor health with OEM and proactive resolution of performance and availability issues.
• Perform database performance tuning, SQL optimization, indexing, and capacity planning.
• Develop and maintain Shell, SQL, and PL/SQL scripts for automation.
• Manage database security, user access, SSL, encryption and compliance with security standards.
• Execute database changes through Change Management and participate in deployments and production support.
• Collaborate with developers and cross-functional teams to review changes and optimize SQL.
• Participate in 24/7 production support and on-call rotations.

Skills

Oracle DB

OCI (Oracle Cloud Infrastructure)

Oracle EBS

OEM

RMAN

Data Guard

GoldenGate

SQL & PL/SQL

Shell scripting

Performance tuning

Security & compliance

On-call support

Education

Bachelor's degree in Computer Science or related field

Tools

OCI

EBS

OEM

RMAN

Data Guard

GoldenGate

Avamar

Commvault

ITSM tools

OCI (Oracle Cloud Infra)

Job description

Role & 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 established Change Management processes and participate in release planning, deployments, and production support activities.
• Collaborate with application developers and cross-functional teams to review database changes, optimize SQL performance, and support new application development initiatives.
• Participate in 247 production support and on-call rotations, providing timely resolution of critical incidents and ensuring service availability.

Preferred candidate profile

• Bachelor's degree in computer science engineering or related field
• 5+ years of relevant experience in managing and administering Oracle databases (19c/21c) across on-premises, hybrid, and Oracle Cloud Infrastructure (OCI) environments., high-volume transactional and reporting databases.
• 3+ years of hands-on experience with Oracle Cloud Infrastructure (OCI), including database provisioning, administration, migration, and operational support.
• Experience with Agile, Demantra, Salesforce, Oracle E-Business Suite (EBS), and engineering Oracle databases.
• Oracle database upgrade, migration, and on premises to OCI cloud migration experience is highly desired.
• Experience in Production Support and Project Support is required.
• Experience using tools such as Commvault, Avamar, Spotlight, Oracle Enterprise Manager (OEM), RMAN, and ITSM/ticketing tools.
• Any Oracle Database or Oracle Cloud Infrastructure (OCI) certification is a plus.
• Strong change management skills and ability to operate effectively in a fast-paced environment.
• Excellent written and verbal communication skills.
• Team player, comfortable working in a 247 Production Support environment with on-call rotation.