Rss

Roy N

Database Administrator - 6 Years of Experience

Occupation:

Database Administrator

Location:

Pittsburgh, PA

Education Level:

Bachelor

Will Relocate:

YES

CollapseDescription

Professional Summary: * Experienced in Performance Tuning using EXPLAIN PLAN, AWR, ADDM and the Oracle OEM GRID 12 control and oracle advisory framework. * Good in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Golden Gate. * High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance. * Proficient in installing oracle software, Versions in 10g, 11g and 12c releases, applying PSU and CPU patches and Opatch, upgrades and post upgrades cat bundle and OJVM to single instances, RAC and data guard configurations. * Expert in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF and AWR. * 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 of 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. * Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory. * Created indexes to facilitate easy user interface implementation and tuning. * Involved in construction of DR sites for all the Production and IST environments. * Performed Database Refresh from Production to TST, UAT and Development databases. Proficient with Database Cloning, Migration, and Patching of Oracle Databases. * Hands on ERPs Including EBS HRMS and CRM, knowledge Peoplesoft Pstools and Campus Solution for higher Education. * Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC. * Proficient in backup and migration using data pump and transportable tablespaces. * Worked on Setup, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes. * Expert in RMAN backups including full, incremental differential and cumulative. * Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases. * Extensively worked on Import/Export and Data Pump Import/Export tools. * Hands on in configuring ASM (Automatic Storage Management) * UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs. * Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity. * Expertise in maintaining Database Security using auditing. * Knowledge of advanced security configuration such as data masking, data redaction, column and tablespace TDE as well as Network Encryption. Technical Proficiencies:

Right_template4_bottom

CollapseWork Experience

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseKeywords

Left_template4_bottom