Oracle Apps DBA

Responsibilities

Job Description
• 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.