Good understanding of the Oracle database architecture (Single Instance, RAC and ASM), related utilities and tools on Oracle 11gr2 and 12c.A good understanding of the underlying operating system (Linux).
A good knowledge of the physical database design.
Knowledge of Oracle backup and recovery scenarios.
Good knowledge of RMAN restore and export and import activities.
Good knowledge of Oracle high availability solutions like RAC and Dataguard.
A DBA should be able to work independently on L1 and L2 issues. Perform operations in a manner in which the impact on database downtime is minimized and in accordance with established customer standard operating procedures.
A DBA should have sound communication skills.
Basic knowledge of both database and system performance tuning.
A DBA should be able to work on OEM (Oracle Enterprise Manager Grid Control) 11g,12c to diagnose database issues.
Create, Upgrade and Manage production, QA and development database environments.
A good understanding of the underlying operating system and basic knowledge of network and storage.
Worked in an environment where ticketing system is used.
Maintain a Log Activity Report and report the same to the Senior DBA.