Oracle DBA


Core DBA Task:

  • Database Architecture.
  • Preparing Database Environment
  • Creating Oracle Database
  • Managing Oracle Instance
  • Configuring Oracle Network Environment
  • Managing DB storage Structure
  • Administering User Security
  • Managing Schema Objects
  • Database Maintenance
  • Backup and Recovery concepts
  • Performing Database Backups
  • Performing Database Recovery.
  • Startup and Shutdown Models/DB Creation
  • User /role/profile Mgmt/schema mgmt
  • P file/sp file mgmt
  • Storage mgmt
  • Backups ? Cold/hot/Rman
  • Mem tuning
  • Network tuning
  • Flashback DB
  • ASM
  • Data Guard
  • Auditing
  • Table space management

Apps DBA Task:

  • Architecture
  • Installation
  • Environment file setting
  • Application stop/start (listener start/stop)
  • Database start/stop
  • Apache concurrent manager up/down
  • Backups cold/hot/Rman
  • Application backup
  • Fndcpass
  • Application component
  • Ad utility
  • Cloning
  • Basics of AOL
  • Concurrent manager (standard, internal, CRM)
  • Basics of RAC
  • Form/report server management
  • Performance tuning
  • Mail server configuration
  • Upgradation