Oracle - APPS - DBA

Exp: 3-5 Years

Role: FTE

Location: PAN Zensar

Work Mode: WFO

Core Skills:

Oracle E-Business Suite R12.2, Oracle Database 12c, 19c, rman, Shell scripting

Desired Skills:

-Good Knowledge in OS like Linux

-Excellent written and verbal communication skills

-Very good understanding of Oracle core database architecture and concepts

-Very good understanding of Oracle E-Business Suite R12.2 architecture and concepts

-Oracle SQLNet configuration and working knowledge

-Knowledge on Concurrent managers

-Monitoring OEM alerts and act on them.

-Installation, configuration and upgrading of Oracle server software and related products.

-Starting and Stopping the application and database

-Monitoring the application related products like oacore,oafm apache etc.

-Bouncing apache,oacore,oafm if needed

-Establish and maintain backup and recovery policies and procedures.

-Take care of the Database design and implementation.

-Implement and maintain database security (create and maintain users and roles, assign privileges).

-Work as part of a team and provide 247 support

-Perform general technical trouble shooting and give consultation to development teams.

-Interface with Oracle Corporation for technical support.

-Perform database tuning and performance monitoring.

-Perform application tuning and performance monitoring.

-Cloning DEV and TEST from PROD.

-Code Migration Support to Functional Consultants

-Handling tickets raised by functional/technical/business users

-Handling Alerts raised by alert monitoring system from Database and applications

-Patch Analysis where there is a patch needs to be applied

-Patch Application using adop online patch cycle as per schedule

-Cloning as per schedules

-Backups and issues related to them

-Query response time and other Performance Issues

-Work with Oracle Support by raising SRs on several issues

-Monitoring Standby Databases and resolve respective issues

-Regular database maintenance activities (tablespace management, datapump, purging logfiles etc.)