SUMMARY

• Around 8 years’ experience in supporting and administering large databases in Oracle 10g/11gr2 RAC, ASM, Data Guard environments.
• Handled many databases Confidential a time from size ranging 5 GB to 22 TB.
• Installed, Configured, Managed Oracle 8i, 9i, 10g, 11g databases in ASM, Grid Control, Oracle Enterprise Manager, RMAN environment.
• Expertise in installing, building, configuring, managing, upgrading and patching and troubleshooting oracle databases in different OS like HP - UX, Sun Solaris, Linux, AIX, Windows.
• Good hands on in setup & administration of 10g, 11g RAC etc.
• Experienced in Upgrade of Oracle database to 11g and also Migration to cross platform.
• Well versed and Hands-on experience on the latest features of Oracle 11g such as Flashback, Compression, Active standby, Partitioning etc.
• Setup and maintained Physical Standby in Oracle 10g/11g.
• Expertise in Refresh/ Cloning/export-import of the production database over to Dev., QA for them to be in sync for testing.
• Planning, designing and configuring the Backup and Recovery strategy for the Client. Extensive experience in performing Cold, Hot, Full and incremental backups using RMAN.
• Performance Tuning and optimizing database parameter, Load balancing, PL Sql scripts using AWR, ADDM, ASH, STATSPACK, Explain Plan statistics, OEM, TOAD etc.
• Developed Korn/Bash shell and PL/Sql scripts for implementing packages, procedures, triggers etc. for automating daily activities as well as easy maintenance of Oracle through cronjobs.
• Maintained RAC database with 2-12 nodes and understand its underlying architecture. Have proficient knowledge of ASM instance and the maintenance of ASM disk groups and disk space.
• Disaster Recovery & Business Continuity Plans: Conducting business impact analyses, identify controls, develop recovery strategy, Plan testing, training and user awareness as well as plan review and maintenance for development of business continuity and disaster recovery plans.

TECHNICAL SKILLS

Oracle RDBMS: Oracle Enterprise 8i, 9i, 10g Release 1, 2; 11g Release 1, 2.

Operating Systems: UNIX Solaris 8/9/10, Enterprise Linux 4.x/5.x, Windows Server 2003, 2008, Windows NT/XP/VISTA/7/8.

Scripting/Programming: Korn shell scripting, Bourne shell, Windows Batch, SQL, PL/SQL.

Data Tools: RMAN, Oracle RAC, ASM, SQL Loader, Flashback, Data Pump, Data Guard, EXPDP Export Import, LSNTCTL, Real Application Testing, Golden Gate.

Data Utilities: TKPROF, SQL TRACE, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM GRID CONTROL, REAL APPLICATION TESTING (RAT), ULTDTREE, TDE

Software: Oracle Enterprise Manager Grid Control and Cloud Control 10g, 11g, 12c, SQL Navigator, Toad, PuTTy, Cygwin, MS Visio, Erwin, SVN, Sharepoint.

PROFESSIONAL EXPERIENCE

Confidential, Groton, CT

Oracle DBA

Responsibilities:

