Professional Summary

• Over 6+ years of experienceas anOracle Database Administrator having hands on experience in database administration, production support, patches, performance tuning, backup and recovery, capacity planning, space management,troubleshooting, database design, Unix shell scripting and documentation.
• Experience in installation and upgrading of different Oracle versions ranging from8ito 11g runningon UNIX (HP-UX, Sun Solaris, IBM AIX), Linux (RedHat, Oracle Enterprise Linux), Windows.
• Experience in Database Cloning from production to test and development databases
• Experience in Upgrading Databases from 8i to 9i, 9i to 10g, 10g to 11g.
• Experience in applying patches including CPU patches.
• Migrated databases from Sun Solaris to HP-UX and Windows to Linux
• Hands on Experience in managing largeMulti-terabyte Oracle databases.
• Experience with Oracle 10gRAC, 11g RAC installation and configuration
• Extensive experience in setup, configuration and administration of Standby Databases including Active Data Guard for Disaster Recovery, Reporting purpose and High Availability.
• Good experience in using Data Pump, Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR)and Active Session History (ASH)for monitoring database performance.
• Hands on experience in Data Modeling, Database Security and Auditing.
• Excellent experience inbackup and recovery techniques (Hot/Cold and RMAN incremental backups).
• Experience in Performance tuning, Application Tuning and Query optimization using Oracle supported tools such as SQLTRACE, TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM.
• Proficiency with Tuning the SGA, Buffer Cache, Redo Mechanisms, Monitoring and Detecting Locks.
• Experience in creation and monitoring of fast, complete materialized views and materialized view logs.
• Experience in Replication using Logical Standby, Streams and GoldenGate
• Installation, Configuration and administration of Golden Gate.
• Hands on experience with tools like SQL*Loader, RMAN, ASM, GoldenGate, Streams, Sql*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM), TOAD, and SQL Developer.
• Good experience in Database Design (Logical and Physical database design)
• Good experience in Capacity Planning and Bench Marking
• Good experience in SQL, PL/SQL development. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Experience in Partitioning.
• Experience in Data Warehousing using ETL Tools and Oracle.
• Experience in loading data using SQL*Loader and External Tables.
• Experience in writing shell scripts. Proficient in problem escalation with Oracle Support.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.

Technical Skills

Operating Systems

UNIX (HP-UX, Sun Solaris, IBM AIX), Linux (RedHat, Oracle Enterprise Linux), Windows

RDBMS

Oracle 8i/9i/10g/11g, Oracle 10g RAC/11g RAC

Languages

SQL, PL/SQL, Java, UNIX Shell Scripting, HTML

Tools

RMAN, ASM, OEM/GridControl, SQL*Loader, Oracle Export and Import, DataPump, SQL*plus, SQL Developer, TOAD, Erwin Data Modeler, Oracle Streams, GoldenGate

Tuning Tools

SQLTRACE,TKPROF, EXPLAIN PLAN, STATSPACK,ASH,AWR, ADDM

Education

• Bachelors of Technology, (Computer Science and Information Technology)

Professional Experience:

Confidential, San Antonio, TX Jun 2010 - Till Date
Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration Support
• Installation, Configuration and Administration of Oracle 10g RAC, Oracle 11g RAC, Standby Database (Active Data Guard) for High Availability and Disaster Recovery.
• Upgraded Databases from 9i to 10g, 10g to 11g and applied patches.
• Applied CPU patches.
• Migrated databases from Sun Solaris to IBM AIX and Windows to Linux
• Database Cloning from production to test and development databases
• Applied patches to databases in different environments.
• Design and implementation of backup and Recovery procedures.
• Performed Hot, Cold Backups. Performed Full, Incremental backups using RMAN.
• Performed Schema Refreshes using export/import and Oracle Data Pump.
• Performance monitoring and tuning using SQLTRACE, TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM.
• Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
• Automated the regular jobs using cron jobs.
• Extensively used Export/Import, DataPump utilities for selective backup, transferred tables between databases.
• Created Database links to connect different databases.
• Implemented Security administration by creating roles, views and granting the necessary object/system privileges to users.
• Database Design (Logical and Physical database design)
• Capacity Planning and Bench Marking
• SQL, PL/SQL development. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Written Shell Scripts for backups, cloning databases, monitoring
• Partitioned tables.
• Replication using Materialized Views, Oracle Streams and GoldenGate.
• Installation, Configuration and administration of Golden Gate.
• Loading and Transforming data using SQL*Loader and External Tables.

