Oracle DBA

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 24×7 production support and on-call rotations, providing timely resolution of critical incidents and ensuring service availability.

Education & Experience

• 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 24×7 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 24×7 Production Support environment with on-call rotation.

   

Culture Commitment

Ensure adherence to company’s 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.