SUMMARY

• 5 years of extensive experience as an Oracle DBA on 10g, 11g and 12c in Standalone & RAC.
• Build RAC from scratch on Red Hat Enterprise Linux.
• Experience in Data Center Migration.
• Experience in setting up Oracle Data Guard and Grid Control.
• Experience in setting up ASM disk groups and Golden Gate.
• Set up Materialize View Server.
• Worked with many following 11g new features. For example:
• SQL Access Advisor
• SQL Performance Analyzer
• SQL Plan Manager
• Table compression enhancement
• Active Data Guard
• Upgraded from 10 to 11g R2 to 12c
• Query Result Caching
• Invisible Indexes.
• Database Replay.
• AWR Baseline Enhancements
• Automatic Memory Management.
• Automatic SQL Tuning.
• Data Recovery Advisor.
• Read - Only Tables
• Flashback Enhancements
• RMAN Enhancements
• Table Compression Enhancements.
• Worked on Tablespace/Extent/Segment Management
• Worked on Backup and recoveries using user managed and RMAN.
• Setup Oracle Enterprise Manager (OEM) 11g and 12c cloud control.
• Worked on 11g Cloud Grid Control for database monitoring / performance / diagnostics.
• Used RMAN extensively to backup, restore and recover databases.
• Managed Databases on Exadata Machines.
• Applied CPU and PSU patches.
• Worked extensive with developers and application team.
• Used Data Pump and exp/imp tools to refreshes tables, schemas and databases.
• Managed databases using ASM.
• Managed databases using 12c cloud control and TOAD
• Worked with Oracle on open issues.

TECHNICAL SKILLS

Databases: Oracle RDBMS 9i, 10g, 11g, 12c, RAC, Grid Control, Data Guard

DBA Tools/Utilities: RMAN, Oracle Enterprise Manager, AWR, Oracle Diagnostics Pack, dbca, dbua, SQL*Plus, SQL*Loader, Oracle Export/Import utilities, statspack, explain plain, tkprof, TOAD, 12c cloud, data pump

Operating Systems: Linux, Sun Solaris, Confidential -UX, AIX, WindowsLanguages SQL, PL/SQL, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Oracle DBA

Responsibilities:

• Installed databases on Linux platform
• Installed 2-node cluster
• Provide 24x7x365 administrative support staff.
• Configure Data Guard to provide high availability using Physical stand by database.
• Use RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Install, configure and setup of 11g RAC on Linux.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Install and implement 10g RAC with 4 nodes with ASM.
• Upgrade Databases from 10g to 11g and apply patches per requirement.
• Work on data center migrations on multiple database versions. i.e., 9i, 10g and 11g.
• Responsible for installing and configuring Golden Gate on Oracle Servers.
• Database migration from standalone to RAC
• Design, configure and maintain backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Responsible for setting up Oracle Golden Gate to propagate information between databases.
• Recover databases and clone applications using RMAN.
• Use AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring & capacity planning for future database & server growth.
• Perform Range Partitioning to improve the performance of the database.
• Perform Cross platform migration using transportable tablespaces and RMAN.
• Perform Import and Export using Oracle Data pump utilities.
• Administer and maintain database security policies and procedures.
• Experience with administration of high-performance and large-scale multi-terabytes databases.
• Handle all standard database administrative tasks: proactive performance tuning and monitoring, trouble-shooting, backup, recovery, installations and configurations as needed.
• Use external tables and SQL*Loader to import data from flat files.
• Monitor database space requirements and adjust for future needs.
• Perform version upgrades and patch installs.
• Applied latest patches as per evaluation requirement.
• Performing tuning of application with Trace, tkprof, Explain plan, statspack, AWR and ADDM
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pump, Exports/Imports utility for moving data
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Applied CPU and PSU patches.
• Provided 24/7 on-call support
• Worked with offshore team members.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Performed Oracle DBA duties involving development and production support: installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
• Complete Build of 4-node 10g RAC Cluster on RHEL 4 from scratch.
• Migrated 10g database to 11g R2.
• Skilled with statspack, AWR, ADDM, ADDM to check health of database & hardware.
• Used Performance tuning tools such as tkprof, explain plans, oradebug and SQL Trace.
• Performed database cloning to setup test and development database.
• Migrated databases to different data datacenter.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Index management for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Responsible for administration and supporting oracle 11g, 10g and 9i databases
• Created, upgraded, and cloned Oracle databases for Development and testing databases.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Performed Hot/Cold backups of the database through RMAN or User Managed method.
• Reviewed alert logs and dump files to check for any problems related to the database.
• Created and maintained users, roles and privileges.
• Upgraded databases from 10g to 11g
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Assisted in Database sizing, Capacity Planning.
• Performed Space Management & Troubleshooting the database issues.
• Created materialized views to refresh data at regular intervals.
• Used materialized view logs to reduce the replication time costs for fast refreshes.
• Upgraded/Migrated databases from 10g to 11g
• Design and implement database backup/restore methodologies, responsible for troubleshooting performance and networking issues. Basic OS system administration.
• Strict adherence to policies and procedures - specifically change management.
• Perform database administration tasks as part of a scheduled change management task.
• Work effectively with multiple teams at once.
• Provide end-users with updates on their problems. Install server software.