SUMMARY

• Over 8 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation
• Experience in OLTP/DW database systems, managing large Oracle databases VLDB.
• Worked as a team member to provide 24x7on - call production database support.
• Oracle Database Administration experience in variety of different environments like AIX, HP-UX, SUN SOLARIS, RedHat Linux and Windows.
• Worked with Oracle Databases (11g/10g/9i/8i) on Unix/Linux/Windows platforms.
• Planned and implemented DR & high availability solutions using Oracle 11g RAC & 10g RAC, Standby Database (Oracle Data Guard).
• Configured Logical and Physical Database design in 10g & 11Gg.
• Worked on database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Good experience in Oracle Streams, Golden Gate.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN and manual methods.
• Experience in trouble shooting RMAN issues in performing the Backup and Recovery process.
• Experienced in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Performing daily activities and troubleshooting the database issues using OEM Grid control.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG custom scripts troubleshooting oracle databases using sqltrace utilities.
• Experience in Upgrading databases, applying patches.
• Good experience on Oracle Support processes for technical requests through Metalink and other Support Procedures
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Proven ability to adapt to demanding schedules and changing priorities and ability to function successfully in a highly stressful and critical environment.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 6.1, 5.1, 5.2, 5.3, Red Hat Linux RHEL 4.x, 5.x and Windows 95/98/ME/NT/2000/XP. SQL Server

RDBMS: Oracle 11g RAC, 10g RAC, 9i,8i

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

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD, Erwin Data Model

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDM,OEM Grid Monitoring

Database Modeling: Erwin 4.0, Rational rose

Other: Oracle Streams, Logical and Physical Database Design, Golden Gate, EMC, NetApp, Veritas NetBackup, TSM, HP OmniBack, Data ware House, ETL.

PROFESSIONAL EXPERIENCE

Confidential, Mountain view, CA

Sr. Oracle DBA

ENVIRONMENT: Oracle 11g RAC, 10g RAC, AIX 6.1, 5.1, RedHat Linux 4.x/5.x, Solaris 10, SQL, PL/SQL, RMAN, SQL*Loader, Data pump, HP-UX 11.x and Windows

RESPONSIBILITIES:

• Involved in 24x7 Production support managing large Oracle databases of different environments like RedHat Linux, Sun Solaris and windows.
• Experience in 11gR2 Real Application Clusters (RAC) Installation, Configuration, and Administration with Oracle file system.
• Involved in RAC administration including cloning, tuning, patching and monitoring etc.
• Installation & Configuration of Standby Database for faster Disaster Recovery.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Restoration and recovery from backup.
• Experience in database recovery using RMAN with external tape backup system. Also Created Recovery Catalog to store multiple database backups.
• Performing Database auditing on the Production boxes on a monthly basis.
• Configuration, Modeling, Administration and tuning of Golden Gate.
• Monitor Golden Gate processes and GG cleanup scripts function properly.
• Extensively using OEM Grid control for trouble shooting and daily database activities.
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Experienced in using Data pump, Flash-Back Recovery, AWR, ADDM, and Grid Monitoring
• Implemented Interval Partitioning for huge tables and Hash Partitioning on indexes with Purging strategy.
• Experience on Data Modeling tools such as Erwin Data Model and ER Studio.
• Upgrading and Migration of Database from Oracle 9i, 10g to 11g and applying patches whenever required.
• Experienced with Dataguard (Physical & logical Standby) Implementation in DataWare House Environment.
• Created different types of Synonyms to manage public users.
• Setting up different storage parameters and sequence Cache values for objects to improve the performance.
• Planned, redesigned and reorganized the Oracle database and proven expertise in Golden gate and oracle streams.
• Applied patches, keeping applications software bug free, and improving data integrity.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database SGA and Huge pages.
• Participating in design database model and management policies for current and future enhancements.
• Continuous Performance monitoring and tuning of the databases and application.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, locks, and Contention.
• Created Materialized views to improve the query response time.
• Refresh/Cloning of databases from production to development/QA environments.
• Analyze SQL statements, reorganize database objects, design indexes and optimizer parameters to improve response of queries.
• Creation of database links from different oracle and SQL server databases for data loading.
• Created Recovery Catalog to store multiple database backups.
• Implemented different Partition methodologies to improve performance and manageability.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Develop and maintain build standards and procedures for the database environment.
• Providing database device configuration data (hardware and software) for systems administration, such as disk usage, memory, etc.
• Working with QA and Development teams for the regular database support.
• Involved in creating Tables, Indexes, Triggers, Sequences, Procedures and Packages.
• Responsible for setting and managing user accounts, Granting required privileges to users, Auditing Users.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service when required.

Confidential, Cincinnati, OH

Sr. Oracle DBA

ENVIRONMENT: Oracle 11g RAC, 10g RAC, AIX 6.1, 5.1, RedHat Linux 4.x/5.x, Solaris 10, Oracle Data Integrator, SQL, PL/SQL, RMAN, SQL*Loader, Data pump, HP-UX 11.x and Windows

RESPONSIBILITIES:

