SUMMARY

• Over 7+ years of experience in Oracle Database Administration, Worked extensively on Installations of Oracle Database Software 11gR2, 10g, 9i, 8i on OEL, RHEL, UNIX, AIX, Sun Solaris and Windows environments.
• Experienced in Oracle Database's High Availability solution set like, configuration and monitoring of Oracle Real Application Cluster (RAC), Data Guard and GoldenGate.
• Experienced in Upgradation, applying oracle PSU and CPU Patches, Migration, Backup and Recovery, Cloning oracle database from production to development Replication, Database Security, RMAN, User Management Performance tuning and monitoring teh database using OEM Grid Control.
• Experience in installation and configuration of Oracle 8i, 9i, 10gRAC, 11gR2 (RAC) databases in LINUX, HP - UX, SOLARIS, IBM AIX and Windows environments.
• Experience in upgrading teh database from Oracle 9i to Oracle 10g & oracle 10g to oracle 11gR2 and migration of teh databases using transportable database, tablespaces export/import, data pump utilities.
• Planned and implemented Oracle 10g RAC, 11gR2 RAC and Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).
• Experience in installing and patching ASM wif Oracle (RAC) on AIX, Solaris and Linux platforms.
• Installed and configured oracle Grid control and deployed agent on managed targets.
• Experienced in configuring resource allocation, information sharing, and high availability wif (RAC)
• Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN).
• Experienced in installation, configuring and managing Golden Gate V10x, V11x on Oracle 10g and 11gR2 wif Linux, HP-UX and Windows platforms.
• Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Experience in implementing cross platform Migration from HP-UX to AIX, Solaris to Linux and Windows to Linux
• Expertise on performing cold backups, hot backups, advanced recovery methods like flash back recovery using (RMAN) recovery manager.
• Experience in Implementing and maintaining Database security.
• Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance.
• Good experience wif Oracle grid control, Oracle enterprise manager (OEM), ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor.
• Expertise in maintaining Database Roles, Users using Security Compliance Auditing, expertise in loading data from Flat Files using SQL*LOADER and External Table.
• Performance Tuning: Experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, (OEM) Grid Monitoring.
• Experience in proprietary change management processes to prevent production disruptions and outages. Cloned Database from Production to Test and Development and from Development to Production.
• 24*7 production database support wif support to developers & end-users.
• Good communication and coordination wif different departments (IT & Non-IT) for efficient problem escalation and deciding on optimal solution.

TECHNICAL SKILLS

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 8,9,10 IBM AIX 5.x, 6.x, Red Hat Linux 4 .x, 5.x, 6.x, and Windows.

RDBMS: Oracle 8i, 9i, 10gRAC, 11gR2RAC, SQL Server 2005 and 2008.

LANGUAGES: SQL, PL/SQL, Java, C, XML, Pearl, Shell Scripting.

UTILITIES: RMAN, Oracle Enterprise Manager/Grid Control, Data Guard, SQL*Loader, EXP, IMP, Data pump, SQL developer, VeritasNetBackup and Golden Gate.

TOOLS: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ADDM, Putty and AUTO Trace, Winscp3, ERWIN.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Oracle DBA

Responsibilities:

• 24*7 production database supported wif support to developers & end-users.
• Oracle 10g and 11gR2 installation and administration.
• Involved in Oracle Database upgrades from 10g to Oracle 11gR2R2.
• Installed and configured multi node Oracle 11gR2R2 (RAC) for High Availability.
• Installed and configured Oracle Physical Standby Databases(DATA GUARD) for Disaster Recovery
• Identified and performed SQL tuning using EXPLAIN PLAN, SQL TRACE and TKPROF, Analyzed tables, indexes for improving teh performance of teh Query
• Constantly Performed monitoring and tuning using STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.
• Implemented Automatic Shared Memory Management (ASMM) and Automatic Segment Space Management (ASSM).
• Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations on an as needed basis.
• Refresh/Cloning of teh databases from Production to teh Test and Development environments.
• Installation configured and Supported database replication using GoldenGate V10x 11gR2 wif Linux.
• Implemented and maintained Database security.
• Involved in designing and implementing Oracle backup and recovery methods using recovery manager (RMAN).
• Used Export/Import, Data Pump Utilities to move teh data between different databases and for backups.
• Worked on ATG repository, ATG Dynamo and created ATG form handler.
• Created and managing user, roles, privileges, profile, schemas in oracle 11gR2R2.
• Implementation and monitoring of all databases using OEM/Grid Control.
• Implemented Database Logical and physical models of databases and Migration & conversion of existing data.
• Loading data from flat files using SQL*Loader and Developed UNIX Shell scripts to automate backups using recovery manager (RMAN).
• Implementing teh changes in teh database design and modifying stored procedures in PL/SQL if necessary.
• Managed and resolved design issues during development and suggested standards to ensure dat all design was produced wif proper integrity, security and performance.
• Manipulated tables to manage teh data and data types. Modified tables to change teh data types and added new columns (according to requirement).
• Partitioned large tables for better performance and manageability
• Involved in Conceptual Database Design, Logical and Physical Database Design.
• Involved in implementation of 10g GRID and GRID CONTROL agent.
• Developed scripts to refresh of databases in stage and development environments
• Provided support to Application Database Administrators in designing teh database.

