Description
SUMMARY I am a certified Oracle Database Administrator with 5 years of experience. I have Installed and configured Oracle 12c, 11gR2 and 10g. I have performed Patches, upgrades and migration across different platforms (endians), Backup and Recovery, Cloning, Replication, Database Security and Memory Management. I have experience configuring and managing Oracle Real Application Cluster (RAC), Data Guard and Golden Gate for Oracle High Availability. I am also Open to on-call support. * Experience in setup, configuration and implementation of RAC on Linux with ASM. * Proficient in Upgrades, Patches (PSU, CPU), Migration and Production support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation. * Experienced in Database Backups and Recovery Strategies Using RMAN: Hot and Cold Backup, RMAN Duplicate Databases and FLASHBACK recovery features, including disaster recovery. * Procedures using RMAN, VERITAS Net Backup. Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas and to restore the Dev, Test databases. * Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning. * Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 10g and 11g ASM. * Strong programming experience in creating Packages, Stored Procedures and Functions, Triggers. * Proactive monitoring, identifying tuning opportunities and tuning using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring. * Automated tasks using scripts and Crontab: Backups, exports and imports, archiving old records and verification of such processes. * Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Optimization, Troubleshooting, tuning backups * Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROF and ADDM reports. Proven ability of providing production support for 24X7 * Managing the cluster resources and performing health check of all instances within the cluster.
Accomplishments
Highlights:
Keywords
