RITWIK DE

+1-405-***-**** / +1-630-***-****

ac4sed@r.postjobfree.com https://www.linkedin.com/in/deritwik

Professional Summary

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(11.5.10.2)/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 11.2.0.2 from legacy system running mainframe, cobol etc.

11.2.0.1 Database upgrade from 11.1.0.7 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).

11.1.0.6 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 11.2.0.4 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).

Professional Trainings/Certifications

Date Completed

AWS Certified Solutions Architect

March 2018

Oracle Certified Associate DBA

Sep 2011

R12 System Administrator Fundamentals

May 2008

R12 Install, Patch and Maintain Oracle Apps

Aug 2008

Oracle SOA Suite 10g: SOA Essentials Ed 1

Nov 2007

Oracle 10g:XML Fundamentals Ed 1

Oct 2007

11i eBusiness Suite Essentials for Implementers

Aug 2005

11i System Administrator Fundamentals

Aug 2005

11i Navigate Oracle Applications

Aug 2005

Oracle 9i: Program with PL/SQL

June 2005

Oracle 9i: Program with PL/SQL

June 2005

Work Experience Summary

Project

AP4 DataCenter Exit Cleveland, OH June-2016 -- Till Date

Customer

GE Lighting

Employer

V-Soft Consulting

Description

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.

Role

Oracle APPS DBA, Database/Solutions Architect

Project

GLprod/VCP 12.2 upgrade Michigan, USA Aug-2015 -- May 2016

Customer

GE Healthcare

Employer

GE Healthcare

Description

GE Healthcare is currently doing a big implementation of their GLPROD and VCP environment to upgrade the EBS version from 11.5.10.2/12.1.3 to 12.2.4. This project also involves database and application platform migration from Solaris to Linux.

Role

IT Technologist - Oracle APPS DBA

Project

BlueSky Hightstown, New Jersey, USA Dec-2014 -- July-2015

Customer

Dodge Data & Analytics

Employer

Titan Technologies Inc

Description

This project is to migrate the on-premise data center to Amazon cloud(AWS) including migration and upgradation of databases and application.

Role

Lead Oracle APPS DBA

Project

Managed Services June-2014 -- Nov 2014

Customer

Financial Times, PPG, Go-Ahead, Lombard, BT, Veolia, Mitie etc

Employer

Hitachi Consulting

Description

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.

Role

Senior Consultant - Oracle APPS DBA

Project

Global Foundries Global Finance Malta, NY, USA Nov-2013 -- May-2014

Customer

Global Foundries

Employer

IBM

Description

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.

Role

Oracle APPS DBA, Oracle SOA/weblogic admin

Project

Hertz ERP Project Oklahoma City, USA Apr-2009 to July-2013

Customer

Hertz Corporation

Employer

IBM

Description

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 11.2.0.2.

This project also involved supporting R11.5.10.2 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.

Role

Oracle APPS DBA

Project

AMEX OFI Project Phoenix, AZ, USA Mar-2007 to Apr-2009

Customer

AMEX

Employer

IBM

Description

This project is to Support Production R11/R12 Instance with finance module implemented. It had OBIEE and Informatica support as well.

Role

Oracle APPS DBA

Project

EMC Synergy Project California, USA Oct-2005 to Jan-2007

Customer

EMC Corp

Employer

Accenture

Description

This project is to Support Production R11 with CRM module implemented.

Role

Oracle APPS DBA

Education

College/University

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.

Contact this candidate