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