Environment: Oracle 9i/10g/11gR2, Linux, Solaris, PLSQL, Shell Scripting, RMAN, Grid control, Data Guard, EXP, IMP, Data Pump, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Confidential, Bothell, WA

Sr. Oracle DBA

Responsibilities:

• Worked on Oracle 10.2.0.1 and upgraded to 10.2.0.4.
• Worked on RAC 2-node for high availability.
• Applying CPU patches and then changed to PSU patching.
• Responsible for applying quarterly PSU security patches.
• Install, Setup and configured extended 10g RAC on Unix Box.
• Created oracle database, tables, materialized view, objects wif storage parameters based on quarterly growth requirements of teh system
• Installation of Oracle 10g Grid and respective agents on databases, application servers, predefine templates wif group option to monitor Prod, UAT and Dev Databases.
• Responsible for rman backups and improvement to backup wif incremental back by adding block change tracking feature of Oracle 10gR2
• In order to protect data in teh Production Database, implemented Standby Database and Synchronization of Standby Database wif teh primary database.
• Monitored and allocated share memory, table space as needed and managed replicated servers.
• Monitored backups, space usage, and user activity on daily basis and Performed daily hot backups and weekly Cold backups using RMAN.
• Identified poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF, Analyzed tables, indexes for improving teh performance of teh Query
• Altered, modified, Partitioned, dropped, created Database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM.
• Set up of ADDM and AWR report. Working wif developers to resolve performance issues and support production release 24x7 support as on call dba and during integration / patch update release
• Also responsible for patch management of teh applications.
• Deploying portal applications for QA and certification instances.

Environment: Oracle 10g RAC wif ASM, Oracle 10g standalone, OEM 10g, UNIX, SQL Server 2005

Confidential, MN

Sr. Oracle DBA

Responsibilities:

• 24x7 product database support
• Installed and maintained 10g/11gR2 databases for testing, development and production
• Database Monitoring and administration of database using Enterprise Manager Grid control (OEM).
• Upgraded Oracle Database from 9i to 10g, 10g to 11gR2.
• Cloning of teh database from Production to teh Test and Development environments using RMAN and conventional methods.
• Installed and configured oracle grid control.
• Used Oracle Streams for replications of data between remote databases
• Performed Cold backup, hot backup using conventional back ups and RMAN, recovered various and critical Production databases.
• Prepared backup schedule which include offline, online and logical backups.
• Used Export/Import, Data Pump Utilities to move teh data between different databases and for backups.
• Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
• Generated performance reports and Daily health check up of teh database using utilities like AWR, Statspack and ADDM to gather performance statistics.
• Partition of tables to improve performance.
• Created users and allocated appropriate table space quotas wif necessary privileges and roles for all databases.
• Worked on SQL* Loader to load data from flat files, Checking for Row Migration and Chaining on Highly used transaction tables.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Created DB links across databases and Solved Database connectivity issues by continuously monitoring teh status of teh listeners and instances.
• Checked alert logs and background trace files on daily basis and resolved problems.
• Automated shell scripts and scheduled batch jobs.

Environment: Oracle 9i/10g/11gR2, Linux, Solaris, PLSQL, Shell Scripting, RMAN, Grid control, Data Guard, EXP, IMP, Data Pump, TKPROF.

Confidential

Jr. Oracle DBA

Responsibilities:

• Proficient in installation and creation of Oracle 9i, 10g databases in development, Production and QA environments including configuration, backup & performance tuning.
• Designing, documenting and deploying through teh various development and production environments.
• Refresh/Cloning of teh databases from Production to teh Test and Development environments.
• Upgraded database from Oracle 9i to Oracle 10g.
• Installation and Configuration of Oracle 10gRAC and Standby Databases for high availability and disaster recovery..
• Database Migration
• Worked wif Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Planned and implemented Backup & Recovery using RMAN.
• Implemented Cold Backup and Hot Backup depending on teh requirement.
• Refreshed development and test databases from production using Logical Backups (Export and Import).
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, AWR, STATSPACK.
• Daily Health Check Up of teh Database using ADDM wif teh halp of AWR report.
• Written SQL, PL/SQL scripts and Shell scripting to monitor table space and extent growth. Space Management, which includes table space creation, adding new data files.
• Maintaining Database Security by Creating Roles, Privileges, Quotas, and Passwords.
• Troubleshooting and Technical Support on Oracle Database & Oracle Applications and Network Administration using SR, SAR,IOSTAT and RDA.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environment: IBM AIX, Oracle 10g/9i enterprise edition 9.2.0.4, Windows servers, Oracle Enterprise Manager.