Senior Oracle Ebusiness suite DBA/Architect with more than 12 years of experience in Oracle Database 9i, 10g, 11g, 12c and Oracle Applications R11 and R12.
Extensive experience in Oracle ERP implementation, Upgrade and post-implementation support experience.
AWS Certified Solutions Architect with experience migrating application and database to cloud like AWS,Oracle,Virtustream.
Skill and knowledge Summary
Expert level proficiency in installation, configuration, troubleshooting, patching and cloning of Oracle E-business Suite 11i(22.214.171.124)/R12(12.1.3/12.2) instance for advanced topologies.
Real time implementation experience of EBS R12.2.4 and managing 12.2 environments which includes ADOP enablement and ADOP patching.
11.2/12c Two/Three Node Real Application Cluster with ASM.
Installation and configuration of OEM 12c/13c.
Cross platform database migration from solaris to Linux for EBS database.
Migration of existing infrastructure (database, application etc) to Amazon Cloud (AWS)/ Virtustream.
Migration of Oracle EBS 12.1.3/12.2.6 to Oracle Compute Cloud (IaaS).
Oracle Real Application grid infrastructure installation (11g R2) with conversion of non-RAC database to RAC and migration of file system to ASM.
Patching, upgrading and managing oracle database for SAP environment.
Installation, configuration and administration of Demantra using weblogic 11g.
Creation of external application node in DMZ with reverse proxy for Oracle iSupplier.
Implementation of Oracle ebusiness suite R12.1.3(Finance module) with 2 node application tier, 1 node external tier in DMZ and 2 node RAC database 126.96.36.199 from legacy system running mainframe, cobol etc.
188.8.131.52 Database upgrade from 184.108.40.206 of R12 database.
Performed Oracle E-Business Suite Upgrade from Release 11i to R12(12.1.3).
Working knowledge of Oracle Enterprise Manager 10g/11g/12c Grid Control (OEM).
220.127.116.11 Database Upgrade from 10.2.0.3 of 11i and non-ERP databases.
Performed Oracle E-Business Suite Upgrade from R12.0.4 to R12.1.3 along with database upgrade from 18.104.22.168 to 12.0.1(12c)
Involved in disaster recovery preparation, planning and testing with working knowledge of Oracle Data Guard.
Good exposure of Backup and Recovery (Oracle Recovery Manager (RMAN), Import/Export and Datapump), EMC Networker.
Knowledge of SAN based backup/restore using disk mirroring technology of Hitachi(HITACHI UR/VERITAS)
Extensive knowledge on Oracle GoldenGate and setting up unidirectional, bidirectional and peer-peer topology.
Installation of Oracle Access Manager (OAM 11g) using webgate and integration with R12 via accessgate.
Support and maintenance of environment running Oracle Weblogic with SOA and AIA.
Installation and Configuration of 10.1.3.4 SOA Suite with BPEL and ESB.
Installation, configuration and integration of Oracle Single Sign On (SSO) 10.1.2.0.2 with Oracle E-Business Suite using mod_osso.
Installation, configuration and maintenance of OBIEE 11g.
Exadata database machine administration (X3-2).
Cross-platform database migration using RMAN transportable database with minimal downtime.
JVM tuning and analysis of current JVM stack performance and suggestion/solution based on client need for 11i instance.
Installation, configuration and integration of Oracle Discoverer 10.1.2.0.2 with Oracle E-Business Suite.
Configuration of Parallel Concurrent Processing (PCP) with database load balancing for concurrent managers.
Web entry load balancing using hardware load balancer and oc4j based load balancing for forms in R12.
Installation and configuration of 10g Enterprise manager for Grid Control, Deployment of Grid control agent on different platform.
Good understanding of DB statistics reports/tools like statspack, AWR, ADDM, Trace, Tkprof, explain plan, SQL Tuning Advisor& SQL Plan Management (11g).
Database SGA and core tuning involving init file parameters.
Installation, configuration and maintenance of Informatica.
Installation and configuration of SuSE Linux Enterprise Server (SLES) 9.2 (32-bit/64-bit).
Facilitate the promotion of application code, setups, databases and related components from the various levels of development through staging and production. Working knowledge of Oracle Application Change Management Plugin (ACMP) through OEM Grid to promote code movement.
Installation and configuration of Oracle Life Science Hub (LSH).
AWS Certified Solutions Architect
Oracle Certified Associate DBA
R12 System Administrator Fundamentals
R12 Install, Patch and Maintain Oracle Apps
Oracle SOA Suite 10g: SOA Essentials Ed 1
Oracle 10g:XML Fundamentals Ed 1
11i eBusiness Suite Essentials for Implementers
11i System Administrator Fundamentals
11i Navigate Oracle Applications
Oracle 9i: Program with PL/SQL
Oracle 9i: Program with PL/SQL
Work Experience Summary
AP4 DataCenter Exit Cleveland, OH June-2016 -- Till Date
GE Lighting is currently migrating the on-premise data center to Cloud solution including Amazon cloud(AWS) and Virtustream. The scope of the project is migration and upgradation of databases and application which include SAP and Oracle EBS within the landscape.
Oracle APPS DBA, Database/Solutions Architect
GLprod/VCP 12.2 upgrade Michigan, USA Aug-2015 -- May 2016
GE Healthcare is currently doing a big implementation of their GLPROD and VCP environment to upgrade the EBS version from 22.214.171.124/12.1.3 to 12.2.4. This project also involves database and application platform migration from Solaris to Linux.
IT Technologist - Oracle APPS DBA
BlueSky Hightstown, New Jersey, USA Dec-2014 -- July-2015
Dodge Data & Analytics
Titan Technologies Inc
This project is to migrate the on-premise data center to Amazon cloud(AWS) including migration and upgradation of databases and application.
Lead Oracle APPS DBA
Managed Services June-2014 -- Nov 2014
Financial Times, PPG, Go-Ahead, Lombard, BT, Veolia, Mitie etc
This project is to Support Production 11i/R12 Instance for all and many more customers as a part of managed services. It also includes upgradation of customer environment to latest product version as and when required.
Senior Consultant - Oracle APPS DBA
Global Foundries Global Finance Malta, NY, USA Nov-2013 -- May-2014
This project is to Support Production R12 Instance with finance and ASCP module implemented. It has subsidiary application like GTM, OIM, SOA implemented and integrated with ebiz too. It also includes upgradation of customer environment to latest product version as and when required.
Oracle APPS DBA, Oracle SOA/weblogic admin
Hertz ERP Project Oklahoma City, USA Apr-2009 to July-2013
This project is to Support Production R12.0.4 instance with HRMS module for Hertz USA business unit and later upgrade it to R12.1.3 and database to 126.96.36.199.
This project also involved supporting R188.8.131.52 instance with GL, AP, AR,FA module for Hertz Europe/Australia business unit and later upgrade it to R12.1.3.
This project also involved implementing R12 finance module for Hertz USA business unit from legacy system using mainframe and cobol.
Oracle APPS DBA
AMEX OFI Project Phoenix, AZ, USA Mar-2007 to Apr-2009
This project is to Support Production R11/R12 Instance with finance module implemented. It had OBIEE and Informatica support as well.
Oracle APPS DBA
EMC Synergy Project California, USA Oct-2005 to Jan-2007
This project is to Support Production R11 with CRM module implemented.
Oracle APPS DBA
Masters in Computer Applications (MCA) – 2005
Bachelor of Science with Honours in Economics – 2001
West Bengal University of Technology, Kolkata, WB, India.
Calcutta University, Kolkata, WB, India.