• Support managing large Oracle databases of different environments like RedHat Linux, AIX.
• Patching and upgrading the databases.
• Installed and configured Oracle Enterprise Manager (OEM) with Grid Control to manage databases.
• Involved in the implementation of High Availability solutions Oracle 11g RAC with ASM.
• Added a new node to the existing cluster.
• Responsibilities included, data modeling, data administration, database design, performance & tuning, and system security
• Performed database tuning using Oracle Enterprise Manager, Explain Plan and tkprof.
• Responsibilities include Create and maintain Oracle DataGuard configuration
• Involved in data modeling configuration.
• Support and advise the development teams on database related issues.
• Experience with RMAN backup and recovery setup, tuning, and execution.
• Created scripts to monitor and manage the databases.
• Recreated backup plans and scripts.
• Experience with integration of systems within a web environment.
• Involved in deployment of 10g Grid control Agents
• Proven ability in sql server 2005, SQL server enterprise edition 2008.
• Assisted developers in tuning SQL statements in the applications.
• Space Management which includes table space creation, adding new data files.
• Experience in replication tools like Golden gate and oracle streams.
• .Experience in critical patch update (CPU), and individual patchsets software upgrade for Oracle database server and Application server.
• Designed and implemented Backup and Recovery strategies.
• Performed weekly full and daily incremental backups to tapes using RMAN scripts to schedule automatically RMAN backup.
• Importing data from flat files into database using SQL loader and External Tables.
• Document of all the work.
• Responsible for optimizing data access and performance by tuning indexes.
• Performed Replication of the Production database for setting up instances for the QA and Testing teams.
• Hands on experience in writing UNIX Shell Scripts.
• Scheduling jobs through job scheduler and Oracle scheduler.

Confidential, Rochester, MN

Sr. Oracle DBA

ENVIRONMENT: Oracle 11g RAC, 10g RAC, 9i, Redhat Linux 4.x, Solaris 10, IBM AIX, STREAMS, HP-UX11,TOAD, RMAN, OEM, SQL Server

RESPONSIBILITIES:

• Involved in 24x7 support for Production RAC database with on-call pager.
• Accountable for the design, configuration and installation of all major production, development and test Oracle database environments on RedHat Linux, AIX platforms.
• Major activities include logical and physical database design, capacity planning, performance tuning, database security, disaster recovery, installation and ongoing maintenance.
• Configured Disaster Recover and Logical standby for Production database in 10G.
• Configured Active Dataguard for Production database in 11G.
• Well experience in monitoring and maintaining the Logical standby databases.
• Setup backup and recovery procedures using RMAN.
• Extensive experience in Installation, Configuration of 10G and 11G OEM Grid control.
• Tune databases performance, Schedule backup, jobs using OEM Grid Control.
• Experience in using OEM Grid Control in Recovery database, Check availability of the database, storage size.
• Creating and refreshing Materialized Views depending upon needs.
• Created and Managed Oracle Database Links between Servers
• Upgrade of Database from 9.2.0.6 to 10.2.0.2, 9i/10g databases to 11g and applying patches whenever required.
• Involved optimizing database schemas, SQL queries, database procedures, and installation.
• Cloned/Refreshed Oracle Databases for development and testing.
• Partitioned large tables to increase the performance.
• Configured Oracle Streams Replication.
• Installed and Configured Oracle Data guard for Oracle 10g & 9i for the maintenance of Stand by database.
• Experience in Logical and Physical database Design.
• Erwin, ER/Studio, Data Warehousing, Extract Transform and Load (ETL), Oracle Warehouse Builder, SQL, PL/SQL.
• Worked on development tool TOAD.
• Responsible for setting and managing user accounts, Granting required privileges to users, Auditing Users.
• Created roles and assigning to users based on their group requirements. Enabling Trace to analyze Performance Issues on Particular users.
• Written shell scripts for digitization the process and for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.

Confidential, EL Paso, TX

Oracle DBA

ENVIRONMENT: Oracle 10g RAC, 9i, 8.x, AIX 5.X, HP11.X, LINUX (Redhat Release5), OEM, STATSPACK and RMAN

RESPONSIBILITIES:

• 24x7 Oracle Production Database Administration
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
• The work involves overall maintenance of Oracle database, performance, tuning, backup, recoveries and other database related activities.
• Day to day performance monitoring and tuning of database.
• Cloned/Refreshed Oracle Databases and Oracle applications for development and testing.
• Configured and Administrated Physical Standby Dataguard for high availability.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in the Design (Logical & Physical) of Databases.
• Preparing Backup and Recovery plan.
• Data transferring with export/import utilities.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Management of table space growth, monitoring data files additions, extent growth
• Monitoring of database for growth and performance.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Performance monitoring and tuning using SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, ADDM
• Space management, Monitoring of database objects like rollback segments, temp segments and table spaces.
• Installed and Configured Oracle Data guard for Oracle 10g & 9i for the maintenance of Stand by database.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Creating Databases and all database objects. Database Designing (Designing Table spaces and Rollback Segments).
• Erwin, Data Modeling, ETL from spread sheets, paper files, fax documents, and MS access to Oracle, SQL, PL/SQL, Database Links, Data Warehousing, Audit Trails.

Confidential

Oracle DBA

ENVIRONMENT: Sun Solaris, HP-UX, Oracle 9i, 10g, PL/SQL, RMAN, RHEL

RESPONSIBILITIES:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Perform capacity planning required to create and maintain database environments.
• Used STATSPACK, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Configured and maintained Dataguard for development and test database for switchover and failover purpose.
• Performed data loads using SQL*Loader.
• Cloning of databases from production to Development and Test Databases using RMAN utility.
• Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability.
• Oracle Database monitoring, troubleshooting and resolved the issues.
• Management of schemas, objects partitioning the tables & indexes.
• Created and maintained databases, Creating table spaces, tables, indexes.
• Developed Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Created users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Provided all kinds of DBA support to development teams as well as production support to various tasks.
• Created shell scripts to automate batch jobs through crontab.
• Written backup recovery scripts for the Database through Log Archiving.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation.
• Applied High priority, security patches downloaded from Metalink.
• Monitoring the Database storage and Day to Day activities.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.