Description
PROFESSIONAL SUMMARY * Senior Oracle DBA with more than 6 years IT experience in Oracle products on multiple platforms and environments spanning Finance, IT, Insurance, Communication and Tech sectors. * Experience as On-Call24x7productionDBA support, application/development DBA. * Extensive knowledge on database administration for Oracle 8i, 9i, 10g, 11g and 12C with experience in very large scale database environment and mission critical large OLTP and OLAP systems. * Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing. * Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC. * Extensive experience in Data guard configuration, implementing and monitoring standby databases. * Implemented FSFO (Fast start failover) on databases and configuring disaster recovery. Also proficient with new 11g features such as Active Data guard and Snapshot standby database. * Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via DGMGRL and GUI. * Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 9i/10g/11g. * Experience in database cloning with RMAN, Capacity Planning, Database Refresh and patch management. * Good experience in applying PSU and Critical Patch Update (CPU Patches) using OPATCH Utility on
Accomplishments
Highlights:
Keywords
