SUMMARY:

• Over 7 years of hands on experience on Oracle Database Administration.
• Excellent experience in production support, installation, configuration, upgrades, migrations, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing.
• Expertise includes Oracle Databases (11g RAC/10g RAC/9i/8i), on UNIX (HP-UX, Sun Solaris, IBM AIX)/LINUX and Windows environments.
• Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g.
• Experienced in maintaining large Production, TEST and DEV environments.
• Expertise in installing, configuring and maintaining Oracle databases on various platforms.
• Planned and Implemented DR & High Availability solutions using Oracle 10g RAC, 11g RAC, Standby Databases including Active Data Guard.
• Experience in Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues.
• Excellent experience in backup and recovery. Cold backups, hot backups, Logical backups, RMAN backups (Full, Incremental Backups, Differential, Cumulative Backups).
• Implemented data transfer using Export/Import utilities and Data Pump.
• Automated database periodic maintenance and activities using Korn, Perl Shell Scripts.
• Extensive Experience writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Excellent experience in patching, upgrades and migrations.
• Configured Oracle on different Operating Systems for OLTP and Data Warehousing environments.
• Replication using Materialized Views, Oracle Streams and Golden Gate.
• Experience in Capacity Planning and benchmarking.
• Experience in Partitioning
• Experience in migrating databases from Windows to Linux, Sun Solaris to IBM AIX.
• Experience in Logical Database Design, Physical Database design
• Excellent communication skills, with strong troubleshooting, and problem solving ability.

Technical Skills:

RDBMS
Oracle 11g RAC, oracle 10g RAC, Oracle 9i, Oracle 8i, SQL Server, MySQL.
Operating Systems
Red Hat Linux 4.x,/5.x/6.x, Sun Solaris 8/9/10, IBM AIX 5.1/5.2/5.3/6.1/7.1, HP-UX10.x/11.x, Windows NT/95/98/2000/XP/2003
Languages
SQL, PL/SQL, Java, C, UNIX shell
Tools
RMAN, SQL*Loader, Data Pump, Exp/Imp, TOAD, ERWIN

EMC, NetAPP, VERITAS Net Backup, IBM TSM
Web Technologies
HTML,XML

EDUCATION:

• Bachelor of Technology

Professional Experience:

Confidential, Jersey City, NJ June 2011- Present
Oracle DBA

Responsibilities:

