Oracle APPS Database Administrator (7+ years)

Location - Mumbai

Technical Expertise

MUST HAVE

• Oracle Core & Apps DBA with expertise and working knowledge on R12.1.x / R12.2.x environment.

• Sound Knowledge on 12c & 19c EBS databases along with RAC.

• Troubleshooting knowledge on critical problems and areas like CM, Apache, Database etc.

• Performed at least one database upgrade from 11g to 12c / 12c to 19c & EBS Upgrade from 12.1.3 to 12.2.x.

• Oracle Applications 11i/R12 Support and maintenance activities like refresh and patching on multi-node environments.

• Hands on experiences on Oracle application versions R12.2.0 and above versions.

• Hands on experiences on Oracle Security Patches on Application and databases.

• Ability to perform installations, software upgrades, and apply patches (Opatch and ADOP patches).

• Database upgrade to 19c and E-Business Suite Application upgrade to 12.2.

• Support & Maintain Oracle EBS Suite High Availability Design Spanning Data Centers - Database Node (RAC, Active Dataguard,

Physical Standby, Snapshot Standby, Switchover, Failover). Web Node (Load Balance Web Nodes, DNS/Network Configuration)

Forms Node (Load Balance Forms Nodes, Servlets), Parallel Concurrent Processing (Distribute load),

Adding an EBS Node in a Shared Application Tier Filesystem .

• Capable of delivering under critical environment pressure, resolve complex production issues & provide support when required;

• Proven track record for BAU tasks

• Expertise in query fine tuning and troubleshooting.

• Excellent verbal and written communication skills;

• Independent and strong team player with good inter-personal skills.

GOOD TO HAVE

• Good scripting(shell/ANSIBLE/PYTHON) skills to automate regular DBA admin tasks.

• Strong experience on configures and troubleshoot golden gate replication components.

• Banking domain experience will be added advantage

• RAC/Exadata/Exacc Administration

• Knowledge on OCI,DBASS utilities

• Exacc patching (D