SUMMARY: Extremely strong and superb in Oracle DBA and Oracle e-Business suite systems management.
18+ years experience in Oracle Database Administration: architecture design, development, production support, performance tuning, backup and recovery, system analysis and testing.
14+ years experience in Oracle 11i & R12 including systems administration.

CERTIFICATE: Oracle Certified 10g DBA (OCP 10g)
Oracle RAC 10g Certified (OCP 10g RAC)
Oracle 11g Certified Professional (OCP 11g)
Oracle 11g RAC Certified DBA (OCP 11gRAC)
ITIL V3

SKILLS: Software: Oracle Database (6.5 - 11gR2 including RAC, ASM, Dataguard), RMAN) ,
Oracle Applications 10.7..R12.1.3, Oracle Enterprise manager and Grid control
(Including 12c), Oracle Application Server 10gAS; Oracle Single Sign on
(SSO), Oracle GRC including CCG and PCG, SOA, BPEL, OBIEE,CAMLI,
, TOAD, Compu-search PRISM , Sunflower, Oracle De-mantra , Oracle UPK
Language: SQL, PL/SQL (Triggers, Store Procedures, Functions), UNIX shell scripting
System: LINUX, IBM AIX, Sun Solaris , HP-UX, Windows

EXPERIENCE:

04/12 - 11/12 Lead Oracle Apps DBA , Confidential

This was upgrade project for IBM. Client decided to move their production and non production instances from existing servers to new servers. As a lead DBA my responsibilities were to build servers (RHL 5.5) with Unix administrators (rpm, system configurations, Shared file system etc.), Install 10gR2 Cluster-ware and ASM, Appl PSU and CPU patches on 10g, Upgrade Oracle EBS from R12.0.6 to R12.1.3, Clone Oracle EBS env (RAC-RAC and RAC-Non-RAC), Create physical standby database using data guard, activate standby database, perform backups using RMAN, Post go live support.

04/08 - 04/12 Lead Oracle Applications DBA, Confidential

• Lead efforts in resolving daily issues in Development , Test and Production and in many other environments related with SSO, SOA, OBIEE and Oracle RAC environments.
• Cloning Oracle Databases from RAC - RAC and RAC-Non-RAC and Oracle EBS (11i/R12) including ASCP environments
• Upgrading Oracle EBS from 115102 to R12.1.3
• Upgrade Oracle Apps (FIN) from R12.0.6 to R12.13 (4 node apps server and 2 node RAC)
• Applying Oracle Applications and database patches using time saving techniques
• Migrating Oracle Databases from Data centers and upgrading apps to R12.1.3 , enabling RAC and implementing SSL, Load Balancer and Parallel Concurrent Processing
• Restoring and recovering RAC databases, performing database administration on RAC Non-RAC databases, including database backup configuration using RMAN.
• Upgrading Grid control from 11.x to 12c
• Installation and configuration of SOA HA and Infrastructure HA databases with multiple Application and database tier.
• Identifying resource intensive SQLS and help development team to provide tuning solutions
• Upgrade clusterware and ASM from 10204 to 11gR2, Grid
• Database management related with clusterware, ASM and RAC
• Building physical standby database and as an when required converting into snapshot standby or activating standby database after restore point for Fail over test and then restoring upto restore points.
• Configuring standby database in grid control and converting into max. available mode.
• Migrate OCR and vote disk from raw disk to ASM
• Installation and upgrade of Oracle GRC, TCG and PCG
• Perform Pre- and Post- Oracle EBS clones tasks.
• Develop procedures and scripts to synchronize cloned EBS environment with existing OID.
• Upgrade database from 10g to 11g. Apply patches.
• Upgrading grid control from 10.2.0.3 to 10.2.0.5 and applying Application Management patches
• Install and configure Oracle Grid control , upgrade Grid database to 11G R2 , upgrade OMS from 11.2.0.5
• Identify i-proc related issue from PRISM to EBS
• Fix issue after clone for Sunflower and PRISM
• Upgrade patches and software update for PRISM and sunflower.
• Installed and upgrade cluster ware from 11.1.0.6 to 11.1.0.7
• Configuring RMAN and implementing in Grid control for scheduled backups
• Applying PSU/CPU patches to RAC and non-RAC systems using rolling techniques
• Perform code migrations. Work with Oracle Support to resolve technical issues.
• Participate in daily and weekend support rotations. Provide daily instance status report to project management team.
• Provide technical information to project management team.
• Develop SQL scripts for various diagnostic, reporting purposes.

