We provide IT Staff Augmentation Services!

Onsite Lead Resume

EXPERIENCE SUMMARY:

  • Extensive exposure on Oracle Database environments (9i,10g,11g,12c)
  • Extensive exposure on Oracle E - Business Suite environments (Apps11i/R12,10g AS).
  • Experience on Major IT production Database/DatawareHouse/APPS DBA environments.
  • Managing multi-terra byte critical production environments.
  • People management - Managed high performance team of 10+ resources.
  • Effective multitasking across different roles.
  • Grid, ASM, DB management in Exadata Machine X5-4, X4-2 Full, Half & Quarter RAC
  • Snapshot Standby database configuration with two level deep
  • Monitoring & maintain Exadata storage using CELLCLI utility
  • Configuring & monitoring Production alert from 12c OEM Cloud
  • 11gR2 Grid Installation in RAC and Non RAC environments on Linux Servers
  • 11gR1 CRS Installation in RAC and Non RAC environments on Linux Servers
  • Oracle replication technologies - Oracle Stream & Golden Gate (Schema level replication)
  • Installation 10.2.0.4 CRS, 10.1.0.5 ASM and DB in 4 node RAC configuration
  • Installation and configuration of 11g, 10g, 9i Database in RAC & Non RAC Environments
  • Database upgrade from Oracle 10gR1/10gR2 to 11gR1, 11gR1 to 11gR2
  • ASM Instance managements - Disk Group Creation-Disk add/drop/rebalance
  • Applying Security and Critical Patches in all level database
  • DR Implementation and administration
  • RMAN backup configuration and restoration
  • Data guard setup Standby database by manual and using RMAN duplication
  • Cloning database using RMAN Duplication
  • Converting DB storage from file system to ASM and Vice versa
  • Working/Support and Upgrade Oracle Applications knowledge Oracle Application11i & R12
  • Cutover Documents Preparation & Co-ordination
  • SSL certificates Implementation and Renewals (wallet) services
  • Modeln Application installation on 11g database in Linux servers
  • Weblogic, Apache,OHS installation & Configurations
  • TierData implementation in ERP Database - Archiving Solution
  • Solix implementation in ERP Database - Archiving solution
  • A good understanding of the underlying operating system
  • Sound knowledge of the implemented Shell scripts for automatic System health monitor with some kind of notification

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i/8i with RAC,GRID,ASM

ERP: Oracle APPS 11i / R12 DBA, Oracle 10gAS.

DB Management: Oracle Application Manager, OEM, Weblogic. RMAN

Platforms: LINUX (5/6/7), UNIX (HP-UX 11/Sun-Solaris 8/ IBM Aix 5.2), Win-NT/2000/XP.

Languages: PL/SQL, SQL

PROFESSIONAL EXPERIENCE:

Onsite Lead

Confidential

Onsite Project Lead

Confidential

Onsite Project Lead

Confidential

Onsite Project Lead

Confidential

Project Lead

Confidential

Project Lead

Confidential

Onsite lead

Confidential

Project Lead

Confidential

Team member

Confidential

Lead

Confidential

Lead

