Professional Summary

• Over 8+ years of experience in Oracle databases (8i/9i/10g/11g) administration, backup and recovery, performance tuning, performance monitoring, schema maintenance on a various environment like Sun Solaris, Unix, HP-UX, AIX, LINUX and Windows 2000/NT.
• Expertise in Installation, maintenance, upgradation, administration, backup and recovery of Oracle RAC Databases.
• Experience in managing very large multi TB OLTP and Data warehouse databases
• Proficient in Installation and Configuration of 11gR2 cluster ready services and database in NFS and ASM file systems.
• Extensively worked on migrating databases from 8i to 9i, 9i to 10g and 10g to 11g.
• Knowledge of 11g new features such as Automatic Health Monitoring, security, SQL Performance Analyzer, Real Application Testing and Snapshot physical standby.
• Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.
• Experience on installation and configuration of Golden Gate.
• Experience in installing and managing Oracle Enterprise Manager Grid Control.
• Expertise in Performance Tuning by using tools/utilities like Automated Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, sql tuning Advisor, Autotrace, TKPROF and Statspack.
• Successfully configured and managed Physical Standby Database using Oracle DATAGUARD for High availability.
• Experience in basic and advance replication using Oracle Streams.
• Performed capacity planning to create and manage database environments.
• Excellent experience in cloning/refreshing oracle databases for development and testing.
• Expertise in data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Extensive experience on Partitioning tables and creation of the Indexes on large tables to improve the Performance.
• Proficient in SQL, PLSQL, Stored Procedures, Functions and Database Triggers to implement business logics of oracle database.
• Experience in automating day to day operations using Shell.
• Experienced in heavy data loading from flat files to oracle tables using SQL* loader.
• Experienced in regular Database Administration activities such as Upgrades, Patches, TAR Support, capacity planning and documentation.
• Experience in debugging deadlocks and other database inefficiencies using SQL Profiler.
• Expertise in maintaining Database Security and auditing.
• Experienced in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
• Project Documentation, creation and adhering to standards of Implementation and Project management
• Excellent interpersonal skills, team player, aggressive, hard working and result oriented.
• Supported the system 24x7, Ability to work beyond regular hours.

Technical Skills

DBMS & RDBMS : Oracle 8i, Oracle 9i, Oracle 10gR2, Oracle 11g R2 and SQL server.
High Availability, Tuning : Oracle 10gRAC with ASM, Streams, DataGuard, OEM 9i, 10g, 11g,
And Monitoring Product LogMiner, Tkprof, Statspack Reports, AWR, ADDM and ASSM
Operating Systems : Solaris (8/9/10), AIX (5.1, 5.2, 5.3), Linux RHEL (3x, 4x, 5x),
HP-UX (10.x, 11.x) and Windows98/NT/2000/XP
Tools & Utilities : Toad, RMAN, EXP/IMP, EXPDP/IMPDP and SQL Loader
Data Modeling Tools : Erwin and ODI
ETL & Reporting tools : INFORMATICA and COGNOS
Backup Tools : VERITAS, NetBackup and HP OmniBack
Programming Languages : SQL, PL/SQL, Unix Shell Scripting, c, c++, java, HTML and XML

Confidential, San Leandro CA Jul’ 2011 – Till Date
Role: Sr. ORACLE DBA

Responsibilities:

• Administering more than 50+ Production databases of size ranging from 100GB to 7 TB on RHEL and solaris.
• Provided 12x7 on call support for mission critical databases.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
• Installed fresh 11.2.0.1 and 11.2.0.2 RAC databases on ASM.
• Responsible for migrating 7TB 3 node RAC database from 10.2.0.4 to 11.2.0.2.
• Migrated 7TB 10.2.0.4 standalone database to 3 node RAC.
• Performed capacity planning to create and maintain the database environments.
• Installed and configured Active Data Guard 11g using physical standby for high availability databases.
• switchover and switchback of oracle primary and standby databases.
• Setting up RMAN and Data pump backups and Monitoring.
• Created Partition’s, estimated stats on one partition and copied the stats to remaining partitions using dbms_stats.
• Proficient in troubleshooting node reboots in Oracle RAC Environment
• Responsible for refreshing Non-prod environment from production using RMAN and Datapump utilities.
• Performed SQL query tuning and optimization.
• Performed database tuning and optimization using tools such as Explain plan, sql tuning advisor and SQLT.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache.
• Responsible for rebuilding and re organization of tables and Indexes for better performance.
• Installed and configured SharePlex for replication.
• Expertise in applying Patches for both Grid and Oracle Homes.
• Supporting and coordinating with Application and development team regarding deployments.
• Automated stats collection at table level based on their size’s of table’s in schema using scheduler window.