• 24*7 Production Database Administration Support
• Installation, configuration and support of Oracle RAC and Standby Databases (Active DataGuard) for High Availability and Disaster Recovery.
• Cloned/Refreshed Oracle Databases for development and testing
• Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g.
• Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• Involved in construction of DR sites for all the Production environments.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (tablespaces , datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.
• Provided instance level performance monitoring and tuning, Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Backup and recovery. Cold backups, hot backups, Logical backups, RMAN backups (Full, Incremental Backups, Differential, Cumulative Backups).
• Implemented Standby Databases with high availability and performance configurations and participated in Switchover and Fail over tests
• Monitoring Day-Day Backups, Log’s.
• Successfully implemented Backup & Recovery solutions using RMAN (Full, Incremental Backups, Differential, and Cumulative Backups).
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Database cloning for development, testing from production
• Responsible for capacity planning, database security, recovery planning and installing patches
• Writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Shell Scripting.
• Installed and configured Golden Gate
• Replication using Materialized Views, Oracle Streams and Golden Gate.
• Partitioned large tables for better performance and manageability
• Migrating databases from Windows to Linux, Sun Solaris to IBM AIX.
• Experience in Logical Database Design, Physical Database design

Environment: Oracle 11g RAC/10g RAC/Oracle 9i, Data Guard, Sun Solaris, IBM AIX, HP-UX, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, Golden Gate, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, AWR, ADDM

Confidential, Palo Alto, CA January 2010 - May 2011
Oracle DBA

Responsibilities:

• 24*7 Production Database Administration Support
• Oracle RAC installation, configuration and support for High Availability
• Involved in developing a Disaster Recovery (DR) plan. Configuration and maintaining Standby Databases (Data Guard) for the production database and tested for Switchover, Fail over.
• Cloned/Refreshed Oracle Databases for development and testing
• Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g.
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• Installed Oracle Data guard for Oracle Disaster recovery, High Availability and data protection.
• Written PL/SQL Stored Procedures, Functions, Packages and Triggers
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL, PL/SQL statements, reorganize database objects and design indexes to improve response of queries.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports. Performed cold and hot backups.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created user accounts, roles and granting access permissions to the database.
• Written shell scripts for backup automation.
• Involved in designing logical & and physical data models using power designer.

Environment: Oracle 11g RAC/10g RAC/Oracle 9i, Data Guard, Sun Solaris, HP-UX, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, Golden Gate, Oracle Streams TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, AWR, ADDM

Confidential, San Jose, CA December 2007 – December 2009
Oracle DBA

Responsibilities:

• 24*7 Production Database Administration Support
• Installation and configuration of Oracle Server software 9i and 10g
• Created Oracle 9i and 10g databases, allocated system storage and planned future storage requirements for the database.
• Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.
• Written PL/SQL Stored Procedures, Functions, Packages and Triggers
• Automated hourly, daily, weekly system health reporting using crontab, PL/SQL and shell scripts.
• Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database. Maintained batch files, shell scripts and PL/SQL Procedures for scheduling backups.
• Implemented Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN. Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Implemented and maintained Database security. Created / Altered / Dropped Users as and when required and administer their respective quotas.
• Implemented cloning using RMAN to migrate data from PROD to UAT/QA/SIT and Dev databases.
• Implemented shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Created Database Links and Snapshots (Materialized views).
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Performance tuning using AWR, TKPROF, EXPLAIN PLAN & STATSPACK, AWR, ADDM
• As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.

Environment: Oracle 11g /10g RAC/Oracle 9i, Data Guard, HP-UX, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, AWR, ADDM

Confidential, Milwaukee, WI October 2006 – November 2007
Oracle DBA

Responsibilities:

• Installation of Oracle 9i, Oracle 10g and creation of databases.
• Performed regular Backups and Recovery as per Organization Strategy to support the database for 24 hours uptime while carrying out the activities.
• Responsible for configuration and implementation of backup strategies using RMAN.
• Backup/Restoration, Scheduling Backups, taking Logical Backups.
• Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Created Users, Roles with suitable Permissions.
• Responsible for Partitions on tables and Indexes for managing large tables.
• Maintained Logs/Backups
• Coordinated with Unix Administrators for Space Management on various servers.
• Performed SQL tuning by using Explain Plan and TKPROF and Oracle Enterprise Manager.
• Created Users and Roles with appropriate Privileges.
• Created Materialized views and database links.
• Wrote shell scripts for monitoring the database.
• Designed logical and physical Data Models using ERWIN.

Environment: Oracle 10g RAC/Oracle 9i/Oracle 8i, Data Guard, Sun Solaris, HP-UX, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, AWR, ADDM

Confidential May 2005 - September 2006
Oracle DBA/Developer

Responsibilities:

• Installation, configuration, and maintenance of Oracle Databases
• Load data from flat files files which come from Mainframes systems into Oracle database by using SQL*Loader
• Managing table spaces, data files, redo logs, tables and its segments
• Writing SQL, PL/SQL Coding database triggers, packages, stored procedures & functions
• Managing Users, Privileges, Roles, and takeing cold/hot backup of the databases
• Monitoring and Reorganizing Table spaces/Tables/Indexes
• Taking care of performance related issues by tuning memory as well as application tuning
• Create and Maintain Roles and assign necessary privileges to users according to business rules in development environments
• Optimization & Analyzing SQL queries for better Performance
• Load data using SQL*Loader
• Help users in creating database objects, and enrolling users

Environment: Oracle 10g/Oracle 9i/Oracle 8i, Windows, Sun Solaris, Red hat Linux, RMAN, ASM, SQL*Loader, Data Pump, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF, EXPLAIN PLAN