Oracle Application Database Administrator

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. Plan for instance growth requirements. Good knowledge in the latest versions of Oracle database/E Business suite architecture and components (19c, 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, 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

Must have good com skills. One has to work for 4 days from office in a week.