Responsibilities:

  • Supporting around 60+ Prod and 70+ Nonprod oracle database which including ERP, Shop floor, JDEdward,GIDS, Global Payment and Information System(GPIS),Purchase Card System (P-Card),Goverance Reporting Compliance GRC,Serena Dimension, PLM/PDM - Team Center, SSRS Datawarehouse,Compliant PRO, Oracle Application Express (APEX)
  • Managing offshore team to supporting production with 24/7 availability
  • Install & configured the 12R1 & 12R2 database + Migration data from 9i/10g database
  • Working on performance issue with help to OEM 12c.
  • Managing Automated cloning in HV instance & Manual cloning in CV instance using rman duplication
  • Applying patches and brings the production to the user specific requirement after testing in iteration
  • Working on issues faced by application users and providing support 24/7
  • Handing audit task once in a 6 month during fall & spring
  • Configuring Oracle 12c EM Cloud Monitoring alert for production database
  • Migrated all application VM servers from Avagotech to Broadcom domain
  • ERP Fusion Middleware upgrade from 11.1.1.6 to 11.1.1.9
  • Oracle 12C binaries installation & database setup for Agile, SOA applications
  • Applied Security and Critical Patches in Exadata machine
  • Reset up data guard for all production database in DR Exadata machine
  • Migrated Oracle steam schema level replication into Golden Gate
  • Upgraded ERP Oracle Applications from R12.1.3 to R12.2.4
  • Upgraded All Application Databases from 11.2.0.3 to 11.2.0.4
  • Retrofitting and Testing of all the customizations on top of R12.2
  • Changes to DR and Limited DR rehearsal
  • Migrated all the Databases (Oracle Erp Oltp, Ascp, Bpel, B2b, Obiee, Hyperion, Agile, Hpos, Liferay Portal,Modeln Crm,Sabrix) to Exadata platform
  • Migrated all application into oracle VM & it's storage into pure storage
  • Upgraded the operating System from OEL 5.7 to OEL 6.4 with some exceptions
  • Implement Solix purging and archival solution for Erp Replacement for Tierdata
  • E-business java upgrade from 1.6 update 38 to 1.7 update 55
  • Install 11gR2 oracle binaries in Exadata machine
  • Managing ASM disk group creation / drop in Exadata machine
  • Applied Security and Critical Patches in Exadata machine
  • Supported all issues faced by application users during testing phase
  • Cell server management & Monitoring in Exadata platform
  • Configured Oracle 12c EM Cloud Monitoring alert for Exadata servers & all database
  • Implemented data guard setup for all production database in DR Exadata machine
  • Migrate all the Engg DB’s & Engineering Applications to Confidential platform
  • Upgraded 8i,9i,10g database into latest version 11gR2 via export & Import
  • Configured 11.2.0.3 data guard for all production database
  • WebLogic 10.3.5.0 Installation & Install 11gR2 forms via Oracle Fusion Middleware
  • Upgraded all application Oracle database from 11gR1 to 11gR2.
  • Apply Security and Critical Patches.
  • Support for Upgrade O/s from Linux 5.4 to Linux 5.7
  • Cutover documents preparation
  • DR Upgrade and limited DR rehearsal.
  • Implemented AutoPilot 1.2 build Tool in Linux & Window servers
  • HP Outer bay data Migration to Online tables using Autopilot tool
  • Implemented Archiving solution on INV & WIP modules in ERP application
  • Partitioned all INV & WIP related tables on year wise & Moved archive data into respective partition by date using Autopilot tool
  • Created access layer to restrict to view latest data 1year only by OLTP users & all data by Reporting users
  • OS, Oracle DB and Apps Version upgrade and move to an upgraded platform
  • Production database center COM3 move into another place KC1
  • Install all oracle binaries, clone & upgrade database from 10g to 11g in ucs servers
  • Upgraded all ERP & Corresponding boundaries application from 10G to 11gR1
  • Replicate and Setup Data and Configuration to DR Location - Fort Collins (FTC)
  • Modeln application upgrade from 7.4.7 to 7.6.6 & 8.1
  • Web server’s setup for Modeln application using Apache with SSL enabled
  • Upgrade Modeln database from 10.1.0.5 to 11.1.0.7
  • WebLogic 10.1.3 installation
  • Oracle Stream Setup between Modeln & ERP database
  • Upgrade ERP database from 10.1.0.5 to 11.1.0.7
  • Apply interoperability patches in ERP instance according to upgrade
  • Upgrade all Non Erp Boundaries database from 10gR1 to 11G1
  • Upgrade all RHEL4 Linux Server OS RedHat5 (Oracle 5 or RHEL 5)

Hire Now