PROFESSIONAL SUMMARY:

• Over 8 years of experience as an Oracle Database Administrator, providing 24X7 production and development support for 11g/10g/9i databases on various platforms which include HP - UX, SUN SOLARIS, AIX, and Linux.
• Proficient in database administration, installation, configuration, upgrades, patching, performance tuning, backup and recovery, cloning, capacity planning, space management, database security, auditing, troubleshooting, physical and logical database design, Shell and Perl scripting and documentation.
• In-depth knowledge of Oracle internals and architecture.
• Good knowledge on Golden Gate and hands on experience in Shareplex replication.
• Good experience in configuring ASM.
• Expertise with databases running on UNIX /Linux using ASM.
• Expertise in implementation of High Availability solutions using Oracle 10g/11g RAC with ASM, Physical and Logical Standby Databases (Data Guard).
• Configuration of Oracle 11g/10g OEM Grid Control to monitor databases.
• Experience in active database cloning from non-RAC to RAC on ASM and vice versa using RMAN Duplicate (11gR2).
• Expertise in performing backups and recoveries using conventional hot & cold backups and RMAN.
• Good knowledge in developing RMAN scripts for database backups including hot and cold backup options for both RAC and stand alone instances.
• Good experience in resolving the issues related to installation, upgrades and patching.
• Expertise in cross platform data migration using Transportable Tablespaces.
• Expertise in tools like SQL Loader, Import/Export, Data Pump, RMAN, OEM Grid Control.
• Good experience in Transportable Tablespaces, Partitioning, SQL Tuning Advisor, Data Pump, Flashback, Virtual Private Databases, and Oracle Streams.
• Good experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Data modeling, Backup and Recovery procedures.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
• Excellent interpersonal skills and analytical skills.

TECHNICAL SKILLS:

Operating Systems: HP: UX, Sun Solaris, AIX, Red Hat Linux, Cisco Enterprise Linux and Windows

Database: Oracle 8i/9i/10g RAC/11g RAC

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, JAVA

Oracle Tools: RMAN, OEM, SQL*Loader, Oracle Warehouse Builder, OEM Grid Control, DBCA, Import/Export, Data Pump, Streams, Golden Gate

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Tools: TOAD, Shareplex

Database Modeling: Rational Rose, Erwin, Power Designer, Smart Draw

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr.Oracle DBA/Database Analyst

Responsibilities:

• 24x7 Production database support for multi-terabyte Oracle databases (largest is 40TB).
• Configure and maintain multiple Oracle 11gR1/R2 RAC and Non-RAC databases on ASM using EMC & NETAPP as storage.
• Multi-node RAC setup on Red Hat / Cisco Enterprise Linux platforms.
• Configured & maintained OLTP databases up to 40 TB.
• Upgraded databases from Oracle 9.2.0.8 to 10.2.0.4.
• 11g database migration and upgrade from HP-UX to CEL (Cisco Enterprise Linux) running on UCS (Cisco Hardware) using transportable tablespaces.
• Migrated databases from non-ASM to ASM.
• Cloned databases from PROD to non-prod using RMAN Duplicate to support testing teams.
• Applied various One-off and PSU Patches for Oracle 11gR2 GRID/RDBMS homes.
• Configured and maintained Physical Standby databases using DataGuard and Dataguard Broker.
• Installed Oracle Enterprise Manager (OEM) Agent on Linux Platform.
• Sound knowledge in using crsctl, srvctl, dgmgrl etc., for RAC and Dataguard regular maintenance tasks.
• Implemented various Partitioning schemes which include RANGE, HASH, LIST, INTERVAL, COMPOSITE, and REF partitioning to reduce contention on hot tables, improve query performance, and to simplify data management tasks.
• Good Knowledge in Oracle Golden Gate.
• Implemented Oracle Scheduler jobs for various maintenance tasks.
• Storage management, sizing the database objects, monitoring file systems, and table space growth.
• Work with Oracle support to resolve Oracle bugs and database issues.
• Provide database support during monthly & quarterly releases.
• Maintain and periodically test backup and recovery process for Oracle databases for Disaster Recovery readiness.

Confidential, West Des Moines, IA

Sr.Oracle DBA/Database Analyst

Responsibilities:

• Configured and Administered Oracle 10gR2/11gR1 RAC databases on ASM.
• Installed and configured OEM Agent on AIX.
• Applied CRS, ASM and Database patches for Oracle 10g RAC.
• Experience maintaining databases under multiple Oracle versions in shared environment.
• Good knowledge in ASM disk group creation and maintenance.
• Implemented multiple standby databases using Dataguard to support BCP and Reporting needs.
• Database cloning/refresh from production to production reporting and SIT.
• Installed, configured and administered Shareplex replication.
• Re-sync Shareplex source and target from hot backup.
• Hands-on experience troubleshooting various Shareplex replication issues.
• Analyzing CPU, memory, and other host level metrics using NMON analyzer.
• Implemented and maintained full and cumulative RMAN backups on NAS storage.
• Database recovery using RMAN.
• Developed shell and Perl scripts to monitor sessions, locks, Dataguard, Shareplex, database availability, space reports, and so on.
• Monitoring and troubleshooting space related issues.
• Sound knowledge in SOX Compliance standards. Actively involved in quarterly compliance issues remediation.
• Extensively used STATSPACK, AWR & ADDM, and ASH for performance tuning.
• Provided 24x7 on-call support.
• On-line index rebuilds as per ASSM recommendations.

