DBA Task and Insurance Card

 

A DBA is like an insurance card; you use insurance in case of an emergency. Just like management uses a DBA when there is a data disaster.

* Oracle Installation,OEM use,

* RMAN backup,recovery,DR planning

* knowledge of dynamic performance views like how to find OS Pid and seid, sql statements

* Oracle CPU patch - MUST , how to patch enviroments - OPatch

* Security, Profile and Resource management

* Perform database tuning and performance monitoring

* Perform application tuning and performance monitoring,Tuning - explain plan and tkprof ( tkprof levels like 12,8,4)

* Setup and maintain documentation and standards

* Capacity planning

* On Call DBA - 24*7

* Statspack/AWR analysis, knowledge of wait events

* Interaction with Oracle Corporation for technical support.