SUMMARY

• Over 9 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
• Have solid MySQL DBA experience in 24X7 environments including MySQL database architecture and tools.
• Have experience with building, installation, upgrade, and patching of MySQL.
• 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 & 11g.
• 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, ORADEBUGcustom 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 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3 RedHat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP.

RDBMS: Oracle 11gR2/11gR1, Oracle 10g, Oracle 9i, Oracle8i, Oracle GoldenGate 11.2.1, Oracle 11g (RAC), Oracle 10g (RAC)

Languages: SQL, PL/SQL,Java, C, PERL, UNIX Shell

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, ERWIN, TOAD, Oracle Streams, Golden Gate.

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

Database Modeling: Erwin 4.0, Rational rose

ETL Tools: Informatica 5.1 PowerCenter 7.1/6.1 /5.1, Power Mart 6.1 /5.1

Reporting Tools: Business Objects XI/6.x/5.x, Crystal Reports 10.X/XI

Other: EMC, NetApp, VeritasNetBackup, TSM, HP OmniBack

Web Tools: HTML, XML

ERP Applications: Oracle Applications 11i

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Responsibilities:

• Involved in 24x7 support for Production database and applications with on-call pager.
• Installation and creation of 11g RAC, 10g RAC and 9i databases for Testing, Development and Production.
• Supported upgrades from oracle 9i to 10g, 9i/10g to 11g.
• Performed migration from 10g to 11g.
• Perform DDL maintenance on MySQL 5.1 and 5.6 databases including monitoring and administration of data rollup jobs, reporting configuration, partitioning Develop and implement ETL jobs to populate relational and dimensional structures in MySQL
• Supported development, implementation and maintenance of sql server database.
• Supported migration, and performance tuning on sql server database.
• Installed and configured oracle 10g/11g RAC for high availability.
• Creating and Managing Table spaces with different block sizes to prevent row chaining.
• Data Refresh from Production to Test and Development environments using manual method and RMAN Duplication.
• Participated in designing and building OEM environments.
• Proficient in using OEM and grid control.
• Resolving Performance issues.
• Installed and Configured GOLDEN GATEExtracts/replicat for multiple databases.
• Configured and built heartbeat monitoring in Golden Gate.
• Configured error handling for restart, logging, production support and status reporting in GoldenGate.
• Trouble shooting and performance tuning golden gate replications.
• Implemented necessary monitoring scripts for Golden gate in unix/perl scripting.
• Cloned environments to create patch test, development and QA environments.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK.
• Setup of Standby Database(Data Guard). Performing Failover and Switchovers.
• Load balancing, Database/Schema/Table Re-Organization for faster performance using export/import&move procedures.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions.
• Performance tuning with OEM, AWR, ASH.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS NETBACKUP
• Scheduled jobs using Oracle Job Scheduler.
• Partitioning large objects for better performance.
• Scripts for Cold Backup, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Installation and configuration of Oracle Client software and Tools.
• Created Scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and the PGA.
• SQL scripts to monitor Table spaces and Extent growth.
• Writing UNIX shell scripts for backup and recovery, import and export procedures.
• Experience in using UNIX utility commands such as grep, awk and sed.
• Monitoring and Optimizing Database Performance.

Environment: Oracle 11g R2/11g R1/ 12c,Oracle Goldengate 11.2.1, RAC/11g RAC/10g, ASM, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof, SQL*LOADER.

Confidential, Omaha, NE.

Oracle DBA

Responsibilities:

• 24x7 on-call production database support. Primarily responsible for supporting mission critical databases to resolve the database issues on the time and make sure database up and running
• Configured OEM 12c monitoring tool for more than 500 databases. For proactively monitoring the issues on the databases issues like performance of databases, tablespaces, database growth etc.
• Applying the latest patches like quarterly and one half patches for Oracle Database to fix bugs which occurred in previous version and applying it using Opatch utility.
• Working on data storage management, network cost estimation, user roles and privileges, user space management, memory usage estimation for the existing and future expansion requirements.
• Creating Cronjobs and Autosys jobs for RMAN and EXPORT/IMPORT backups.
• Building RAC databases on Linux/IBM AIX/Sun Solaris with 4 to 6 node on 10g/11gR1/11gR2.
• Troubleshooting RAC issues like node eviction, network issues and addition of nodes dynamically.
• Responsible for Oracle 9i/10g/11g logical and physical standby database design, implementation and maintenance for production as well as testing databases for Disaster Recovery and switch over.
• Worked on Golden Gate Replication configuration like unidirectional as well as bidirectional as per the requirement and addition of tables for the existing Golden Gate configuration.
• Created users account for the Golden Gate and granting privileges.
• Good working knowledge on Oracle Streams to capture source message, move to stage, propagate, consume, detect and resolve conflicts during the transmission to reach the destination.
• Performed extensive tuning / troubleshooting of databases for optimal performance. Tuning the application SQL / lock contention / index usage etc., Monitor object growth and modify segment storage for better performance. Developed strategies for optimal backup and restores procedures.
• Database refreshes using database links from Production to QA, testing and development.
• Involved in Database Performance tuning and analyzing Stats pack/AWR reports on regular basis to resolve CPU utilization and Disk I/O Read and Writes to increase database performance.
• Partitioned large tables, created global portioned indexes for manageability and performance improvement. Managed and resolved design issues. Dropping and rebuilding indexes.
• Created primary database storage structures (tablespaces), users, roles, altering, and modifying the database structure according to the business requirement as necessary.
• Responsible for automation of startup, shutdown of database without the involvement of DBA to start the database manually. Effective knowledge of working with System Administrator’s
• Developing SQL, PL/SQL stored procedures, packages, functions, triggers and views.
• Created and managed users, profiles, implementing security, granting roles and privileges etc.
• Upgraded production databases from 10g to 11g without downtime using Golden Gate replication.
• Planning and implementing Backup and Recovery procedures (Conventional Cold &Hot Backups, and RMAN Backups), scheduling daily backups and performed periodic recovery tests.
• Developed Unix Shell scripts to automate database cloning, backups and database monitoring.
• Working knowledge on HPQC to create the SQL performance related queries to developers and ability to deploy the defected SQL on database by issuing appropriate severity tickets.
• Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

