As an Oracle DBA, we have to carry out the following tasks :
* Installing Oracle software
* Creating Oracle databases
* Performing upgrades of the database and software to new release levels
* Starting up and shutting down the database
* Managing the database’s storage structures
* Managing users and security
* Managing schema objects, such as tables, indexes, and views
* Making database backups and performing recovery when necessary
* Proactively monitoring the database’s health and taking preventive or corrective actions as required
* Monitoring and tuning performance
In a small-to-midsize database environment, a single DBA might be the sole person performing all these tasks. In large enterprise environments, the whole job is often divided among several DBAs titled as Database Security Administrator or Database Tuning Expert, each with his/her own area of specialties.
