Responsibility of a Database Administrator

Oracle DBA – Oracle database administrator is vested with the following responsibility as a quick summary :

1) Install Oracle software
2) Create Oracle database
3) Configure Oracle database parameters
4) create spfile from pfile – spfile is used for dynamic parameter changes
5) Start the oracle instance
6) Administer Oracle instance
7) Stop oracle instance
8) Move data across databases
9) Use datapump utilities – expdp/impdp
10) Use SQL*Loader utility
11) Transportable tablespaces feature
12) RMAN backup, restore, recovery
13) User managed backup technique
14) User managed recovery technique
15) Tuning instances
16) Tuning SQL
17) RAC – Real Application Cluster
18) Dataguard – Primary standby database, logical standby database configuration
19) V$views
20) Manage oracle objects
What are Daily Routine Tasks Of An Oracle DBA?
Monitoring for problems – running monitoring scripts or use the oracle built-in tools such as Enterprise manager.Check reports generated by monitoring scripts on a daily basis – disk space problems, memory allocation, disk I/O
Monitor alert log file – fix errors
Types of alert log errors – change some parameters, add some space, perform an administrative task
Use Metalink database and open a new tar with Oracle
Upgrade to latest versions – software, software and database( applications and DBA’s configuration parameters)
Test new applications to be deployed in the system.