OBJECTIVE

• As one of teh outstanding Oracle Database Administrators in teh industry seek opportunities to apply my expertise towards solving large, complex IT challenges.
• me have lead various projects in 11g/10g/9i/8i using RAC and ASM for High Availability, Data guard for Disaster recovery, Installation, Configuration, Migration, Capacity planning, Performance Tuning, RMAN for Backup and recovery.

SUMMARY

• Around 7 years of experience as an Oracle Database Administrator having hands on experience
• In database administration, production support, installation, configuration, upgrades, patches,
• Performance tuning, backup and recovery, cloning, space management, database security, Auditing.
• Involved in different scenarios of OLTP
• Experience in HP - UX, AIX, SUN SOLARIS, Linux and Windows environments.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g,11g in UNIX/LINUX and Windows environment.
• Planned and implemented DR & high availability solutions using Oracle 10g Standby Database using Oracle Data Guard, 9i and 10g RAC.
• Management of schemas, objects & Partitioning teh tables & indexes, AWR, ADDM and 10g OEM Grid Monitoring
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN wif VERITAS Net Backup & IBM TSM
• Experienced in using 10g and 11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning
• Delivering Oracle Database performance-tuning services for customers wif EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10g OEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Proceduresf
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Experience in Goldengate wif an OracleRac
• Excellent knowledge of Oracle Architecture, SGA, Configuration of TCP/IP protocol, Listeners, TNSnames, SQLNET, V$ and DBA views
• Excellent Written and verbal Communication skills wif a customer service oriented attitude.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2Red Hat Linux RHEL 2.1, 3.x, 4.x .

RDBMS: Oracle 11g/10g/9i, 10g RAC

Languages: SQL, PL/SQL, C, C++

Tools: RMAN, Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle DataGuard, SQL*Loader, EXP, IMP, expdp, impdp, TOAD, Sql Navigator, Golden gate.

Tuning Tools: TKPROF, EXPLAIN PLAN

Other: NetApp, Veritas Net Backup, TSM

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• Installation and creation of 10g and 11g databases for Testing, Development and Production .
• Installation and Upgrading of OEM for Testing, Development and Production on 10g RAC.
• Used OEM extensively and set up Rules for alert notification and schedule RMAN backups wif Failure notification.
• Extensively worked on setting up Auditing in many databases we supported.
• Responsible for optimizing teh queries and application tuning.
• Refreshed schema using Export/Import. Created teh database, tablespace, tables, indexes, set privileges and user logins .
• Installed and Implemented Backup & Recovery procedures.
• Partitioning Strategies for very large tables implementing Range, List Partitions, Hash Sub Partitions, creating and refreshing Materialized views Cloning & duplicating databases using scripts as well as RMAN.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Autantication.
• Used Secure SCP & FTP extensively for teh File transfers from machines to remote server.
• Moved tablespaces across platforms using Transportable tablespaces wif RMAN
• Migration oracle databases from windows to linux.
• Implement Hot, Cold and Logical backup plans.
• Creating and Managing Tablespaces wif different block-sizes to prevent row chaining.
• Installing And Configuring Oracle GoldenGate In An Oracle RAC Environment.
• Transportating teh tablespaces using teh GoldenGate tool.
• Effectively resolved incident tickets(ITG) in teh development environment.
• Effectively resolved incident tickets(HPSM) in teh production environment.
• Installed and configured Oracle 10gR2 database on 10gR2 cluster.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• me had done Migrating to RAC using Data Guard
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.

Environment: HP-UX, AIX, Oracle 10g, 11g, 10g R2 RAC, OEM, UNIX, SQL, Oracle Auditing, Oracle Partitioning, Data Guard, Grid Control, Hot Standby, RMAN, TOAD

Confidential

Oracle Database Administrator

Responsibilities:

• Migration oracle databases from windows to linux.
• Database dot release upgrades using oracle universal installer and catpatch.sql.
• Database patching using opatch.pl perl script.
• Proactive database monitoring using 10g grid monitoring tool.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Installation, Configuration and Maintenance of RAC, Stand by database
• Upgrading development and production databases to Oracle 10g.
• Applied patches to Oracle Databases and Oracle Applications.
• Applied Oracle Applications and database patches.
• Upgrading development and production databases to Oracle 11g.
• Migrating from Oracle 10.2.0.4 on Solaris databases to Oracle 11.2.0.2 on Linux.
• Applied patches to Oracle Databases and Oracle Applications.
• Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
• Provided support to Application Database Administrators in designing teh database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Customization and development of Korn shell scripts.
• Management of schemas, objects partitioning teh tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring..
• Oracle Database monitoring, troubleshoot and resolve teh issues.
• Management of schemas, objects partitioning teh tables & indexes.

Environment: Sun Solaris 5.10, AIX, Windows 2000/2003, Oracle 9i, 10G, and 10g R2 RAC, OEM, UNIX, SQL, Oracle Auditing, Oracle Partitioning, Data Guard, Grid Control, Hot Standby, RMAN, TOAD.

Confidential, Milwaukee, WI

Oracle Database Administrator

Responsibilities:

• Installation and creation of 10g and 11g databases for Testing, Development and Production
• Installation and Upgrading of OEM for Testing, Development and Production on 10g RAC.
• Used OEM extensively and set up Rules for alert notification and schedule RMAN backups wif Failure notification
• Installing and configuring 10g/11g Real Application Clusters (RAC). Troubleshooting performance problems.
• Extensively worked on setting up auditing in many databases we supported.
• Responsible for optimizing teh queries and application tuning.
• Refreshed schema using Export/Import. Created teh database, tablespace, tables, indexes, set privileges and user logins
• Installed and Implemented Backup & Recovery procedures
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Autantication.
• Effectively resolved incident tickets in teh production environment.
• Installed and configured Oracle 10gR2 database on 10gR2 cluster
• Experience in Data modeling using Data modeling tools such as Toad Data Modeler

Environment: Sun Solaris 5.10, AIX, Windows 2000/2003, Oracle 9i, 10G, and 10g R2 RAC, OEM, UNIX, SQL, Oracle Auditing, Oracle Partitioning, Data Guard, Grid Control, Hot Standby, RMAN, TOAD.

Confidential, Hartford, CT

Oracle Database Administrator

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring teh Oracle server.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase teh performance.
• Configured scripts to monitor activity wif database.
• Responsible for optimizing teh queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Designed backup and recovery procedures for OLTP system
• Enhanced teh performance of teh company’s Oracle environment by providing advanced performance tuning and coding standards.
• Use TOAD tool to access teh database
• Used PL/SQL developer to create PL/SQL Procedures
• Testing PL/SQL procedures against teh test cases.
• Involved in creating use cases and test cases

Confidential

Oracle DBA

Responsibilities:

• Installing Oracle 10g and upgraded it to latest 10g patch set on HP-UX 11.23
• Migrating applications from non-clustered oracle 8i/9i/10g databases to new
• 10g RAC Database environments
• Monitoring and supporting Applications using OEM 10g Grid Control
• Configured two node Oracle 10g RAC cluster
• Applying patches
• Registering Databases to Oracle 10g GRID
• Registering Databases to RMAN Catalog
• Planning and scheduling Backups, RMAN, taking Logical Backups.
• Experience in Export/Import and Datapump.

Environment: Windows 98/NT / 2000, HP-UX, AIX, Oracle 9i, TOAD, Database Tools/Utilities, Oracle Enterprise Manager.