Oracle DBA

  • 2-4 years’ experience in Oracle DB.
  • Oracle DB Installation, configuration and upgrading of Oracle server software and related products.
  • Starting and Stopping the application.
  • 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 when required
  • 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.
  • Handling Alerts raised by alert monitoring system from Database and applications
  • Tablespace Reorg Activities to improve the performance/to reclaim the unused space
  • Schema Reorg Activities to improve the performance
  • Patch Analysis where there is a patch needs to be applied
  • Interact with Network/OS teams on network setups and load balancer setups.
  • Attend Client Meetings to understand their expectations.
  • Involve in Business User Meetings to understand their expectations.