Occupation:Database Administrator |
Location:Hillsborough, NC |
Education Level:Master |
Will Relocate:YES |
Description
Skills Summary * Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK. * Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams. * Experience in Oracle (12c, 11g, 10g) Multi-tenancy, DataGuard, ASM, RAC database, Grid, OEM, CPU patches, Oracle installation, database Upgrades, Migration, Backup, Recovery, troubleshooting, SR (TAR) support, Golden Gate, configuring new & leas-rolling. * Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate. * High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance. * Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC) * Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. * Performance Tuning of the database (Memory Tuning, I/O Tuning) * Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF. * Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g. * Extensive Experience with RMAN Backups, Hot Backups and Logical Backups. * Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.