I have considered the problem how to be a qualified oracle database adminstrator recently. And I have done a lot to get the answer for the problem, for example, reading some materials about oracle databse, visit the offical web site of oracle database. Now, I think I have got the answer.
There are eleven main duties as follows to be an DBA. So You have to learn how to deal with these problem if you want to be a qualified DBA. Once you can deal with all the followed problems, you have been an qualified DBA.
- Installing and upgrading the oracle dabase server and application tools (No matter any system, windows, linux, unix and solaris)
- Allocating storage and planning future storage requirements for database system.
- Creating primary database storage structures(tablespace) after application developers have designed an application
- Creating primary objects(tables, views, indexed) once developers have designed an application
- Modify the datase structure , as necessary, from information given by applicaton developers
- Enrolling users and maintaining system security
- Controlling and monintoring user access to database
- monitoring and optimizing the performance of database
- planning for backup and recovery of database information
- maintaining archived data on tape
- backing up and restoring the database