Confidential, Santa Clara, CA Feb’ 2010 - Jun’ 2011
Role: Sr. ORACLE DBA

Responsibilities:

• Involved in administering more than 450+ Production databases of size ranging from 200GB to 350 TB on RHEL.
• Provided 12x7 on call support for mission critical databases.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 16 nodes per cluster.
• Implemented Oracle 11g new features like Real Application Testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Involved in fresh installation of 11.2.0.1 and 11.2.0.2 RAC databases on ASM and NFS file systems.
• Migrated oracle RAC databases from 10.2.0.4 to 11.2.0.2.
• Responsible for Migrating a 4TB 3 node RAC database from 10.2.0.4 to 11.2.0.2 on NFS storage
• Performed capacity planning to create and maintain the database environments.
• Installed and configured Data Guard 10g, 11g using physical and logical standby for high availability databases.
• Migrated oracle 9.2.0.8 databases to 10.2.0.4 from windows to Linux
• Migrated 4TB 10.2.0.4 standalone database to 2 node RAC
• Responsible for adding a node to a 4 node Cluster.
• As part of BCP certification did switchover and switchback
• Installed 11g (11.1.0.1) Grid control on RHEL 5U3
• Installed agents on database servers and configured enterprise manager.
• Configured UDM’s for monitoring the databases.
• Involved in administering Oracle Streams bi-directional replication at table level.
• Configured Oracle Streams bi-directional replication at schema level between databases located in different colo’s.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 30+ production databases.
• Migrated database from ASM to Non-ASM using RMAN.
• Recovered datafiles from block corruption using RMAN.
• Created Partition’s, estimated stats on one partition and copied the stats to remaining partitions using dbms_stats.
• Proficient in troubleshooting node reboots in Oracle RAC Environment
• Presented White paper on upgrading 10.2.0.4 RAC databases to 11.2.0.1 to Yahoo DBA team
• Responsible for refreshing Non-prod environment from production and later automated the process through a script.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache.
• Responsible for rebuilding and re organization of tables and Indexes for better performance.
• Installed and configured of Golden Gate.

Environment : Oracle 10g RAC, 11g RAC, 9i, SQL server 2005,2008, SUN SOLARIS 9,10 and RHEL 5.x, HP-UX 11

Confidential, Columbus, OH Apr’ 2008- Jan’ 2010
Role: Sr. ORACLE DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Senior DBA, Primary point of contact for client for database and configuration management related issues.
• Installed and Configured Oracle 10gR2 two node RAC.
• Installed, configured and administered Automatic Storage Management (ASM).
• Database cloning from Production to Test and Development environments.
• Administered and managed Production, Test, and Stage and Development databases involving more than 100 applications.
• Installed and configured Goldengate.
• Dealt with Web based OLTP systems.
• Review database environments, such as database settings, monitoring oracle user processes.
• Installed and configured Data Guard 10g using physical and logical standby for high availability databases.
• Adding and deleting nodes using Oracle Universal Installer (OUI).
• Created Physical standby database from hot backup of primary database and wrote shell scripts for backup and cloning.
• Worked with a team for replicating databases using Quest Shareplex.
• Used Oracle Streams for data replication between oracle databases.
• Responsible for Migrating Oracle database from 9.2.0.7 to 10.2.0.4
• Daily database administration tasks including backup and recovery.
• Tuned memory structures such as the database buffer cache, shared pool and library cache.
• Developed Backup & Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.
• Performance Tuning by using Oracle utilities like AWR, ADDM, Explain Plan, StatsPack, Tkprof, for addressing performance bottlenecks and issues.
• Provided all kinds of Production DBA support as well as development team support to various tasks.

