Oracle - APPS - DBA
4 weeks ago
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.)
