SUMMARY

• Over 6 years of IT experience, 5 years of extensive experience as an Oracle DBA on 9i, 10g, 11g in Standalone and Cluster environments.
• Build RAC from scratch on Red Hat Enterprise Linux.
• Experience in Data Center Migration.
• Experience in setting up Oracle Data Guard and Grid Control.
• Experience in setting up ASM disk groups and Golden Gate.
• Set up Materialize View Server.
• Worked with many following 11g new features. For example:
• SQL Access Advisor
• SQL Performance Analyzer
• SQL Plan Manager
• Table compression enhancement
• Active Data Guard
• Upgraded from 10 to 11g R2.
• Query Result Caching
• Invisible Indexes.
• Database Replay.
• AWR Baseline Enhancements
• Automatic Memory Management.
• Automatic SQL Tuning.
• Data Recovery Advisor.
• Read - Only Tables
• Flashback Enhancements
• RMAN Enhancements
• Table Compression Enhancements.
• Worked on Tablespace/Extent/Segment Management
• Worked on Backup and recoveries using user managed and RMAN.
• Setup Oracle Enterprise Manager (OEM) 10g
• Worked on 11g Cloud Grid Control for database monitoring / performance / diagnostics.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
• Maintain Oracle fail over databases (Physical and Logical standby databases- Data Guard)
• Oracle Tuning Pack. Oracle RAC Good knowledge of Flashback technology in Oracle 10g, & 11g.
• Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
• Experience monitoring Oracle RDBMS availability, database exports, datapump, tablespace, and extents fragmentation.
• Automated Storage Management (ASM) for 10g/11g databases.
• Installed and Administered Grid Control.
• Worked with Oracle on open issues.
• Discoverer Administration including the design and administration of Business areas.

TECHNICAL SKILLS

Databases: Oracle RDBMS 8i, 9i, 10g, 11g, RAC, Grid Control, Data Guard

DBA Tools/Utilities: RMAN, Oracle Enterprise Manager, AWR, Oracle Diagnostics Pack, DBCA, DBUA, SQL*Plus, SQL*Loader, Oracle Export/Import utilities, STATSPACK, EXPLAIN PLAN, TKPROF, TOAD, DBconsole, data pump.

Operating Systems: UNIX (Sun Solaris, HP-UX, AIX, LINUX), Windows NT/2000/XP

Languages: SQL, PL/SQL, Shell Scripting, HTML

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Oracle DBA

Responsibilities:

• Provide 24x7x365 administrative support staff.
• Configure Data Guard to provide high availability using Physical stand by database.
• Use RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Install, configure and setup of 11g RAC on Linux.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Install and implement 10g RAC with 4 nodes with ASM.
• Upgrade Databases from 10g to 11g and apply patches per requirement.
• Work on data center migrations on multiple database versions. i.e., 9i, 10g and 11g.
• Responsible for installing and configuring Golden Gate on Oracle Servers.
• Database migration from 9i to 10g to 11g.
• Design, configure and maintain backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Responsible for setting up Oracle Golden Gate to propagate information between databases.
• Recover databases and clone applications using RMAN.
• Use AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring & capacity planning for future database & server growth.
• Perform Range Partitioning to improve the performance of the database.
• Perform Cross platform migration using transportable tablespaces and RMAN.
• Perform Import and Export using Oracle Data pump utilities.
• Administer and maintain database security policies and procedures.
• Experience with administration of high-performance and large-scale multi-terabytes databases.
• Handle all standard database administrative tasks: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations as needed.
• Use external tables and SQL*Loader to import data from flat files.
• Monitor database space requirements and adjust for future needs.
• Perform version upgrades and patch installs.
• Design and implement database backup/restore methodologies, responsible for troubleshooting performance and networking issues. Basic OS system administration.
• Strict adherence to policies and procedures - specifically change management.
• Perform database administration tasks as part of a scheduled change management task.
• Work effectively with multiple teams at once.
• Provide end-users with updates on their problems. Install server software.

Environment: Oracle 9i/10g/11g databases, 9i/10g/11g (Active) Data Guard, 10g/11g RAC, Data pump, Export/Import, SQL*Loader, Physical Backups, Grid Control

Confidential, Fort Wayne, IN

Oracle DBA

Responsibilities:

• Performed Oracle DBA duties involving development and production support: installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
• Performed Hot/Cold backups of the database through RMAN or User Managed method.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Reviewed alert logs and dump files to check for any problems related to the database.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Discoverer Administration including the design and administration of Business areas.
• Maintained Oracle Application Server 10g for use with Discoverer, Portal and J2EE deployments.
• Developed PL/SQL based program for loading Data Mart.
• Oracle Applications server including OID. Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.
• Created and maintained users, roles and privileges.
• Upgraded/migrated the production & development databases from 9i to 10.2.0.1 to 10.2.0.2
• Participated in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Assisted in Database sizing, Capacity Planning.
• Performed Space Management & Troubleshooting the database issues.
• Upgraded OEM Repository and Installing OEM 10Grid Control to monitor all the databases.
• Configured and managed agents to work efficiently with Grid Control.
• Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists.
• Generated ASH, AWR, ADDM reports from Grid Control and command line.
• Set up privileges to create local and remote objects.
• Created materialized views to refresh data at regular intervals.
• Used materialized view logs to reduce the replication time costs for fast refreshes.
• Upgraded/Migrated from Oracle 8i databases to 9i and to 10g.

Environment: UNIX, Oracle 8i/9i/10g, Oracle 9i AS, Sun Solaris, Apache, VERITAS Net Backup

Confidential, Schaumburg, IL

Oracle DBA

Responsibilities:

• Pre-Upgrade Planning, study and analysis of Applications and database.
• Analysis of requirements upgrades from Oracle 8i to 9i.
• Database sizing, Capacity Planning.
• Estimate System/Database performance.
• Created/Configured test and development environments using Oracle export/import.
• Database refreshes from production to test and development environments.
• Implemented Oracle Reporting database using snapshots, materialized views from production environment.
• Install and configure Oracle 9i databases.
• Performed various Unix Administration tasks and automated with cronjobs.
• Developed SQL scripts and shell scripts.
• Applied various database and Application patches.
• Configured and implemented Backup and Recovery using RMAN.
• Performed Export/Import of Oracle 8i Database.
• Installed and configured Oracle 9i in test environment for Oracle Applications.
• Successful installation and configuration of Oracle 9i in test and production environment.
• Applied Oracle Database patches.
• Automated tasks using Bash shell scripts.
• Database and System monitoring and troubleshooting.
• Creation of new Database views and indexes.
• Installed databases ranging from version 8 to 10g R2.
• Installing client and upgrading them to satisfy clients need for application.
• Communicated with Oracle and open TAR on handful of occasions to troubleshoot various issues.

Environment: Oracle 9i, 10g on Sun Solaris, RHEL, Window, TOAD