SUMMARY

• Over 6 years of experience as an Oracle Database Administrator in a variety of database environments like Online Transactional, Data Warehousing and General purpose database and having expertise in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, auditing and designing databases.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g and 11g R2 in UNIX/LINUX and Windows environment.
• Oracle 12.1 experience includes, installing, upgrading and applying patches on AIX/Linux/Sun/Solaris on 3 and 2 node architecture.
• Migrated all application and database servers to AIX 5.1 and Red Hat AS 3.0 Linux running Oracle 10gRAC and 10g Application servers
• Patched 11.5.9 RAC installation, including Financials and OPM modules
• Experience as On - Call 24x7 production DBA support, application/development DBA.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g and 11g, with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Experience in a variety of hardware and software platforms including; MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation.).
• Good experience RAC Cluster ware administration, Configuration and Patching, RAC Backup and Recovery.
• Extensive experience in Data guard configuration, implementing and maintaining standby databases.
• Hands on experience in Grid control, Streams, Replication and GOLDEN GATE.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL Trace, Tk prof, Analyze, ADDM and Explain Plan Methods.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database monitoring/performance/diagnostics.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Table spaces.
• Good experience in PATCHING AND UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g.
• Extensive knowledge and experience on Data Warehouse using ETL.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers etc
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS)
• Experience in database cloning with RMAN, Capacity Planning, Database Refresh and patch management.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP

RDBMS: Oracle 11g/10g/9i/8i. Oracle 11i OBIE and 12.1

Languages: SQL

Replication Software/ Tools/Utilities: RMAN, OEM, DATA PUMP, Data Guard, GoldenGate

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, BitArmor

Database Modeling: Erwin 4.0, Rational rose, Toad Data Modeler, Datanamic and start UML, ER/Studio

Other: Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, Iselin, NJ

Sr. Oracle DBA

Responsibilities:

• On call 24X7 Production Support.
• Installation and configuration of a 2 node RAC.
• Upgrade from 11.0.3 to 11i.
• Installed and upgraded Oracle Databases on VMware environments.
• Responsible for cloning and patching the Oracle E-Business environment by utilizing tools such as rapid clone, adadmin, adctrl and adpatch.
• Oracle Applications Upgrade from Oracle Applications(E-Business Suite) 12.1.1 to 12.1.3
• On call 24X7 Oracle Production Support.
• Successfully completed migration an Oracle 9208 database of size 3.5 TB to Oracle 11g on AIX 6.1. The following were improvements:
• Nightly report refreshes complete 80% faster.
• Statistics complete 60% faster.
• Backups complete 75% faster.
• EOM Accrual and VI Pricing - Completed in about 13 hrs, which used to take around 45 to 48 hrs. on old system.
• Report refresh2 - 1 hr 20 mins (Used to take 5 to 7 hrs without RX on old system)
• Report refresh4 - 1 hr 20 mins (Used to take 8 to 10 hrs sometimes on old system)
• Leader Private Label - Completed in about 12 hrs Implemented Shareplex for replication.
• Configuration and installation tasks related to ASM.
• Configuring a Physical stand by with Maximum Availability mode.
• Configuration and implementation of Golden Gate based replications.
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests
• Setup and administration activities of GoldenGate.
• Troubleshooting of Replication errors/lags.
• Backup/Recovery for GoldenGate instances and related databases Experience in Replication, Clustering, and other methods of disaster recovery.
• Have experience in RAC, RMAN, tuning, and preferably GoldenGate Performs data modeling, logical and physical database design.
• Executes database software installation, database creations/configurations and loads.
• Experience working with an application development team. Solid skills in database performance factors, DR,monitoring tools and tuning procedures.
• Responsible for online and offline backups of the oracle database using RMAN.
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backup.
• Using TKPROF, EXPLAIN PLAN for the Better performance.

Environment: Oracle 11g/10g, Oralce 11i/12,HP-UX UNIX RHEL 5.x, MS Windows server 2003-R2-SP2, ASM 10.2.0.4, CRS 10.2.0.4, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, VERITAS Net Backup.

Confidential, Jersey City, NJ

Sr. Oracle DBA

Responsibilities:

• Installation and configuration of oracle 11g R1/10g on HP-UX, UNIX RHEL 5.x series.
• Installation, configuration and monitoring of a 3 node RAC environment.
• Installed and upgraded Oracle Databases on VMware environments.
• Oracle 11i and 12.1 OBIE experience includes, installing, upgrading and Patching.
• Perform 2-tier and 3-tier clones of Oracle Applications 11i instances.
• Performed Database Refresh from Production to QA and Development databases.
• Migration of Oracle 10.2.0.4 databases to 11.1.0.7.0 databases.
• Applied Patch 22 and 23 to 11.1.0.7.0 RAC databases.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.
• Implementation of bidirectional streams.
• Configuration and Implementation of Golden Gate.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Experience with streams in enqueuing and dequiuing messages, Starting and stopping streams processes and Perform troubleshooting of streams environment.
• Monitoring Day-Day Backups, Log’s & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, replication & failover.
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.

