Oracle Apps DBA

Oracle Apps DBA is required to support Production / Stage / Development Oracle EBS in 24*7 shift support model. The Oracle APPS DBA will be responsible for installation, configuration, upgrading, administrating, monitoring, troubleshooting, cloning, Patching, Backup and restore of Oracle EBS.

Would be responsible for reviewing application / databases, identify performance bottlenecks and fixing along with daily production health checks.

RESPONSIBILITIES
• Performing Daily health checks for production environment, identifying the performance bottlenecks and working on to fix them.
• Perform regular DBA support using tools like Serena or ServiceNow.
• Providing technical inputs towards maintaining large complex production environment.
• Perform Capacity planning for instances and growth.
• Good knowledge in latest versions of Oracle database / E Business suite architecture and components (12c, 12.2 ebs, etc.)
• 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, JVM’s, 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.
• Good knowledge of OEM.
• Install, upgrade, patch and administer the EBusiness 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.

EXPERIENCE
• 4+ years Oracle Experience
• Willingness to work in the 24*7 shifts.
• Excellent written and verbal communication skills