SUMMARY:

Around 8years of IT experience working as an Oracle Database Administrator, having hands on experience in Production and Development.Spanning various industries like insurance, banking, financial, telecomm and pharmaceuticals etc.Proficient in an assortment of technologies with Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.

• Experience in installation, configuration, administration of Oracle9i, 10g, 11g, 10g RAC, 11g RAC database in Unix/Linux and Windows environments.
• Extensive Experience in Configuring Single instance to multimode, Real Application Clusters(RAC), Automatic Storage Management (ASM) and Data guard.
• Experience in Configuring Physical and Logical Standby database and Active Data Guard..
• Experience working with latest GoldenGate technology for fast data replication.
• Migrated single instance databases to multimode 10g RAC, 11g RAC environment for high availability and load balancing.
• Installed, Configured and maintained 4 Node 11gR2 RAC with ASM production databases. Installed and Configured Oracle 10g RAC (4 node cluster), CRS using ASM.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control, AWR, ADDM, STATS PACK and tuning of SQL scripts using SQL Trace, Explain Plan, and Hints.
• Good exposure of Oracle DBA tasks Installation, Patching, Cloningand Upgrade of Databases.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES.
• Worked extensively on created development, testing, staging, production and RAC and standby databases for OLTP and Data Warehousing.
• Experience in Upgrading databases to higher versions, applying security patches to the databases.
• Worked with a team to provide 24x7 on-callproduction database support.
• Excellent knowledge in Flashback Recoveryand Cloning of databases using RMAN.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Solid experience in using Tools like OEM, TOAD,DB Artisan and SQL Developer and performing data migrations using Export/Import utility.
• Involved in planning, controlling and monitoring shareplex replicationon RAC environment.
• Data loading using SQL*LOADER, Logical backups using full Export and DATAPUMP.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions.
• Experienced in Oracle Support (raising SR) processes for technical requests through Metalink .
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Responsible for interacting with business partners to identify information needs and business requirements.

TECHNICAL SKILLS:

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

Databases: Oracle 11g/10g/9i/8i,RAC11g,RAC10g.

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, DB artisan and Grid Control.

Tools: & Utilities: AWR,ADDM, Export/Import, RMAN, Data Pump, ERWIN,Veritas net backup, TKPROF, EXPLAIN PLAN,STATSPACK, ASM, ODBC,RMAN, Oracle Management Service(OMS).

Languages: C, SQL, Unix shell scripts, PL/SQL.

Networking: TCP/IP, SSH, Oracle Net Services & ODBC.

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

Senior Oracle Database Administrator

Responsibilities:

• Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on LINUX and AIX.
• Involved in performing migration from Oracle 10.2.0.4 RAC to 11.2.0.2 RAC database.
• Experienced in Oracle GoldenGate installation, configuration, troubleshooting perform issues.
• Implemented ASM on RAC. Managing disks and disk groups with ASM.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL,CRSCTL, OCR and Voting Disk of 10g, 11g RAC.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion and Implemented 10g/11g RAC on a test basis.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade and 24x7 production support.
• Monitored and troubleshooting database issues with OEM grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage and created database triggers using PL/SQL.
• Used shell scripts for monitoring jobs, for startup and shutdown, health check of databases, analyzing stats at different levels, rebuilding indexes and for purging as well.
• Additionally part of rotation on call DBA to support Production databases 24X7.

Environment: Oracle 11g/10g, RAC 11g/10g, RHEL, IBM-AIX, Windows 2003/NT, OEM, Grid Control, RMAN, ASM, CRS, DATA GUARD, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, AWR,ADDM and DB Artisan.

Confidential, San Antonio, TX

Oracle Database Administrator

Responsibilities:

• Installation and Maintenance of Oracle 10g, 11g on LINUX and Window platforms.
• Configuration, Installation and maintenance of Oracle 10g RAC,11g RAC databases including ASM and CRS.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Experience in Configuring Physical and Logical Standby database and Active Data Guard.
• Experience in production database performance monitoring and capacity planning.
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, RAW Devices.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade and 24x7 production support.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Installation of Oracle database 10g software with RAC using Oracle Cluster ware, Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Created various Database triggers using PL/SQL
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

Environment: Oracle 11g/10g,RAC 11g/10g, RHEL, Windows 2003/NT, OEM, Grid control, RMAN, ASM, CRS, DATA GUARD, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, AWR,ADDM.

Confidential, Hartford, CT

Oracle Database Administrator

Responsibilities:

• Involved in team management, team building exercises for the DBA team .
• Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Wrote several shell scripts for checking oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Experience in ORACLE SERVER ADMINISTRATION. Created Users, Implementing Backups, Cloned the Databases, Backing up and Refreshing ORACLE DB’s.
• Creating table spaces, sizing the system table space, allocating default table spaces for users.
• Creating users with restricted access, with default and temporary table spaces. creating different kinds of partitions on tables and indexes
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing hot and cold backups.
• Restoration and recovery from backup.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Oracle Export, Import, SQL*Loader and data pump utilities.
• Installing & configuring Oracle 10g RAC on Linux & AIX.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS.
• SQL issues and Tuning Considerations for Different Applications.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Developed PL/SQL scripts for exception handling.
• Redesigned a thorough backup and recovery strategy for all major production systems.

Environment: RHEL, UNIX AIX,ORACLE 9i/10g,10gRAC, OEM, RMAN,ASM, CRS,DATAGUARD, AWR,ADDM, grid control, SQL,PL/SQL, Import/Export, Data pump.

Confidential, Milwaukee, WI

Oracle Database Administrator

Responsibilities:

• Installing, Creating and Maintaining the Oracle database on 10g.
• Involved in performing migration from Oracle 9i, 10g to Oracle 10g Release2 RAC database.
• Configuring database entries and monitoring all of the databases using OEM.
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Used ERWIN for logical and Physical database modeling.
• Physical Database Capacity Planning and data-files mapping.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Installing ASM environment and migrating database from NON-ASM to ASM
• Daily Health Checkup of the database using AWR, ADDM.
• Install, Configure and implement Oracle Advanced Replication as the lead DBA.
• Management of schemas, objects partitioning the tables & indexes.
• Taking Periodic Backup of the databases and the software using RMAN.
• Recovery of Database(Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environment: HP -UX, Solaris, Oracle 9i/10g, RAC, OEM, RMAN, DBCA, ASM, Export/import, Data pump, Data Guard, PL/SQL, Load Runner, TOAD.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Registering Databases to RMAN Catalog.
• Planning and scheduling Backups, RMAN, taking Logical Backups.
• Experience in Export/Import and Data pump.
• Creating primary database storage structures (tablespaces, datafiles, tables, indexes etc).
• Developing hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Troubleshooting through examining Oracle alert logs, system logs and trace files
• Monitoring the Database storage and day to day activities.
• Configured scripts to monitor activity with database.
• Partitioned large tables to increase the performance.
• Performing all daily maintenance tasks. Interacting with oracle customer service as and when required.

Environment: HP -UX, Windows XP, Oracle 8i, 9i, Import/Export, PL/SQL, RMAN.