ORACLE DBA TOP SKILLS:
• Oracle 12c with good experience in PDB/CDB
Understanding of the Core Architecture
• Linux/Sun OS operating systems experience
• Strong Experience with:
• Dataguard & Switch-overs (Primary / Standby)
• Golden Gate - Configuring and managing replication
• Install/Configure RAC (Real Application Clusters 11g/12c)
• Transparent Data Encryption
• RMAN (Recovery Manager)
• OEM Agent Installation / Troubleshoot (OEM13c)
• Database migrations / Database Upgrades
• Grid / Oracle Home / DB Patching
• UNIX and shell scripting
• Good Knowledge / Hands on Experience in Exadata.
• CICD Tools – Jenkins
• stored procedures, triggers, functions, packages, partitioning and indexes.
• Performance Tuning – Perform root cause analysis, resolve problems and recommend solutions.
• recommending preventative database maintenance to provide availability capacity, integrity, and security against operating level agreements.
•
Desired Kills
• Basis architectural understanding
• Oracle Database Resource Manager
• Oracle Key Vault
• Oracle Unified Directory
Others
• Be part of On Call Rotations.