Environment: Oracle 11g R2/11gR1/10gR2 RAC on Sun Solaris/ AIX, Golden Gate, Oracle Streams, Data Guard, Import Export utilities, PL/SQL, TOAD, OLTP, LDAP, RMAN, Remedy, Shell Script.

Confidential, Chicago, IL.

Oracle DBA

Responsibilities:

• Involved in 24x7 support for both Production and Development databases.
• Installation, creation of 10g RAC and 9i databases for Testing, Development and Production.
• Performed Cloning/Refresh to setup Test and Development databases.
• Installation and Maintenance of Standby database.
• Upgradation/Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches when required.
• Responsible for optimizing the queries and application tuning.
• Partitioned large tables to increase the performance.
• Implementing Range, List, Hash Partitions.
• Creating and refreshing Materialized views.
• Performed SQL Tuning and assisted developers with coding PL/SQL.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Performed the daily Maintenance Tasks and Health Check of the Database.
• Performance Monitoring using OEM 10g Grid Control.
• Created scripts for hot backup on a daily basis scheduled with cron jobs and Autosys conducting sizing & capacity planning for Oracle databases Implement “stored procedures and triggers” based on business plans using PL/SQL.
• Implemented Backup & Recovery procedures using RMAN, Hot/Cold Backups.
• Performed Switchovers and Failover drills.
• Continuous monitoring of the Database and troubleshooting the issues, if any.
• Responsible for setting and managinguser accounts, granting required privileges to users.
• Tuning SQL queries using TKPROF, EXPLAIN PLAN,SQL TRACE.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK, AWR, ADDM.
• Tuning heavy data loads.
• Applied Security Patches from Metalink when needed.

Environment: Oracle 11gR1/10g RAC/9i, Red Hat Enterprise Linux 4.x, IBM AIX, DATAGUARD, ASM, Replication, Explain plan, TKprof, PL/SQL

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• Provided 24X7 support for all the production and development databases.
• Installed and configured Oracle 10g.
• Performed upgrades from Oracle 9i to 10g.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backupand recoveries.
• Applied Oracle Applications and database patches.
• Cloned/Refreshed Oracle Databases and Oracle Applications.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Performance Tuning using TRACE FILE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, DataWarehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, OracleStandby Servers.

Environment: Oracle 10g/9i, SQL, PL/SQL, AIX 5.2, Shell scripting

Confidential, NY

Oracle DBA

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.

Environment: Oracle10g RAC, 9i, 8.x, AIX 5.X, HP11.X, LINUX (Redhat Release5), OEM, STATSPACK and RMAN

Confidential

Oracle DBA

Responsibilities:

• Supporting production database system 24*7.
• Senior DBA, Primary point of contact for client for production database support.
• Installation and Configuration of Oracle 10g RAC.
• Migrating Oracle databases from windows to Linux.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented Hot, Cold and Logical backup plans.
• Database patching using opatch.pl Perl script.
• Proactive database monitoring using 10g grid control.
• SQL tuning using Statspack, AWR, Explain plan, Tkprof.
• Installation, Configuration and Maintenance of Logical and Physical Standby databases.
• Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups for OLTP, Data warehouse, and Business object repositories. Fix backup failures, address and implement resolutions.
• Conducting sizing& capacity planning for Oracle databases.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth.
• Upgraded Oracle 8i, 9i databases to Oracle 10g.
• Applied patches to Oracle Databases.
• Monitoring Growth of tables and undertaking necessary re-organization of database objects as and when required.
• Responsible for optimizing the queries and application tuning.
• Oracle Database monitoring, troubleshooting and resolved the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environment: Oracle 10g/9i RAC,IBM AIX, Sun Solaris, Red Hat Linux, Windows 2003, Streams, SQL*Plus, Grid Control, TOAD

Confidential

Oracle DBA

Responsibilities:

• Provided support for all the databases as an operational database administrator.
• Installed and configured Oracle 8i databases.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Analyze, design and implementation of the Database for e-commerce system.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Proactive database monitoring using automated scripts based on v$views.
• Frequent Database audits to ensure the SOX standards were not violated.
• Developer Environments setup using database cloning and refresh procedures.

Environment: Oracle 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting.