YASH Technologies - Senior Consultant - Oracle Apps / DBA

Description :

• 8 to 10 years of Oracle Apps DBA Experience.
• Willingness to work 24-7 shifts.
• Deep understanding of Oracle E-Business Suite architecture and components.
• Expertise in Oracle database administration, including SQL, PL / SQL, and database concepts.
• 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.
• Oracle Apps DBA (EBS), Unix / Linux / AIX, General Cloning, Patching, Backup Skills & Performance Tuning.
• 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.
• Knowledge of cloud (OCI).

(ref : hirist.tech)