• Managed multiple databases on both RAC and standalone database on Linux with Data Guard.
• Worked on OLTP as well as Data Warehouse Environment.
• Majorly contributed in data migration from legacy system to new system from Dev, Trainee, Test and Stage to Production along with production support.
• Managed and monitored database using cloud control 12c.
• Worked on Utilities like utldtree to deepest levels to help client understand and represented the object dependencies between legacy system and new generation system on their one of the broken environment which is now up and running.
• Helped client with comparing schema with humongous numerous objects using TOAD. Generate sync scripts to pull the missing objects from golden copy environment, drop unnecessary objects and bring differing objects in sync with each other while taking care of special characters and need of the environment while maintaining track of roles and privileges.
• Worked closely with SVN & Erwin forward engineering and reverse engineering to standardize the process and maintaining the centralized repository as the golden copy for DB objects for future reference.
• Helped with performance improvement by providing suggestion while configuring new environment with parameters such as DB block size, parallelism. Similarly did database objects optimization such as materialized views, views, sequences, audit, predicate, optimizer hints.
• Created sequence of scripts as per the all the object’s multilevel dependencies so that single script can create all the DB objects without returning any compilation error.
• Worked and suggested different stats gather strategies as well as released the cpu overhead by making changes to the user created daily jobs.
• Planned, scheduled logical backup using datapump or export/import for migration.
• Helped client understand DB & session monitoring using toad and many features of it so as to make his life easy.
• Checked tablespace level as well as table level TDE while performing RMAN backup to protect finance data. Revised DB links, DB objects, DB roles and DB users which were public or had lavish privileges and changed them as per the policy.
• Strictly followed the rules for SOX trigger for migrations over production.
• Implemented dbms rls package for fine grained access control over OVD.
• Helped DBAs and standardize the datafile size in lower version of database i.e. 10G.
• Resolved numerous performance issues like temp tablespace with unable to release space after large sorts, top wait events, sub-optimal execution plans, outdated statistics, data fragmentation, latch contention, CPU constraints, physical & logical I/O, disk usage, query optimization, hard/soft parsing by application tuning, disk I/O and memory tuning.
• Greatly helped reducing run time for problematic Sqls by using AWR, TOAD, OEM, Explain plan, also suggested guidelines for creating AD-HOC BO & Spotfire reports.
• Suggested TA team for upgrading to 11R2 for the environment which are still on 10G.
• Performed RCA and also raised SR severe 1 whenever necessary and took follow ups.

Environment: Oracle 11gR2 & 10g, RAC 11g, RHEL, OEM Grid Control & Cloud Control (10g,11g, 12c), RMAN, ASM, CRS, Export/Import, SQL, PL/SQL, TOAD V12, AWR, ASH, ADDM and DB Artisan, Informatica, BO, SPOTFIRE, Erwin, Sharepoint.

Confidential, Columbus, IN

Oracle DBA (Performance tuning + Apps DBA)

Responsibilities:

• Managed multiple databases on both RAC 4 node and standalone database on Linux.
• Worked specially on Data Warehouse Environment.
• Helped performance improvement for OBIEE reports from Database side.
• Worked and suggested different stats gather strategies for 2TB sized schemas
• Planned, scheduled logical backup using datapump or export/import. created reboot/maintenance calendar and published
• Created, published and implemented quarterly capacity plan
• Planned and coordinated multiple EDW production environment downtimes including Database, Informatica, Golden Gate and OBIEE servers.
• Supported, Monitored and troubleshot Golden Gate.
• Implemented tablespace level as well as table level TDE while performing RMAN backup to protect finance data.
• Implementation of HA EM12c installation for multi-site redundancy
• Strictly followed the rules for SOX trigger for migrations over production.
• Implemented dbms rls package for fine grained access control over OVD.
• Helped resolving problem of transferring 3TB of data across multiple data centres located across different locations.
• Suggested TA team to Implemented RMAN compression.
• Resolved numerous performance issues like top wait events, sub-optimal execution plans, outdated statistics, data fragmentation, latch contention, CPU constraints, physical & logical I/O, disk usage, query optimization, hard/soft parsing by application tuning, disk I/O and memory tuning.
• Installed OSWATCHER.
• Helped estimating SGA, PGA, REDO sizes.
• Provided support for Oracle Apps including EBS/ERP 12 and 11i suite
• Proactivity deployed script which lists reporting sqls running over 30 minutes and shoots an email to Support team ( Obiee Team & Informatica team )
• Greatly helped reducing run time for problematic Sqls by using AWR, TOAD, OEM, Explain plan, also suggested guidelines for creating AD-HOC reports.
• Diagnosed Oracle bugs and coordinated with oracle support to resolve them in timely manner and applied patch sets to make application environment up-to-date.
• Suggested TA team for upgrading to 11.2.0.3 and took follow ups.
• Used incident and problem management system to deliver high performance IT service and customer care service.
• Performed RCA and also raised SR severe 1 whenever necessary and took follow ups.

