Job Description

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\xe2\x80\x99s, 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.

• 5 - 8 years Oracle Experience
• Willingness to work in the 24*7 shifts.
• Excellent written and verbal communication skills.