SUMMARY

• I am working as Oracle Database Administrator over 9 years.
• My main area of experience has been administrating business critical databases, installation and configuration of oracle, creating and upgrading databases. My technological forte is Oracle from versions 8i to 11GR2.
• In - depth knowledge and experience in full life-cycle database including data architecture, logical and physical database design, implementation, and administration
• Experienced in database administration of 8i/9i/10g/11g databases on heterogeneous and complex Datacenter environment
• Experienced in Migrating databases from file systems to ASM
• Experienced in implementing Real Application Clusters (RAC) on a variety of Oracle versions (10G,11GR1 & 11GR2) on Linux
• Experienced in upgrading databases from one version of oracle to higher version
• Capacity planning of critical production databases
• Experienced in configuring Disaster Recovery Site for single instance and RAC databases
• Experienced in various scenarios of Database Recovery and troubleshooting
• Experience in Replicating/Cloning of production databases for creation of DEV/UAT environments
• Solid skills in database optimization and performance tuning for servers, applications, and SQL queries
• Applying the CPU/PSU patches to fix the existing bug as per the Business policy
• Installation, Configuration, Administration and Patching of Grid Control / Oracle Management Agents
• Experience in data migrations using data pumps between various environments
• Implemented partitioning for better load balancing of data and to ease data purging in archival activities.
• Experience in Implementing RMAN backup with Recovery catalog and optimizing the backup timing and utilization of backup resources and fast recovery of the system in case of Failure.
• Experienced on implementing the Outline(9i) and AWR baseline (10G and above) for making the database plan consistency and improving the Query performance.
• Implemented Bi-Directional replication between 11gR2 databasesusing Goldengate.

TECHNICAL SKILLS

Software Products: Oracle 8i / 9i/ 10g/11gR1/R2 SQL / PLSQL

Tools: SQL *Plus, OEM, TOAD, RMAN, Exp / Imp, SQLDR, PLSQL Profiler.

Operating Systems: Redhat Linux and Suse Linux.

PROFESSIONAL EXPERIENCE

Confidential, Aliquippa, PA

Senior Oracle DBA

Responsibilities:

• Provided 24 X 7 Production support.
• Implemented 2-node 11gR2 RAC in Production environments and administration with ASM.
• OEM 12c (12.1.0.2) grid control setup with High availability at OMS level (2 node Active/Active OMS).
• Performed following in OEM 12c administration - installing agents on targets, discovering the targets, installing plug-ins on OMS and agents,applying patches on OMS, OMR and agents, creating groups, creating incident rule sets for groups, creating and applying templates, creating metrics extensions, creating system and configuring services for each application.
• Applied patches for 11gR2 RAC databases
• Implemented Bi-Directional replication between 11gR2 database using Goldengate.
• Performed Backup and Recovery using RMAN and written shell scripts for scheduled online backups.
• Troubleshooting RMAN backup and recovery related issues.
• Migrated 10g database from Windows to Linux platform.
• Implemented 11gR2 Active Dataguard for disaster recovery.
• Converted a single instance database to Oracle RAC 11gR2
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Performed Cloning, export/import and Patching.
• AWR for analyzing the performance bottlenecks

Confidential - Dallas-TX

Production Database Administrator

Responsibilities:

• Managing and maintaining more than 20 production databases
• Installation of Oracle 11.2.0.1 Grid infrastructure and Oracle Database.
• RAC 10R2 & 11gR1 (Grid Infrastructure 11gR2) administration and maintenance
• Performed data migrations using data pumps, and transport tablespace between various environments
• Installed and configured all systems with 11G oracle Grid control monitoring
• Configuring alerts for DB health check, generating snap reports on regular basis and for monitoring space usage.
• Developing archival policies in coordination with business.
• Developed capacity planning by observing the trend of DB growth.
• Configuring Migration databases for dry run.
• Implementing partitioning for better load balancing of data and to ease data purging in archival activities.
• Application and SQL performance tuning
• Trouble shooting 24*7 production environment issues.
• Implementing Security features as specified by the Client’s Security policy.
• Configured Recovery Manager for Backup & Recovery of Development / Testing Environment
• Applying the CPU/PSU patches to fix the existing bug as per the Business policy
• Installation, Configuration, Administration and Patching of Grid Control / Oracle Management Agents
• Managing the Oracle Golden Gate replication process.

Confidential

Database Administration

Responsibilities:

• Prepared plan for Up gradation along with time lines
• Performed upgrade in POC environment
• Installation of Oracle 10.2.0.4 and upgraded the database
• Building load test environments by migration/cloning DB’s across servers

Confidential

Responsibilities:

• 24*7 production Support for production systems
• Installation of Oracle 8i/9i/10g and database creation
• Monitoring space, wait events, locks and long operations running on the database
• Monitoring the alert log for the database performance and resolving the performance issues.
• Generating stats pack reports on regular basis to identify the database performance at peak load
• Tuning the SQL statement by analyzing the explain plan and ADDM reports
• Implemented scripts to monitor and get information on free space, alert log errors
• Design & developed PL/SQL Stored Procedures & Database Triggers to Implement Business rules & Security.
• Reorganized the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.
• Migrated the data from one database to the other using RMAN and Export / Import Utility.
• Backup and Recovery of databases using Recovery Manager.