Senior Consultant

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.2

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, 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.

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).