SUMMARY

• Highly Motivated ITIL certified oracle DBA with over 9+ years of experience in Oracle 9i/10g/11g Database Administration and Oracle Applications on Production, Development and Test Databases including Disaster Recovery, High Availability Solutions (RAC & Data Guard) and Backup & Recovery (RMAN).
• Installation, patching, updates, configuration maintenance of Oracle 10g RAC, 11g RAC, Standby Databases (Data - Guard) on Sun Solaris, Linux, UNIX and Windows platforms.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Management of schemas, objects & Partitioning the tables & indexes.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM and OEM Grid Monitoring.
• Experienced in using Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Experience in cloning the oracle homes and upgrades. Working experience on database 10g, 11g upgrades.
• Excellent knowledge in user management, roles, profiles. Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases. Excellent knowledge in Backups and Recovery and Cloning of databases using RMAN.
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM). Grid Control for maintaining many databases together on separate servers
• Experience in SQL server administration and maintenance.
• Experience as On-Call 24x7 production DBA support, application/development DBA, system Storage Management (ASM).
• Expertise in Installing and configuring ASM and RAC for high availability databases
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM)
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Solid experience on Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Database Migration & Up gradation from 9i/10g to 11g (Exadata X2 and X3)
• Excellent team player and works independently, actively participates in team meetings and maintains good relations with everyone on the team and other teams
• Provided 24x7 production support for oracle 11g/10g/9i databases on Linux /UNIX platforms.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc.) by using tools/utilities by Automated Workload Repository (AWR), automatic Database Diagnostics Monitor (ADDM), Explain Plan, Auto trace, TKPROF and Stats pack. Experience Installing, Configuring and Managing oracle 11gR2 with GRID INFRASTRUCTURE on ASM for High availability
• Troubleshooting the database performance issues by analyzing Automated Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostics Monitor (ADDM) reports.
• Worked with the System Administrators in planning storage requirements for all environments related to the project, manage and monitor storage usage.
• Migrated Oracle 10gR2 (10.2.0.3 and 10.2.0.5) databases running on Red Hat Enterprise Linux 5 to Oracle 11gR2 (11.2.0.3) running on Red Hat Enterprise Linux6.
• Setup scripts for daily RMAN backups, including weekly full backup, and daily incremental backups.
• Installed and configured Oracle Cluster ware and Database Software 10.2.0.4 on Sun Servers; Install and upgrade Oracle software using OFA structures, Applying patches and bug fixes.
• Build/Repair Standby databases/Data Guard using RMAN restore and duplicate command.
• Performed Oracle Database Cloning from Production to Test and Development databases as per client requirements.
• Actively involved in validation of the data files using DB Verify Utility. In order to solve Block corruption Errors.
• Proactive database monitoring, administration and maintenance of 10g and 11G database.
• Applied PSU, CPU, Patch set and one off patches to RAC, ASM and databases.
• Worked on Database cloning using RMAN duplicate database.
• Cloned on databases using different methods including RMAN, exp/imp and data pump.
• Very good knowledge on Database Views and Dictionary Tables.
• Very familiar with TOAD and SQL Developer.Knowledge of new features in 11gR2, like Omotion, RAC-One Node and replication using Oracle Golden Gate
• Experience on handling databases sized 800 GB to a max of 5.8 tb.
• Having experience in performance tuning issues using AWR and ADDM Reports.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP
• Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and Virtual IP Configuration Assistant (VIPCA).
• Worked on different types of storage structures (SAN/NAS).
• Extensive performance tuning experience, SQL Tuning, Database/Instance Tuning.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, Statspack, SQL Trace, AWR, ADDM, OEM Grid Control custom scripts troubleshooting Oracle databases using SQL trace utilities.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, buffer cache, redo mechanisms.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures
• Experienced in database migration across platforms using transportable tablespaces and RMAN

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, Java, Unix Shell Scripting.

Tuning Tools: TKPROF, Explain Plan, Statspack, AWR, ADDM, Grid Control Tuning advisors

Databases: Oracle 8i/9i/10g/11g, Oracle 10g RAC, Oracle 11g RAC

Operating Systems: HP-UX 10.x/11.x, Sun Solaris 2.5/2.6/8/9/10 , AIX 5.1/5.2/5.3/6.1 , Red Hat Linux RHEL 2.1/3.x/4.x/5.x, OEL, MS Windows 95/98/ME/NT/2000/XP/ 2003/2005/2008

Monitoring & Administration: Oracle Grid Control, OEM, Spotlight, OGG

