Oracle APPS Database Administrator

Trigent Software Private Limited

Job Location:

Mumbai - India

Monthly Salary: Not Disclosed

Posted on: 9 hours ago

Vacancies: 1 Vacancy

Job Summary

Takes up technical tasks and support day to day BAU tasks/Incidents/RFCs.
Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.
Proposes service improvements for all Oracle/EBS services supported throughout the organization.
Provides technical knowledge supports services both proactively and reactively to maintain the availability and reliability of database system infrastructure in accordance to the SLA.
Works in line with policies based on LEAN-CA-CIB best practices.
Actively engages during any high severity issue and drives for issue resolution.
Reviews technology changes to identify potential risks.
Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.
Is aware of the global IT structure so that he/she anticipates interrelationships within the organization.
Engages with technical peer Development team Service managers Architect and project teams on technology roadmap and projects.
Facilitates transformation projects and suggest future directions for new areas of improvement and enhancements.
Guarantees the production readiness.
Is available and able to drive technically any complex or high severity incidents that occur within the scope of their role.
Actively engages to understand new technologies and technology trends and reviews them with a view to incorporate them into Bank operations.

Key Responsibilities

Technical Expertise

MUST HAVE
Oracle Core & Apps DBA with expertise and working knowledge on R12.1.x / R12.2.x environment.
should have working experience on Oracle Exacc RAC and DG.
Exacc patching (DOM0DOMUGRIDDATABASE)
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
Knowledge on OCIDBASS utilities

Takes up technical tasks and support day to day BAU tasks/Incidents/RFCs. Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise. Proposes service improvements for all Oracle/EBS services supported throughout the organization. Provides technical knowledge su...