Oracle Apps DBA/AWS Certified Architect
Resume:
RITWIK DE
+1-405-***-**** / +1-630-***-****
******.**@*****.*** 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