Environment: Oracle 11g, RAC 11g, RHEL, IBM-AIX, OEM Grid Control & Cloud Control (10g,11g, 12c), RMAN, ASM, CRS, Export/Import, SQL, PL/SQL, TOAD, AWR, ASH, ADDM and DB Artisan, OBIEE, Golden Gate, Informatica, Remedy.

Confidential, BRIDGETON, MO

Senior oracle DBA

Responsibilities:

• Managed multiple databases on both RAC and standalone database on Linux
• Successfully migrated several QA/test, staging and multi-tera byte production 9i/10g HP/Solaris DB to oracle 11gr2 DB using RMAN TTS on Linux and documented migration procedures
• Managed and updated several automated Unix scripts used for the migration project to expedite the migration process with minimal manual intervention
• Resolved numerous performance issues like top wait events, sub-optimal execution plans, outdated statistics, data fragmentation, latch contention, CPU constraints, physical & logical I/O, disk usage, query optimization, hard/soft parsing by application tuning, disk I/O and memory tuning.
• Planned and scheduled physical (hot/cold) backups, logical (import/ export, data pump) backups, and incremental backups using RMAN on daily, weekly and monthly basis.
• Performed troubleshooting duties on Oracle production databases and determined RCA (Root Cause Analysis) and resolved known issues
• Handled performance tuning and application monitoring with Quest TOAD, Oracle enterprise manager, AWR and Explain plan and greatly reduced execution times of several problematic queries.
• Supported, Monitored and troubleshot Golden Gate.
• Applied quarterly CPU and PSU patches to over 100 mission critical databases
• Diagnosed Oracle bugs and coordinated with oracle support to resolve them in timely manner and applied patch sets to make application environment up-to-date.
• Involved with streams administration for data replication purposes.
• Provided support for Oracle Apps including EBS/ERP 12 and 11i suite
• Supported SAP and Sharepoint application from database perspective.
• Used remedy system for managing incidents and problems and strictly followed the SLA to meet best customer care experiences.
• Developed fully optimized SQL and PL/SQL scripts that successfully assisted with timely offloading of reporting data and analytical data

Environment: Linux, HP, Windows XP, 9i, 10g, 11gr2, Dbconsole, Grid control, Dataguard, VERITAS cluster, Golden Gate, streams.

Confidential, PLEASANTON, CA

Oracle (RAC) DBA

Responsibilities:

• Successfully installed and configured several oracle 11gr2 RAC on Linux platforms
• Successfully upgraded several 10gr2 RAC databases to 11gr2 RAC databases
• Developed physical and logical designs for databases and implemented effective capacity planning procedures in both development and production environment
• Co-ordinated and implemented quarterly CPU & PSU patches
• Employed 10g data guard broker to configure and manage the primary database with two physical standby databases
• Developed and implemented Unix shell scripts, Kron scripts and crontab jobs to automate daily tasks including backups, exports/Imports, monitoring tablespace growth, gathering CBO statistics, analyzing tables and indexes, trimming the alert log files, monitor backup logs and monitor the alert logs for errors.
• Managed and maintained several partitioned tables and maintained associated global and local index
• Diagnosed and resolved clusterware, ASM, interconnect and RAC related performance issues using v$GC views, oswatcher and AWR reports
• Performed data replication using materialized view (Snapshot) and Oracle streams for table level, schema level replication and transferred data in unidirectional and bidirectional by checking with data Synchronization and no latency.
• Developed several PL/SQL functions and stored procedures and triggers
• Provided support for Oracle Apps including EBS/ERP 12 and 11i suite
• Provided 24*7 oncall support for all production databases
• Performed several database cloning from production to test/staging using RMAN duplicate. RMAN and sqlbacktrack were also used for backup/recovery