Environment: Oracle 10g/11g RAC, Shareplex 7.0.2.23, Dataguard, OEM, RMAN, AIX 5.x/6.x, Perl, TOAD

Confidential, Froster City, CA

Sr.Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution.
• Installed 9i, 10g and 11g databases on SOLARIS and AIX
• Database Upgrades from Oracle 9i to 10g and 11g.
• Installed and configured Oracle 10g/11g RAC.
• Developing and Implementing Disaster Recovery (DR) Plan.
• Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose
• Database cloning from Production to Test and Development environments
• Configured and maintained huge OLTP databases
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Analyze SQL statements, reorganize database objects and create indexes to improve response time of queries.
• Creation of database maintenance plans, rebuild indexes and integrity checks
• Implemented RMAN Backups, Creation of RMAN catalog database.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performed full and incremental backups using RMAN.
• Supported cross-platform migration from Sun Solaris to AIX.
• Implemented database auditing, data security and remediate high-risk violation in production environment.
• Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, Index management

Environment: Oracle 9i/10g/11g RAC, OEM, RMAN, AIX, Sun Solaris

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• Installation, configuration and administration of Oracle 9i/10g databases.
• Database upgrades/migration from Oracle 9i to Oracle 10g.
• Installation, Configuration and Administration of Oracle 10g RAC.
• Converted a single instance database to Oracle 10g RAC.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and Test the backup and recovery strategies.
• Pro*C, SQL, PL/SQL, Shell Scripting.
• Used DB Verify to deal with block corruptions and RMAN block recovery.
• Oracle Database and SQL tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Used SQL* Loader and External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Database backups using RMAN and VERITAS Netback up.
• Implemented dataguard (Standby) for high availability/disaster recovery purpose.
• Installed 10g Grid Agents on target servers
• Database monitoring using OEM Grid Control.
• Cloned/Refreshed environments to create patch test, development and QA environments.
• Involved in creating scripts to monitor and manage databases.
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades.

Environment: HP-UX, Solaris, Oracle10g RAC/9i, OEM grid Control.

Confidential, Overland Park, KS

Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of multi-terabyte database issues.
• Oracle 10g/9i installation and Configuration
• Daily Health Check Up of the Database
• Led creation of the Oracle 10g physical standby database. Automated Standby database conversion to read only mode for reporting purpose during business hours and back to recovery mode at night to resume recovery.
• Setup and configure Standby databases for high availability.
• Designed, documented, implemented and maintained all Disaster Recovery procedures
• Data loads using SQL*Loader.
• Upgraded Oracle 9i databases to Oracle 10g.
• Installing Oracle Patches.
• Involved in migrating production database to a new server.
• Designing the security and database access strategies.
• Oracle Database cloning/refresh.
• Logical and Physical data modeling.
• Backup and Recovery using RMAN.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN incremental backups.
• Helped performance teams by providing TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM reports for database tuning.
• Implemented Partitioning for large tables.
• Diagnose and troubleshoot Database issues.
• Monitoring database growth and managing space.

Environment: Oracle 10g/9i, OEM, RMAN, SQL*Plus, HP-UX, AIX

Confidential

Oracle DBA

Responsibilities:

• Database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Performed day-to-day DBA activities for managing Test/Stage/Development databases
• Configured and maintained 9i databases.
• Experience with Space Management.
• Detect corrupted blocks by using DBVERIFY utility.
• SQL tuning using SQL Trace and TKPROF, Explain Plan and SQL Analyze.
• Provided support to Database Architects in designing the database.
• Implemented Backup & Recovery strategies.
• Proactive database monitoring using automated scripts.
• Build development environments using database cloning and refresh procedures.
• Knowledge in Performance Tuning
• Used SQL TRACE, TKPROF, EXPLAIN PLAN, AUTOTRACE, STATSPACK for performance issues resolution.
• Extraction of data from flat files into Oracle Database using SQL*Loader.
• Import and Export of database objects to copy from one database to another database
• Created Database links.
• Good understanding of SQL, PL/SQL, Shell Scripting.

Environment: Oracle 10g/9i, OEM, TOAD, Solaris, AIX, Windows NT 4.0, RMAN.

Confidential

Oracle DBA

Responsibilities:

• Involved in configuration and implementation of Oracle 8i/9i databases.
• Maintained UNIX file systems for Oracle 8i and 9i databases
• Involved in upgrade of Oracle databases from 8.1.7 to 9.2.0.3
• Monitoring Growth of tables and undertaking necessary re-organization of database objects as and when required.
• Monitoring Scheduled jobs and performance of all the databases.
• Created PL/SQL procedures to automate maintenance tasks.
• Knowledge of using EXP and IMP utilities.
• Data loads using SQL loader.
• Maintain database security.
• Assist development teams in resolving performance issues.
• Assisting Sr. DBA’s in various day to day activities.

Environment: Oracle 8i/9i, RMAN, Windows NT, RHEL