Good Knowledge of Oracle Architecture.
Knowledge of Oracle Database version 10g through 12c.
Oracle RAC 11g/12c, ASM, DATAGUARD, EXPDP/IMPDP, Golden Gate, Performance Tuning, OEM 13c,RMAN Backup and Recovery
Adhering to customer SLA, acknowledgment and as per SOW.
Performing core DBA BAU activities.
Work closely with onsite DBA and application team.
Offshore / onsite DBA or customer requirement.
Managing shift hours (16X5 support) and providing on-call support for production & business critical issues on weekends and off business hours.
Preparing Runbooks/SOPs and KB articles.
Do follow-ups with various teams to complete the task with the specified time.
Creating automation scripts for manual tasks. Example ( tasks which we do repeatedly and consumes lot of manual effort).
Performance tuning application code.
Build knowledge repository for critical activities like export/import, purging, archiving.
Work on special task ( like Golden gate configuration, Standby database creation, Partitioning) Assists leads for weekly status and Service now reporting.