Environment: Oracle 11g/10g,HP-UX UNIX RHEL 5.x, MS Windows server 2003-R2-SP2, ASM 10.2.0.4, CRS 10.2.0.4, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, VERITAS Net Backup.

Confidential, Stamford, CT

Sr. Oracle performance tuning DBA

Responsibilities:

• 24x7 Production database (Oracle 10g/11GR2 RAC and 11i OBIE) administration.
• Installation and configuration of a 2 node RAC.
• Oracle 11i and 12.1 OBIE experience includes, installing, upgrading and Patching.
• Configuring and maintaining a physical standby database.
• Backup/Restoration, scheduling Backups and taking Logical Backups.
• Coordinate with Unix Administrators for space management on various servers and help in Oracle.
• Monitoring of database performance during peak and non-peak loads.
• Conducting sizing and capacity planning for databases.
• Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Setting up Physical Standby Database in Remote Location for Disaster Recovery.
• Support & Maintenance of Production/Development Databases on various servers.
• Creating users, tables with appropriate table space, Indexing and database links.
• Performing Partial, Complete and Metadata Exports & Imports.
• Automating processes, scheduling jobs per user requirements using DBMS JOB.
• Used OLTP class of program by managing transaction oriented application for data entry and retrieval transaction.
• Data Guard implementation.
• Tuning the Databases for optimization using STATSPACK and EXPLAIN PLANS, Estimating Table & Index Size.
• Partitioning Strategies for very large tables.
• Performed backup and recovery for both hot and cold backups.
• Daily monitoring and optimizing the performance of the database to ensure that database resource such as table spaces, memory configuration, sessions, archive files, etc, are in their proper status.
• Scheduled jobs through Oracle Job Scheduler.
• Created/Altered/Modified database objects.
• Responsible to troubleshoot both Oracle applications and backend data base errors
• Configured and managed users, security and redo logs.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service when required.
• Oracle Installation, patch application and migration of databases to newer releases of Oracle.
• Supported test and development environments to ensure smooth transition of applications

Environment: Oracle 10g/9i, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, DataGuard, EXPLAIN PLAN Cloning, OEM, STATSPACK, and TKPROF.

Confidential

Sr. Oracle DBA

Responsibilities:

• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
• Monitoring and Troubleshooting of Database Replication issues.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous Performance monitoring and tuning of the databases and application using TOAD and OEM, Tuning Pack, Diagnostics Pack, and STATSPACK.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM.
• Involved in performing migration from Oracle 9i, 10g to Oracle 10g Release2 RAC,11g RAC database.
• Upgraded the existing databases from Oracle 10.1 to 10.3
• Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views
• Creating and Managing Table spaces with different block-sizes to prevent row chaining
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Setup of Standby Database using Data guard for faster Disaster Recovery.
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Adding a Disk group, removing a disk group, movement of data between disk groups in a ASM storage platform.
• Continuous Performance monitoring and tuning of the databases and application using TOAD and OEM, Tuning Pack, Diagnostics Pack, and STATSPACK.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM.
• Scheduling jobs through Oracle Job Scheduler.
• SQL Tunings for Performance of Objects.
• OS level activities like space monitoring of Mount point.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Adding a Disk group, removing a disk group, movement of data between disk groups in a ASM storage platform

Environment: Red Hat Linux 4.x, Solaris 10, HP-UX11, Oracle 9i, 10gRAC 11g

Confidential

Jr. Oracle DBA

Responsibilities:

• Data Guard implementation.
• Tuning the Databases for optimization using STATSPACK and EXPLAIN PLANS, Estimating Table & Index Size.
• Partitioning Strategies for very large tables.
• Performed backup and recovery for both hot and cold backups.
• Daily monitoring and optimizing the performance of the database to ensure that database resource such as table spaces, memory configuration, sessions, archive files, etc, are in their proper status.
• Scheduled jobs through Oracle Job Scheduler.
• Created/Altered/Modified database objects.
• Adding a Disk group, removing a disk group, movement of data between disk groups in a ASM storage platform.
• Continuous Performance monitoring and tuning of the databases and application using TOAD and OEM, Tuning Pack, Diagnostics Pack, and STATSPACK.
• Implementation of changes on databases.