SUMMARY

• Over 7+ years of experience as an Oracle Database Administrator in the Database Installation, Development and Production System Support leading global teams in a wide variety of cutting edge environments.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, streams, partitioning, database security, troubleshooting, database design, UNIX shell scripting, korn shell scripting and documentation.
• Experience in OLTP/DSS database systems, managing large Oracle databases (VLDB) and data warehouse systems.
• 5 years of experience in Installation and Involved in Implementing RAC Database with 2 and 4 nodes on Linux/Aix/Solaris.
• Strong experience with Oracle Databases (11g/10g), RAC on different flavours of UNIX.
• 3+ years of Proficient Experience supported by Data Guard for disaster recovery purpose.
• Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).
• Managing Oracle ASM File Access Control for Disk Groups.
• Proficient in implementation of Oracle Streams in unidirectional table level(local capture).
• Managed streams for data replication, data protection.
• Using Golden Gate 11g for testing purpose in the table level.
• Configured database 10g, 11g for ORACLE FLASHBACK TECHNOLOGY.
• Managed Materialized Views for data replication purpose.
• 7 years of strong experience in Hot/Cold Backup and Recovery.
• Strong Experience in Cloning of databases using RMAN, User - Managed Backup.
• Planning and preparing for TSPITR using RMAN.
• Very good experience in applying Patches (Patching), Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and runinstaller, also involved in Upgrading and Migration of a Oracle server to higher version available.
• Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases and Oracle Applications.
• 5 years of Extensive Experience in Installing and Upgrading Oracle 9i/10g databases on production, test and development environments on Linux.
• 3 years of experience in Implementing Data Pump, Export and Import using transportable tablespace.
• 6 years of Extensive Performance Tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• Involved in Monitoring, Optimizing Oracle database for Performance Tuning & system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, CBO, TKPROF, EXPLAIN PLAN, SQL TRACE, and UTLBSTAT.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Strong skills in shell, perl and korn shell scripting to automate jobs.
• Experience in Troubleshooting oracle databases using sqltrace utilities.
• Excellent Knowledge on Oracle Support processes for technical requests with Metalink.
• 6 years of proficient experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Korn Shell Scripting, Partitioning, Data modeling, Oracle Data Dictionary - meta data, Logical and Physical Database Design, Backup and Recovery procedures.
• Experiencing in basic and advanced replication.
• 4 years of Experience in using OEM, TOAD.
• 3 years of Experience in Implementing and configuring 10g OEM Grid Control.
• Expertise in maintaining Database Security using auditing.
• Expertise in loading data from flat files using external tables, SQL*Loader.
• Proven ability to adapt to demanding schedules and changing priorities.
• Very good experience in solving ORA-600, ORA-1555, ORA-7445 errors.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
• Result oriented, self-motivated, Team player, ability to work independently and within a team.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Linux RHEL 2.1, 3.x, 4.x, MS SQL Server 2000 & 2005,Windows NT,XP,V

RDBMS: Oracle 11g/10g/9i/8i

Languages: SQL, PL/SQL, C, C++, Perl, Korn, UNIX Shell Scripting, Java, VB, Advanced VB

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

Database Modeling: Erwin 4.0, Rational rose, UML 2.0

Other: EMC, NetApp, Veritas NetBackup

PROFESSIONAL EXPERIENCE:

Confidential, CA

Oracle DBA

Responsibilities:

• Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Installation, Cloning, Configuration and Administration of Oracle 11g RAC.
• Applied patches to 11.2.0.1 to 11.2.0.3 and Performed RAC installation
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Upgraded Oracle Database from 11.2.0.1 to 11.2.0.2.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication materialized views.
• Created and maintained immediate failover with up to the minute data to minimize the recovery time mission critical systems using oracle GOLDEN GATE (Testing Purpose).
• Cloning databases using scripts as well as RMAN.
• Set up backup and recovery procedure using RMAN.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Created duplicate databases using RMAN duplicate.
• Worked on TSPITR using RMAN.
• Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces and Packages.
• Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.
• Applied CPU/PSU patches for oracle database versions 11.1.0.7 and 11.2.0.2.
• Utilized SQL*loader and data pump import to load data into tables.
• Refresh schema using Export/Import. Creating the database, tablespaces, tables, indexes, settings privileges and user logins.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Performance Tuning use of SQL diagnostic (ADDM, SQL Adviser) and Oracle utilities like AWR, STATSPACK, EXPLAIN PLAN, AUTO TRACE & TKPROF.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.
• Created UNIX shell scripts to automate batch jobs through CRON.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• 24x7 production database support.
• A self-motivated, responsible and reliable team player with a set of strong technical skills.
• Excellent analytical, interpersonal and communication skills.
• Enthusiasm in learning new technologies.

Confidential, Philadelphia, PA

Oracle DBA

Responsibilities:

• Troubleshooting RAC ASM and Oracle Cluster ware related issues.
• Involved and Implemented Disaster Recovery Plan (Oracle 10g Data Guard).
• Installed and used Oracle 10g OEM Grid control and TOAD in monitoring and accomplishing Database Administration issues.
• Monitoring infrastructure tier and middle tier processes using OEM 10g Application Control Consoles and database with OEM dbconsole.
• Replicating schema/table level database using Streams. Performed unidirectional table level replication using Streams.
• Performed Backup/Recovery of the Oracle databases using RMAN Incremental & Hot Backup.
• Configured Recovery Manager (RMAN) like Advice on data recovery, parallel backup of the same file, and virtual catalogs for security.
• Restore and Recover, Cloning and Duplicating databases using scripts as well as with RMAN.
• Migration: Duplicated database using RMAN and upgraded it to oracle 10g/11g and applied latest patch set.
• Applied the bundle and CPU patches to all test, development and production databases.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Installed and Upgraded Oracle 9i(9.2.0.8) database to Oracle 10g(10.2.0.4) database.
• Migrated Database schemas and full Database using export and import utilities.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.
• Export and Import of Portal Schema using Transport Set utility and Oracle Internet Directory Users with LDIF utility.
• Database performance tuning using STATSPACK, TKPROF, SQL Trace and Explain Plan.
• Performed Database Administration activities such as Upgrades, Patches, TAR-Support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Developed Korn, Perl, shell scripts for automating the Database job processes.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• Involved in 24x7 Production Database Administration and support.
• Excellent Written and verbal Communication skills with a customer service oriented attitude.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Strong listening, interpersonal and analytical skills.

Confidential, Carlsbad, CA

Oracle DBA

Responsibilities:

• Converted a single instance database to Oracle RAC 10g and implemented 4 node 11g RAC on test environment.
• Installation, Configuration and Administration of 4 node Oracle 10g RAC.
• Installed and Upgraded Oracle 11g database from Oracle 10g database on test and development environments.
• ASM and CRS installation and new database creation for 10g RAC.
• Was involved in developing a disaster recovery (DR) plan and Stand by Database.
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Continuous Performance monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Implemented Streams, Data Pump, Export & Import utilities on both 9i and 10g Databases.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented and Involved in Hot, Cold and Logical backup plans.
• Performed database cloning to setup test and development database.
• Migration of Database from 9.2.0.6 and to 10.2.0.2.
• Involved and Implemented Database migration from Oracle9i to Oracle 10g.
• Performed Database Administration activities such as Upgrades, Patches, TAR-Support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Proactive database monitoring using 10g grid monitoring tool.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Monitoring Stock Inventory levels and sales/invoice of various products using data modeling tool Erwin.
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Diagnose and troubleshoot Database problems and failures
• Written Korn, Perl, shell scripts for digitization the process.
• Load balancing, databases/schema/table re-organization for faster performance.
• Installation of Oracle version 10g on Solaris, HP-UX and AIX boxes.
• Database dot release upgrades using oracle universal installer and catpatch.sql
• Rebuilding of Indexes
• Conducting sizing & capacity planning for Oracle databases.
• Upgraded Discoverer Administrator from older version to new for administrative tasks and also applied most recent OLAP patches.
• Experience in reading Alert. Log and User trace Files and Diagnosing the Problem.
• Scheduling jobs through Oracle job Scheduler.
• Automation of Startup Shutdown on all Production and Development Database.
• Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Used TOAD tool for querying and troubleshooting PL/SQL queries and codes.
• 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 Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby Serves.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• Strong working experience in 24x7 Production database administration.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

Environment: Oracle Server 10g /9i, SQL, PL/SQL, Sun Solaris 9, HP-UX 11, Red Hat Linux 4.x

Confidential

Oracle DBA

Responsibilities:

• Implemented 2 node RAC Database on Linux Operatin System.
• Proficient with Standby Database, Data Guard and Replication.
• Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
• Installed and supported OEM on Linux.
• Create table spaces, tables, and users for custom applications.
• Implemented and worked Streams, Data Pump, Export and Import utilities.
• Implemented and Involved in local and downward streams.
• Implement Hot, Cold and RMAN backup plans.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Performed database cloning to setup test and development database on different operating systems.
• Refresh/Cloning of Database and applications for development, testing.
• Database patching using opatch.pl perl script.
• Upgrading development and production databases to Oracle 9i to 10g.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions).
• Experience in SQL tunning using STATSPACK, EXPLAIN PLAN and TKPROF.
• Data refresh from production to test and development.
• Installed and Configured Grid monitoring tool for Oracle 10g Database.
• Good knowlede of Developer Environment Setup, Support, Cloning and Refreshes.
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Diagnose and troubleshoot Database problems and failures.
• Conducting sizing & capacity planning for Oracle databases.
• Perform SQL tuning and assist developers with coding PL/SQL
• Performed PL/SQL querying and troubleshooting errors in queries using TOAD tool.
• Write Korn shell scripts to monitor and maintain the Oracle database.
• Write SQL scripts to monitor tablespaces and extent growth.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• Resolve various application failures due to data entry errors or system errors.
• Involves identifying problems and implementing corrective actions.
• Providing Solutions to the Problem Faced by end Users Or Programmers
• Automation of Startup Shutdown on all Production and Development Database.
• Worked with team to support 24x7 production environments.

Environment: HP-UX 11, Sun Solaris 2.8/2.9 RHEL 4.x, PL/SQL

Confidential

ORACLE DBA

Responsibilities:

• Responsible for administering and supporting production and development Oracle 9i databases.
• Installation of Oracle on Linux.
• Performed installations of Oracle 7x, 8i, 9i and SQL Server 2000 & 2005 databases.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Other duties include applying oracle database patches, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Instance cloning done to create test and environments.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Partitioned large tables to increase the performance.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them.
• Customization and development of Unix shell scripts and Perl Scripts.
• Good Experience tranfering files by using ftp, sftp, scp and pscp.
• Implemented and Involved in Partitioning strategies for very large tables.
• Diagnose and troubleshoot Database problems and failures
• Implementing range, list partitions, hash sub partitions.
• Creating and refreshing materialized views.
• Configured scripts to monitor activity with database.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle Server 8i/9i, SQL, PL/SQL, Linux/Unix, Solaris