Provided Database engineering solutions to critical infrastructure and payment related databases with 24/7 support as a part of GCS (Global Customer Support) project.
Expertise on new technologies like Multitenant Architecture, RAC, ASM, Performance Tuning, RMAN. RMAN Duplicate , Export /Import ,Materialized view refreshes, AUM.
Very proficient in problem solving, troubleshooting , determining RCAs of the issues of the live database issues.
Experienced in triage using various types & levels of tracing i.e call stack traces , error stack tracing , determining performance degradation using 10046 traces, TKPROF
Well versed with handling transaction recovery scenarios and slowness .
Good knowledge of resolving excessive archive generation issues by making use of logminer and AWR , ASH reports.
Proficient in use of hanganalyze & SSD( System State Dumps) for determining DDL,DML query slowness and hang situations.
Resolving data dictionary inconsistencies and corruption issues.
6 years of extensive experience in handling OLTP environments ,solving real time database issues.
Worked as a BDE (Bug Development Engineer) by taking the role of pre-defect screening , building , validating test cases and logging them as a potential defects upon qualifying .
Storage , tabelspace , extent and segment management – System & Sysaux tablespace management ,, resize .re-org , compact ,coalesce & shrink operations.
Analysis of various critical errors: (ORA-0445, ORA-01555,