Environment : Oracle 11g, Oracle 10g RAC, Oracle 9i, RHEL 4.x, IBM AIX 5.3, HP-UX 11

Confidential, NJ Aug’ 2006- Mar’ 2008
Role: ORACLE DBA

Responsibilities:

• Provided 24x7 database supports for all systems.
• Installed and Configured Oracle 9i/10g RAC.
• Installed, configured and administered Automatic Storage Management (ASM).
• Applied patches to the existing versions of Oracle.
• Developed Environments setup using database cloning and refresh procedures.
• Provided Oracle DBA support included Oracle database installation, upgrades, instance configuration, tuning, schema maintenance, troubleshooting and production monitoring.
• Coordinated and Assisted in Database upgradation from 9i to 10g Release 2.
• Developed backup recovery procedure/scripts for the Database through Log Archiving.
• Performed day-to-day DBA tasks or managing Prod/Dev databases like Export/ Import, moving tablespaces, rebuilding indexes, synonyms, partitioning tables, etc.
• Identified poorly performing queries using ExplainPlan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace and SQL Tuning Advisor.
• Managed the Schemas by creating various objects like tables, views, indexes and maintaining data integrity using constraints.

Environment : Oracle 10g RAC, Oracle 9i, Oracle 8i, LINUX, SUN SOLARIS 9, IBM AIX 5.2

Confidential, Los Angeles, CA Jun’ 2005- Jul’ 2006
Role: ORACLE DBA

Responsibilities:

• 24x7 production database and applications support.
• Upgraded multi terabyte databases from 9i to 10gConfigured disaster recovery site with physical standby database for high availability.
• Perform capacity planning required to create and maintain database environments.
• Created RMAN database backup and used OEM to manage the data, accounts and tuning. Used data pump technology to take the backups.
• Configured Enterprise manager for centralized database monitoring and maintenance.
• Cloning of databases from production to Dev & QA Databases using RMAN utility.
• Partitioning of the large tables to reduce the access time and easier management.
• Created and maintained databases: Creating table spaces, tables, indexes, views and materialized views.
• Monitored table space size, resizing table space, relocating data files for better disk I/O.
• Created users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.
• Performed data loads using SQL*Loader.
• Used ERWIN for Logical Data modeling and creating physical database designs.
• Replicated materialized views with fast refreshes for table replication.
• Used STATSPACK, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Installation of SQL Server 2005.
• Troubleshooting oracle errors fine-tune database parameters and analyze STATPACK reports.

Environment: Oracle 10g, 9i, 8i, IBM AIX, and HP-UX

Confidential, Hyderabad, India Jul’ 2003- May’ 2005
Role: Jr. ORACLE DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 8i/9i databases, MS SQL server.
• Analyzed STATSPACK reports for optimization of DB performance periodically.
• Created different types of Indexes (B tree, reverse key, IOT and function based etc).
• Involved in backup/recover strategy designing and implementation
• Performed hot and cold backups Performed in HOT and COLD backups of the databases and also the individual table spaces.
• Configuring the database parameters, creation, reorganization, extending tablespaces, administer database security, create users, grant/revoke roles, privileges, extended database storage capacity, performance and monitor, reduce database fragmentation, manage data-files, rollback segments, extents and rebuilding indexes.
• Applying patches.
• Performed heavy data loads using SQL *Loader, Export, Import.
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Supported developers during batch jobs to increase rollback segments and archive log space for additional month end updates to the system.
• Database analysis and design activities as a team with the Data Analysts.
• Modified and defined database objects as per requirements.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Environment : Oracle 9i, 8i, 7.x, SunSolaris, HP-UX, Windows

References available upon request
Willing to relocate