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