Senior Oracle Cloud DBA (OCI & Fusion Apps)

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

Education & Experience

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

Skills

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

• Strong interpersonal teaming and problem-solving skills.

• Work effectively with other members of Coherent Corp.

Working Conditions

• The work mode of Finisar India is Hybrid i.e. 3 days at office.

• Comfortable working in a 247 Production Support environment with on-call rotation.

CultureCommitment

Ensure adherence to companys values (ICARE) in all aspects of your position at Coherent Corp.:

Integrity Create an Environment of Trust

Collaboration Innovate Through the Sharing of Ideas

Accountability Own the Process and the Outcome

Respect Recognize the Value in Everyone

Enthusiasm Find a Sense of Purpose in Work

Coherent Corp. is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex gender identity sexual orientation race color religion national origin disability protected Veteran status age or any other characteristic protected by law.