SUMMARY

• 7+ years of experience as an Oracle Database Administrator. Extensive experience in working on 100% production support and On - Call support.
• Extensive experience in installing, configuring, monitoring and maintaining Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.
• Strong background noledge of installing and configuring Oracle 11g/10g R2 RAC (Real Applications Clusters) wif ASM and maintaining other Oracle database products on Sun Solaris, Red Hat Linux, IBM-AIX, Windows environments.
• Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (tablespaces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Solid experience on Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
• Expertise in Installation, maintenance, up gradation, administration, backup and recovery of Oracle RAC Databases.
• Experience in Real Application Cluster (RAC) environment wif Auto Storage Management (ASM) on Oracle 10g and 11gR1.
• Installed, Configured and maintained 2 Node 11gR2 RAC wif ASM production databases. Installed and Configured Oracle 10g RAC (3 node cluster), CRS using ASM.
• Migrated single instance databases to multinode 10g RAC environment for high availability and load balancing.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Upgrading databases to higher versions.
• Experienced in applying patches including Patchsets and CPU patches on Standalone, RAC and Standby Database.
• Administration experience in Very Large Multi Terabyte Databases (VLDB) environments.
• Extensive experience in Configuration of RMAN, Planning and scheduling Backups using RMAN, Hot Backups and Logical Backups, Oracle utilities and tools like OEM, Import-Export, Data Pump, and DBCA Installation, maintenance and tuning of RAC applications.
• Experience in implementing, configuring and managing Data Guard wif Physical Standby Databases for High availability configuration.
• Expertise in Oracle performance tuning using stats pack, tkprof, explain plan.
• Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, AWR (statspack) reports, ADDM, SQL Tuning Advisor, Oracle Enterprise Manager (OEM), Grid control.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Experience wif SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement teh business logic.
• Experienced in Oracle Support (raising SR) processes for technical requests through Metalink.
• Documentation of Oracle database operations and training of backup personnel.
• Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
• Participation in on-call (off hours) schedule in providing technical support.

TECHNICAL SKILLS

Operating Systems: HP-UX 11.x, Sun Solaris 9/10, IBM-AIX, RHEL 3.x/4.x/5.x, Windows 200x/Vista/XP/Prof.

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

Languages: SQL, PL/SQL, C, C++, JAVA, UNIX Shell Scripting.

Tools: RMAN, Oracle Enterprise Manager (OEM), Grid Control, SQL*Loader, Export/Import, Data pump export/import, TOAD, iSQL*PLUS.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Oracle DBA

RESPONSIBILITIES:

• Installation, Configuration, Designing and Maintaining of Oracle 11gr2 on AIX 6.1, HP-UX 11.11.
• Implemented High Availability solutions wif Oracle 11g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams.
• Strong in using tools such as PL/SQL developer, SQL*Loader, TOAD and SQL*Plus.
• Administering Oracle 11g/10g production, test, development environment on RHEL, IBM-AIX.
• Installed, Configured and maintained 2 Node 11g RAC wif ASM production databases. Installed and Configured Oracle 11g RAC (3 node cluster), CRS using ASM.
• Migrated 7TB 10.2.0.4 standalone database to 3 node RAC.
• Involved in fresh installation of 11.2.0.1 and 11.2.0.2 RAC databases on ASM and NFS file systems.
• Migrated oracle RAC databases from 10.2.0.4 to 11.2.0.2.
• RAC troubleshooting.
• Skilled in setting up/Installation and configuration of release 10g RAC R2 wif ASM and Raw Devices and 10g CRS.
• Excellent experience in cloning oracle databases for development and testing.
• Export/Import, Datapump to migrate database objects from one database to another.
• Recovery of Database (Recovering from Media Failure, Recovering teh tables dropped accidentally, Recovering data files, recovering from Block Corruption) using FLASHBACK RECOVERY and from previous RMAN, Hot, Cold and user managed backups.
• Experience wif data modeling, physical and logical database design.

Environment: RHEL, IBM-AIX, Oracle 11g/10g, RAC, ASM, RMAN, PL/SQL, UNIX scripting.

Confidential, Columbus, Ohio

Oracle DBA

RESPONSIBILITIES:

• Installation of Oracle software, administration of oracle 9i/10g production, test and development environments on RHEL, Sun Solaris platform.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
• ConfiguringData Guardto ensure high availability, data protection anddisaster recoveryfor enterprise data.
• Responsible for migrating 7TB 3 node RAC database from 10.2.0.4 to 11.2.0.2.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Database Restore using RMAN, Cold Backup, Export and Flash Recovery.
• Upgraded databases in production and development environments from 9.2.0.6 to 10.2.0.2 (Oracle 10gR2).
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data Guard.
• Monitoring and management of various database components (logical & physical) like tablespaces, segments (tables, extents, rollback), Users (granting /revoking privileges, roles, synonyms), creating and rebuilding teh indexes, database links Security User Management, Privileges, Roles, Auditing, Profiling, Autantication.
• Find solution and resolve critical issues wif Oracle Support.

Environment: RHEL, Sun Solaris, Oracle 10g, 9i, ASM, RMAN, SQL, PL/SQL, UNIX scripting.

Confidential, Dallas, TX

Oracle DBA

RESPONSIBILITIES:

• Worked as a team member for 24x7 supports inboth production and development environments.
• Installation and creation of 9i and 10g databases for Testing, Development and Production on IBM-AIX and Sun Solaris environment.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
• Experienced wif SRVCTL, OCR and Voting Disk of 10g RAC
• Configured teh Public Network/Private Interconnect for Oracle 10g RAC.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Database Restore using RMAN, Cold Backup and Export.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks like tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Analysis and management of Oracle problems/defects using SRs and/or Metalink wif Oracle
• Corporation and installation of patches.
• Experience wif SQL, PL/SQL coding, stored procedures, functions, packages, triggers. Created UNIX Shell scripts for different database tasks and export/import for data transfer. Creating primary database storage structures (tablespaces) once developers has designed an application.
• Perform other regular DBA activities including schema management, space management and performance monitoring.

Environment: IBM-AIX, Sun Solaris, Oracle 10g, 9i, RMAN, ASM, SQL, PL/SQL, UNIX Shell scripting.

Confidential

Oracle DBA

RESPONSIBILITIES:

• Configured Oracle 9i/10g RAC.
• Installed, configured and administered Automatic Storage Management (ASM).
• Applied patches to teh existing versions of Oracle.
• Developed Environments setup using database cloning and refresh procedures.
• Provided Oracle DBA support included Oracle database installation, upgrades, instance configuration, tuning, schema maintenance, troubleshooting and production monitoring.
• Coordinated and Assisted in Database up gradation from 9i to 10g Release 2.
• Upgraded databases in production and development environments from 8i to Oracle 9i.
• Setting and maintaining user accounts, granting required privileges and roles to users.
• Implement periodic Hot, Cold and Logical backup plans, RMAN backups.
• Tuning teh database for optimal performance.
• Handling day to day activities along wif schema and space management.
• Creating primary database storage structures (tablespaces, datafiles, tables, indexes etc).
• 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 teh Database storage and day to day activities.
• Partitioned large tables to increase teh performance.
• Performing all daily maintenance tasks. Interacting wif oracle customer service as and when required.
• Implementing automated backups wif RMAN using crontabs.
• Providing support to end users and developers.

Environment: HP-UX, IBM-AIX, Oracle 9i/8i, RMAN, SQL, PL/SQL, UNIX Shell scripting.

Confidential

Oracle PL/SQL Developer

RESPONSIBILITIES:

• Involved in teh analysis, design, build, and testing phase of teh life cycle for teh project.
• Developed PL/SQL packages to capture end of day transactions.
• Implemented UTL HTTP oracle built in package to acquire data from external websites.
• Involved in designing teh database, identification of teh objects and creating tables.
• Latest features of Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets, Cube, Rollup has been used to improve teh performance and reduce IO.
• Preparation of design specifications document.
• Wrote scripts for Loading Data using SQL * Loader and Import/Export Assisting teh developers in tuning teh SQL for optimized performance.
• Making changes for teh existing shell scripts as per teh needs.
• Extensively used Explicit Cursors in stored procedures.
• Developed PL/SQL scripts for exception handling.

Environment: RHEL, Windows, Oracle 8i, SQL, PL/SQL, UNIX Shell scripting.