Environment: Oracle 11g RAC, 10g RAC/9i, Red Hat Enterprise Linux, IBM AIX, Sun Solaris, HP-UX, OEM (Grid Control), RMAN, ASM, DataGuard, GoldenGate, PL/SQL, DataPump, ERWIN, TOAD

Confidential, Plano, TX Feb 2009 - May 2010
Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration Support
• Installation, Configuration and Administration of Oracle 10g RAC, Standby Database (Data Guard) for High Availability and Disaster Recovery.
• Upgraded Databases from 9i to 10g and applied patches.
• Performed both proactive as well as reactive DBA tasks.
• Applied CPU patches.
• Migrated databases from Sun Solaris to HP-UX and Windows to Linux
• Database Cloning from production to test and development databases
• Performed Space Management of Tablespaces, Tables, Indexes and other Database objects by defining and monitoring storage requirements from time to time.
• Installed and setup ASM and created ASM instances. Administered ASM disks and disk groups.
• Designed and developed automated process for capturing Dashboard Metric related to Prod DB, ETL and reporting.
• Performed Hot, Cold Backups. Performed Full, Incremental backups using RMAN.
• Performed Schema Refreshes using export/import and Oracle Data Pump.
• Performance monitoring and tuning using SQLTRACE, TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM.
• Designed and implemented automated process for refreshing key tables in DEV/UAT environment using Oracle 10g data pump.
• Created and managed Users/ Privileges/ Roles.
• Performed SQL Tuning/Optimization which resulted in better performance of Nightly ETL jobs.
• Implemented and improved proactive Tablespace Monitoring using shell scripts and OEM which resulted in reducing the number of On-Call incidents.
• Performed Database Audit process to ensure users have required access/privileges.
• SQL, PL/SQL development. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Written Shell Scripts for backups, cloning databases, monitoring.
• Designed and developed the migration strategy.
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required.

Environment: Oracle 11g, 10g RAC/9i, Red Hat Enterprise Linux, Sun Solaris, HP-UX, OEM (Grid Control), RMAN, ASM, Oracle Streams, DataGuard, PL/SQL, DataPump, ERWIN

Confidential, Bellevue, WA Nov 2007 - Jan 2009
Oracle DBA

Responsibilities:

• 24x7 on-call production database support.
• Installation, Configuration, Upgrade, Patching of Oracle RDBMS and Applications.
• The work involves overall Oracle Database Maintenance, Performance Tuning, Backup, Recovery and other Database related activities.
• Installation of Oracle10g on Solaris.
• Used ERwin for data modeling.
• Database Design (Logical and Physical database design)
• Create table spaces, tables, and indexes for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• REFRESH/CLONING of Database and applications for development, testing.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning) using TKPROF,EXPLAIN PLAN, STATSPACK, AWR, ADDM for the better performance.
• Performed Hot, Cold Backups. Performed Full, Incremental backups using RMAN.
• Partitioning Strategies for very large tables.
• Performing SQL*Loader jobs for data loading.
• Capacity Planning and Bench Marking.
• Assist Programmers and Developers with Oracle problems.
• Automation of Startup Shutdown on all Production and Development Database.
• Daily Health Check of the Databases.
• Diagnose and troubleshoot Database problems and failures.
• SQL, PL/SQL development. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Written Shell Scripts for backups, cloning databases, monitoring.
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required.

Environment: Oracle 10g RAC/9i/8i, Sun Solaris, RedHat Linux, Windows, OEM (Grid Control), RMAN, ASM, Oracle Streams, DataGuard, PL/SQL, DataPump, ERWIN

Confidential, Hyderabad, India Jun 2006 - Oct 2007
Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle Databases.
• Responsible for administering and supporting production and development Oracle 10g, 9i, 8i Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Responsible for managinguser accounts, granting required privileges to users.
• Creating primary database storage structures (Tablespaces, Tables, Indexes wtc.)
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required.
• Applied patches, keeping applications software bug free.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning Tables by determining the suitable methodology to improve performance and manageability.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• SQL, PL/SQL development. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Monitoring the Database storage and day-to-day activities.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Environment: Oracle 10g RAC/9i/8i, HP-UX, Sun Solaris, Windows, RedHat Linux, OEM (Grid Control), RMAN, ASM, PL/SQL, DataPump