Development Tools: TOAD, SQL Plus, SQL Developer, RMAN, SQL*Loader, EXP, IMP, DataPump (expdp,impdp), VMware, Informatica, Putty

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Senior Oracle DBA Consultant

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11g RAC databases including ASM and CRS
• Performed upgrades from Oracle 10g to 11g and applied patches
• 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 in AES encryption in oracle 10g and 11g by using DBMS Crypto package.
• Upgrade databases from Oracle 9i to 10g, 9i to 11g, 10g to 11g (Exadata X3)
• 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, OCR and Voting Disk of 10g, 11g RAC.
• Involved & performed Production Change Requests for PRD major DB changes.
• New DB creation, Existing DB deletion, various DB Housekeeping activities
• Experience with SAP application using with BR tools.
• Implemented 10g 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
• Worked on re-hosting existing legacy databases to new and Exadata(Linux) databases.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Apparently perform SQL tuning and baseline tuning. Experience Flash back.
• Using with BR tools taking backups and adding space and re-organizing table spaces in SAP application.
• 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 providing Real time data feeds, heterogeity and transactional integrity by using Golden Gate.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Experience in Data Migration Working with Oracle 10g and 11g.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Experience in implement a variety of solutions for improving the availability, accessibility, performance, and integration of critical data across the enterprise with Golden Gate.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Experience to Continuous availability and disaster tolerance of critical data systems is more than “after-the-fact” data recovery by using Golden Gate.
• Experience in quality support and delivery to the end-user
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules) and Loaded data into Database using external tables
• Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN

Environment: SunSparcSolaris64bit, IBM AIX and Red hat Linux, Oracle Database Server 10g/11g, Golden Gate, TOAD, PL/SQL, BR tools

Confidential

Oracle DBA/Off-shore Lead

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11g RAC databases including ASM and CRS
• Performed upgrades from Oracle 10g to 11g and applied patches
• 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 in AES encryption in oracle 10g and 11g by using DBMS Crypto package.
• 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, OCR and Voting Disk of 10g, 11g RAC.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities and Implemented 10g 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, 24x7 production support.
• Apparently perform SQL tuning and baseline tuning. Experience Flash back
• 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 Clusterware and Oracle Data Guard setup done for RAC, Installation of Oracle 10g management agent and grid control
• Experience in providing Real time data feeds, heterogeity and transactional integrity by using Golden Gate.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Experience in Data Migration Working with Oracle 10g and 11g.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Experience in implement a variety of solutions for improving the availability, accessibility, performance, and integration of critical data across the enterprise with Golden Gate.
• Extensively used PL/SQL for designingpackages, stored procedures, functionsand databasetriggers.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Experience to Continuous availability and disaster tolerance of critical data systems is more than “after-the-fact” data recovery by using Golden Gate.
• Experience in quality support and delivery to the end-user.
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules) and Loaded data into Database using external tables
• Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN

Environment: IBM-AIX, SunSparcSolaris64bit, and Redhat Linux, Oracle Database Server 10g/11g,Golden Gate, TOAD, PL/SQL

Confidential

Database Administrator (DBA)

Responsibilities:

• Maintaining ERP IFS Application. Giving project access rights to the application users.
• Maintaining Oracle databases working for IFS application
• Implemented and supported 11gR2 RAC with ASM on OEL 5.7
• Working on Oracle database related tickets (iServe)
• Refreshing test / dev databases using RMAN backup
• Configuring RMAN backups
• Monitoring databases through OEM grid control
• Daily backups checking
• Re-Org databases on regular intervals
• Installing & Configuring Oracle in new servers remotely
• Working with iLo & Xmanager while installing Oracle on new Linux servers
• Disaster Recovery planning, configuration & maintenance
• Configured Oracle GoldenGate (11.2.1.0.1 ) for table level replication
• Administering oracle 10gR2 RAC database
• IFS Server & Client application installation.Configuring / Installing WEB module.
• Deploying presentation objects in application.
• Applying BUG Fixing / Report patches to application. Cloning the database on regular intervals.
• Granting roles & privileges to the Oracle users.
• Maintaining UAT database.Taking RMAN & Export backup every day.
• Periodic trimming of log files.
• Database space management.
• Periodic Re-Organizing of Database.
• Evaluating & Enhancing performance of database by analyzing AWR & ADDM reports.
• Monitoring database activity through Oracle enterprise manager and killing any hanging sessions.
• Reducing the wait events by distributing IO across various physical disks (Getting input through monitoring OEM continuously at heavy business hours)
• Identifying Resource Intensive SQL Queries and Give them to Development Team to TUNE the SQL Queries.
• Rebuilding unbalanced indexes.Compiling invalid objects after patch deployment.
• Pasting new EXEs’ in CITRIX presentation server.

Environment: Windows 2003.

Confidential

Senior DBA

Responsibilities:

• Installation of Oracle 9i windows.Patch up-gradation from 9.2.0.1.0 to 9.2.0.8.0.
• Maintaining Oracle 10g database on Solaries5.0
• Checking DR database.
• Configured DataGuard using rman backup
• Monitoring the Datagaurd to synchronize with Production Database.
• Switchover of Physical standby database for role changing in order to do routine maintenance on Primary database.
• Ensuring Health of Database by Monitoring alert log and Archive Generation.
• Sizing of database, space management (Sizing of tables, indexes, rollback segments & tablespaces).
• Generating statspack report weekly once.
• Export,Import & Rman backups.
• Analyzing tables of database daily, weekly basis.

Environment: Solaris 9, Windows 2003, Putty, VNC, WinSCP