06/07 - 04/08 Senior Oracle Applications DBA, Confidential,Teaneck, NJ

Support and maintain Oracle eBusiness (11i & R12) Financial production environments.

• Install and configure Oracle 10g RAC on LINUX.
• Install and configure 10g ASM on LINUX.
• Convert single node database to multi-node RAC with ASM storage on LINUX.
• Clone production 3 nodes RAC databases to 2 nodes test and single node development databases.
• Create and maintain production standby databases on 2 nodes RAC with ASM storage.
• Apply database and applications patches with OPatch and adpatch respectively.
• Upgrade Oracle EBS from 11.5.10.2 to R12.0.4
• Diagnose performance issues.
• Production code control and migration.
• Setup RMAN backup procedure.
• Install and configure OEM Grid control.
• Setup parallel concurrent process.
• Create Physical Standby Database using grid control

04/06 - 06/07 Senior Oracle Applications DBA, Confidential, Parsippany, NJ

Oracle 11.5.10.2 upgrade, Oracle 10g RDBMS upgrade, BCV backup, Big IP Load Balance, Reverse proxy with DMZ, OEM GRID, UNIX shell scripting, Oracle Financial, Oracle HRMS, ORACLE CRM.

• Support 11.5.10.2 HRMS implementation using oracle database 9i and 10g
• Upgrade Oracle databases from 9i to 10g
• Upgrade Oracle EBS from 11.5.10.2 to R12.0.0 (Base)
• Support Oracle Applications 11.5.10.2 production environment.
• Installed and configure OEM 10g GRID management server, OEM agent and Oracle Applications plug-in.
• Cloned Oracle Application from BCV backup using Rapid Clone.
• Performed code migration; Worked closely with development team for any functional/technical issues.
• Upgraded Oracle Applications to 11.5.10.2; Applied HRMS and Latin Spanish and Brazilian Portuguese language patches.
• Implemented OATM.
• Developed procedure to implement Shared File System.

02/04 - 04/06 Sr. Principal Consultant,Confidential,West Caldwell, NJ

As performance tuning specialist, improve performance of 3TB ERP production system. ERP modules implemented: Oracle Financial, Order management, Inventory, Services, Advanced Scheduling and Planning, etc.

• Performance tuning, identify application and system bottlenecks, provide solutions. Ensure report instance clone from production completes before 7:30 AM every weekday morning.
• Production system support: resolve IT tickets, perform system maintenance tasks, apply patches, and interact with Oracle Support.
• Support development efforts; participate in code review, provide performance improvement recommendations.
• Engaging in Oracle Applications R12 upgrade project.

4/03 - 12/04 Lead Oracle Database Administrator, Confidential,NJ

Implement e-Business suite11.5.7 Oracle Financials, Projects, Manufacturing, HRMS, Sales, Service, Service Contract, Installed Base, etc. modules on Sun Solaris server
Design and implement Subaru Window Sticker system using Oracle 10.2 database, 10gAS R2 Application Server, flashback database and failover with DataGuard
Upgrade from 11.579 to 11.5.10.2; Database upgrade from 9.2.0.6 to 10.2.0.2
RMAN, OEM Grid, UNIX scripting

