ORACLE Applications Database Administrator ( 3 / 21 )

Posted: 16-Feb-2021

As Qualificatios &  Responsibilities

  1. Handling tickets raised by functional/technical/business users
  2. Handling Alerts raised by alert monitoring system from Database and applications
  3. Tablespace Reorg Activities to improve the performance/to reclaim the unused space
  4. Schema Reorg Activities to improve the performance
  5. Patch Analysis where there is a patch needs to be applied
  6. Patch Application as per schedule
  7. Cloning as per schedules
  8. Backups and issues related to them
  9. Query response time and other Performance Issues
  10. Work with Oracle Support by raising SRs on several issues
  11. Monitoring Standby Databases and resolve respective issues
  12. Ability to work independently and handle a team, work with business to gather requirements, prepare technical specification documents
  13. Ability to create/review/audit technical specification.

  1. Must have knowledge about concurrent managers
  2. Backup and clean up various log files
  3. Must be skilled in sysadmin activities like user administration responsibilities, request groups, register forms, printer setup, register custom applications, etc.
  4. Implementing 24x7 production support procedures
  5. Manage, monitor and configuring workflow
  6. Creating database users and maintaining password rights
  7. Expertise in RMAN, hot and cold backups
  8. Monitoring database using OEM and custom scripts
  9. Database lock, space management, export and import of the database, performance tuning at DB and apps Level
  10. Must have good troubleshooting skills
  11. Oracle core DBA skills for supporting Oracle database 10g/11g with RAC/Non-RAC environment.
  12. Good exposure in Oracle Applications R12 Maintenance , Cloning, Patching
  13. Well versed in using AD Utilities (adpatch, adadmin, adctrl, and adsplice)
  14. Experience with Unix/Linux including basic commands and basic shell scripting.
  15. Good exposure of Backup and Recovery (Oracle RMAN, Import/Export, and Datapump)
  16. Oracle R12 Installation on windows and UNIX environment.


Bachelor Degree