Environment: AIX, HP, Linux, Windows XP, Oracle 9i,10g,11gr2, sqlbacktrack, Dbconsole, grid control, Dataguard, VERITAS cluster

Confidential, BERKELEY HEIGHTS, NJ

Oracle (RAC) DBA

Responsibilities:

• Successfully completed cross platform oracle 10gdatabase migration from 32bit Solaris to 64bit Linux
• Successfully installed and managed oracle real application clusters (RAC10g) on a 4 node Linux cluster using Oracle cluster file system (O.C.F.S) and automatic storage management (ASM).
• Successfully installed, configured and deployed oracle applications express 3.1 for managing database infrastructure such as users, servers, passwords and applications.
• Diagnosed and resolved clusterware, ASM and database issues with all new RAC installations
• Migrated non-RAC 10g oracle databases to instances to 11g release 1
• Implemented key RMAN 10g new features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals
• Worked extensively on identifying high load SQL queries and troubleshooting to find underlying causes and took appropriate actions to improve performance.
• Involved in partition administration: creating, managing, pruning, merging, global and local index management
• Reviewed automated workload repository (AWR) and automatic database diagnostics monitor (ADDM) report for proactive performance tuning & monitoring
• Recovered database from media failure, accidentally dropped tables, missing data files and block corruption using flashback recovery and from previous RMAN backups.
• Applied multiple patches and patch sets, CPU and PSU to over 300 oracle test, staging and production databases in Linux and Solaris
• Communicated and coordinated with oracle support regarding major database issues and applied required patches on unit test/ system test and rolled out and implemented patches into production
• Provided 24x7 on-call supports

Environment: Windows 2003 server, Linux, Solaris Sunsparc, oracle 10g, 10g Grid, 10g RDBMS, Vista

Confidential

Oracle DBA (Level 1 support)

Responsibilities:

• Handled more than 300+ Oracle & SQL Server databases which were running on all flavors of UNIX and Windows.
• Installed, Configured, Patched and Administered Oracle databases on Prod/Test/Dev. environment.
• Solely applied Oracle patches to 300+ databases across the US region.
• Upgraded/Migrated the database to 10g & 11g on same as well on cross platform using Transport tablespace.
• Day to day monitoring like availability of system, databases, listener, checking Alert log, Trace files for oracle errors.
• Installed and supported 2 node 10g/11g RAC on Linux and ASM. Migrated single instance into RAC. Converted NON-ASM database into ASM.
• Configured and managed the Physical standby database for critical production databases.
• Implemented the Oracle Grid control (OEM) to monitor the databases and other targets.
• Planned the Backup & Recovery procedures. Changed the setup of RMAN backups from disk to tape for all the databases. Restored, Cloned the database as and when needed.
• Tuned the database, memory structure, database parameters, SQL queries, PL/Sql script using the metrics received either from AWR, STATSPACK report or through Users input.
• Developed and updated existing shell script to automate the daily processes using cronjobs.
• Provided on-call support for 24x7 operation including late night maintenance activities.
• Part of the Data center migration team to consolidate all the data center into one location.
• Coordinate and mentor the offshore team to guide them to complete the request.

Environment: Oracle 8i/9i/10g/11g, RAC, OEM 11g, SQL Server, HP-UX, AIX, Sun Solaris, Linux

Confidential

Oracle Database Administrator (Level 1 & 2 Support)

Responsibilities:

• Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production Support of Oracle 10g, and RAC (10g) databases on LINUX and AIX.
• Involved in performing migration from Oracle 8i to 10.2.0.4 database.
• Implemented ASM on RAC. Managing disks and disk groups with ASM.
• 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 RAC.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion 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 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 Confidential different levels, rebuilding indexes and for purging as well.
• Additionally part of rotation on call DBA to support Production databases 24X7.

Environment: Oracle 10g, RAC 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.