• Oracle Applications 11i production support. Production database size: >600GB.
• Support 3 development and testing environments all with database size over 600 GB.
• Install, upgrade, patch, and clone Oracle Applications 11i for various development and testing purposes.
• Install and configure Oracle database and Oracle Application Server software.
• Upgrade Oracle RDBMS server to 10.2.
• Performance tuning using STATSPACK, SQL Trace, Explain Plan, OEM etc.
• Trouble shooting, working with Oracle Support to resolve applications and database issues.
• Monitor applications using OEM with management server and OAM.
• Database backup using RMAN via OEM.
• Develop server scripts to automate routine activities.
• Interact with UNIX administrator for server requirements; interact with developers and users during error investigation. Report project status to senior management.

05/02 - 04/03Sr. DBA , Confidential

Oracle Applications R11i DBA / Oracle 11i Systems DBA

• Install, configure Oracle Applications Release 11i (11.5.7) in single and two nodes setup.
• Maintain seven (7) applications instances for development, QA testing and production.
• Upgrade RDBMS to Oracle 9i.
• Applications cloning using auto-config , database sizing, performance tuning.
• Investigate errors, apply patches using AD utilities.
• Shell scripting. Develop deployment scripts.
• Provide support to development teams. Trouble shooting for developers.Install, configure Oracle Applications Release 11 using three-tier configuration.
• Install Oracle Applications R11 patchsets.
• Clone Oracle Applications for various testing purposes.
• Configure and setup WorkFlow Mailer. Develop shell script to automatically startup and shutdown mailer.
• Post go-live production support.
• Support development: develop PL/SQL packages, procedures, functions, and triggers.
• Design staging tables and developed PL/SQL procedures and functions to load setup data into Oracle Applications in batch mode. Review and debug codes for developers. Reverse engineer database schema objects using Erwin.
• Tune Oracle database to accommodate large Internet user population.
• Using SQL Loader, load flat files into Oracle database.
• Develop UNIX startup and shutdown script.
• Develop backups and recovery plans.
• Maintain eight(8) Oracle Applications instances.

06/1997 - 05/02 Confidential

• Install Oracle Enterprise software: Oracle8, Oracle7.
• Physical and logical database design. Upgrade Oracle database to higher version.
• Design database backup, recovery and archiving strategies.
• Create Oracle symmetric replications.
• Database performance tuning.
• Develop UNIX shell scripts to execute database jobs. PL/SQL scripting. Assist developers in developing new database applications.
• Participated in the development, deployment and system configuration of Merck Worldwide Procurement Reporting System (WPRS), Quality Control Abnormality Tracking System, IT Customer Service (Vantive) database upgrade, migration and consolidation of Merck Manufacture Production databases.
• Develop UNIX shell scripts to execute database jobs. PL/SQL scripting. Assist developers in developing new database applications.
• Maintain and monitor over 30 production database systems using Oracle Enterprise Manager. Coordinate with system administrators and users for new hardware and software installation.

Worked for following clients

As a consultant through Rapigigm, Worked for following companies.

Confidential, Montvale, NJ

Lead Oracle DBA

08/2001-08/2002

Confidential, Merrimack, NH

Sr. Oracle DBA

03/2000-08/2001

Confidential, Boston, MA

Sr. Oracle DBA

09/1999-03/2000

Confidential, Concord, NC

Sr. Oracle DBA

06/1998-09/1999

Confidential, Franklin VA

Oracle DBA

09/1997-06/1998

Confidential, Atlanta, GA

Oracle DBA

07/1997-09/1997

EXTENSIVE TRAININGS (FROM ORACLE):

Oracle Database 10g: RAC for Administrator Release 2
Oracle Application Server 10gR2: Admin I
11i/2.6 Implement Oracle Workflow
Oracle Real Application Cluster
Oracle 9i New Features for Administer
Oracle Applications System Administration Release 11
Installing and Maintaining Oracle Applications R11

EDUCATION:

Masters in computer Applications

OTHERS: I am a team worker, self-starter, fast learner, hardworking, dedicated, goal-oriented, disciplined and down to earth with sincerity. US Citizen with Active Top Secret Clearance.