- Knowledge, must have experience in Oracle Apps DBA (EBusiness Suite versions like R12.1 and R12.2) as a primary skill.
- Must have Knowledge of configuration, administrating, monitoring, troubleshooting, cloning, Patching in Oracle Apps 12.
- Basic WebLogic server administration needed, must be expertise in AD utilities, EBS Maintenance activities.
- Knowledge of Oracle security basics, and experience in working with ISO and Auditing.
- Expert in RAC, ASM, WebLogic Administration.
- Experience in all routine DBA tasks including health checks, troubleshooting issues and installations.
- Good knowledge of PLSQL and SQL Knowledge of traces, tkprof and find poorly performing SQL.
- SQL, profiling, rewrite poorly performing SQL.
- Knowledge of Load balancing, PCP, Configurators, JVMs, archiving and purging tools like HP Archiving, SOA gateway, ekanban knowledge is add on.
- Knowledge of oracle database wait events, Database and Application parameters Ability to fine tune the concurrent processing in large EBS environment.
- Extensive familiarity with OEM Tool.
- Install, upgrade, patch and administer the EBS application and database.
- Experience with Oracle data guard.
- Experience in RMAN backup & restore activities Knowledge of OS parameters and settings, UNIX shell scripting, performing (DB + Application) Patch Analysis & Applying Patches.