Oracle Application Database Administrator (5-8 yrs)

Experience : 5+ years.

MUST HAVE :

- Oracle Core & Apps DBA with expertise and working knowledge on R12.x / R12.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.3 to 12.

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

- Hands on experiences on Oracle application versions R12.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.

- 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 (DOM0,DOMU,GRID,DATABASE).