Nitin Ghai

Principle Consultant - Oracle Applications DBA

714-***-****

ad2lbh@r.postjobfree.com

Chicago, IL

Experience Summary

19+ Years as Senior Oracle Applications DBA in ERP such as Financials, Manufacturing, HRMS (HR, Payroll), CRM and Self Service framework I-Components (iSupplier, iPayment, iRecruitment, iStore etc), Comp-Workbench etc using Apps (10.7, 11.0.3, 11i – 11.5.3, 11.5.4, 11.5.5, 11.5.7, 11.5.8, 11.5.9, 11.5.10, R12, Rel 12.2). Business consulting experience in the areas of ERP HCM solutions, namely Oracle Fusion, E-Business Suite.

15+ years as Senior Oracle Database Administration Ver 7.x/8.0/8i/9i/10g/11gR2 on a variety of UNIX (Solaris, HP-UX, AIX), Linux, Windows NT 4.0/2000/2003.

Oracle Server Installations / Upgrades, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Patching, Security Administration, Data Architecting, normalization/de-normalization, Oracle Applications System Administration, Oracle Web Application Server, Data Warehousing, Oracle Advanced Replication, Oracle Parallel Server/9i RAC, 10g RAC, Space Manager, SQL Server, Oracle Standby Server, Dataguard, Multithread Servers, Distributed Databases for Oracle 7.x/8i/9i/10g Databases, table partitioning, cluster partitioning also under SAN infrastructure.

Document and publish the Discoverer/ADI/Oracle Database installation, configuration and procedures manual.

Implemented successfully 10g Discoverer upgrading from 4i.

Implemented OBIEE 11g and Oracle APEX 4.0.1.

Good technology understanding of Oracle RAC and hands-on experience of installation RAC cluster under Linux, 10g RAC installation, database creation, and migration databases from single instance to RAC instances

Strong Experience in installations, conversion, process improvement, application upgrade, patching management with Oracle Applications (10.7 NCA / 11.0.3 / 11i). Specialization in Oracle Application (ERP, CRM, SSL etc) and multiple Databases, Data Warehouse, ETL Technology, Reporting tools, Data Modeling and Data Architecture and Scrambling of Apps Environment after cloning. Also, worked on Clarify, Cognos, Brio, Kintana, Vertex, Veritas, Lagato, Omnibackup, Netbackup and EMC.

Implemented 11g IDM (11.1.1.6) /IDAM (11.1.1.5), IDAM 11.1.2, OAM 11.1.2, Webgate 11.1.1.5 and AccessGate 1.2.1 for SSO/OID configuration.

Installation and configuration of Oracle SOA suite 11gR1.

Implemented Oracle Fusion Applications 11.1.6

Certifications

Oracle DBA course from ORACLE SOFTWARE LTD

R11i system administration course from ORACLE SOFTWARE LTD

Oas 4.0.8 system administration from ORACLE SOFTWARE LTD

Solaris 8 administration - i from SUN MICROSYSTEMS

Solaris 8 administration -ii from SUN MICROSYSTEMS

Experience Summary

Working in RealData Soluitions as Principal Consultant since Jan-2018

Worked in Centroid systems Inc as Principal Consultant - Oracle Apps DBA. – April -14 To Dec-2017

Worked as Fujitsu Consultant in Mac Donalds (Chicago) from April-13 to April-14

Worked in Arrow Electronics as Senior Apps DBA from feb-09 to March-13

Worked in First American Cooperation as Senior Apps DBA from Nov-07 to Feb-2009. (USA)

Worked in Primesoft Inc Senior Apps DBA from Apr-07 to Nov-2007. (USA)

Worked in VSK Soft as Apps dba from Nov-06 to Arpril-07 (USA)

Worked in XANSA INDIA LTD as senior apps dba from Oct 2003 to Oct 2006.

Worked in ST ASSEMBLY and TEST LTD as apps dba from Mar 2002 to Oct 2003 (Singapore).

Worked in FOODBEX PVT LTD as oracle apps dba from Feb 2001 to Feb 2002 (Singapore)

Worked in STG INTERNATIONAL as a applications 11i dba (aug 2000 to Jan 2001) (Botswana)

Worked in HCL INFOSYSTEMS LTD as a apps dba (March 2000 to July 2000) (Germany)

Worked in PG SOFTECH LTD (Aug 1999 to march 2000)

Worked in MARK EXHAUST SYSTEMS LTD. As an oracle – apps dba (Jun 1999 to Aug 1999).

Worked in GVGB PVT LTD as a dba. (Feb 1998 to Jun 1999).

Worked in PJ Networks as oracle DBA. (Jan 1996 to Jan 1998)

Professional Experience:

Client := Marvell Semiconductors -- Aug-2019 to Present .

Supporting E-biz 12.2

Applying patches using ADOP for online patching.

Cloning of Rel 12.2 from develop instance.

Application of online patching using adop in Rel 12.2.

Creation of system backup scripts and made a regular backup strategy for Cold backup, hot backup scripts.

Maintenance of Oracle Application Instances including applying patches, Backup & Recovery.

Worked on Configuration of external Internet based applications like iRec with E-Business Suite R12 in a DMZ environment.

Supporitng OBIEE, Hyperion and Agile instances .

Upgraded database from 11.2.0.4 to 19.3

Converted non-CDB database to multitenant database .

Oracle Identity and Access Management in 11gR2 STAGE and PROD.

Setting up Provisioning and Reconciliation for AD and OID targets.

Intergration of EBS with OAM/OID .

Integration of OBIEE with Active Directory .

Installation and maintenance of PostgreSQL and mysql databases

Migrated DB2 database from Avera to Marvell data center .

Client: Merrill Corp

Rel 12.2 Ebz - Oct-2018 to August-2019

Upgrading E-biz Rel 12.2.4 to 12.2.6

Splitting of E-Biz 12.2.6 between two Production instances.

Upgrading Database from 11gR2 to Rel 12.1.0.2

3nd App Tier added with Shared APPL Tier Configuration for Load Balancing.

Enabling of online patching after the upgrade.

Applying patches using ADOP for online patching.

Cloning of Rel 12.2 from develop instance.

Application of online patching using adop in Rel 12.2.

Creation of system backup scripts and made a regular backup strategy for Cold backup, hot backup scripts.

Maintenance of Oracle Application Instances including applying patches, Backup & Recovery.

Worked on Configuration of external Internet based applications like iRec with E-Business Suite R12 in a DMZ environment.

Monitoring and diagnosing database performance through monitoring of alerts.

Taking Hot and Cold Backups, Exports etc.

Implemented ECC for Financials ( Payables Command Center and Receivable Command Center) .

Application of patches to updated Oracle E-Business Suite to the Oracle Enterprise Command Center Framework.

Integration between ECC and E-Business Suite using script.

Client: Parkland Canada

Migrated the Production Data from Chevron to ParkLand (AWS ).

Migrated the Dev and Test Database from Chevron to OCI .

Client: Underwriter Laboratries (UL) Chicago

(Upgrading Rel 12.1.3 to Rel 12.2.6) Oct-2017 to Oct-2018

Upgrading E-biz Rel 12.1.3 to 12.2.6

Upgrading Database from 11gR2 to Rel 12.1.0.2

3nd App Tier added with Shared APPL Tier Configuration for Load Balancing.

2 CM nodes for PCP setup.

Enabling of online patching after the upgrade.

Worked on Exadata X6 machines which included Half Rack and Full Rack

Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.

Implemented Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.

Applying patches using ADOP for online patching.

Cloning of Rel 12.2 from develop instance.

Application of online patching using adop in Rel 12.2.

Creation of system backup scripts and made a regular backup strategy for Cold backup, hot backup scripts.

Maintenance of Oracle Application Instances including applying patches, Backup & Recovery.

Worked on Configuration of external Internet based applications like iRec with E-Business Suite R12 in a DMZ environment.

Monitoring and diagnosing database performance through monitoring of alerts.

Taking Hot and Cold Backups, Exports etc.

Centroid systems Inc. - Chicago, IL Apr, 2014 –, Aug 2017

Client: Toshiba (Upgraded Rel 12.1.3 to Rel 12.2.6)

Upgrading E-biz Rel 12.1.3 to 12.2.6

Upgrading Database from 11gR2 to Rel 12.1.0.2

4nd App Tier added with Shared APPL Tier Configuration for Load Balancing.

Enabling of online patching after the upgrade.

Applying patches using ADOP for online patching.

Cloning of Rel 12.2 from develop instance.

Application of online patching using adop in Rel 12.2.

Configured PCP and Application Tier Load Balancing using Big IP.

Worked on Configuration of external Internet based applications like isupplier,iStore with E-Business Suite R12 in a DMZ environment.

Worked with the development team for tuning the database and E-BIZ.

Cloning of E-biz instance from Production to development servers.

Creation of system backup scripts and made a regular backup strategy for Cold backup, hot backup scripts.

Maintenance of Oracle Application Instances including applying patches, Backup & Recovery.

Monitoring and diagnosing database performance through monitoring of alerts.

Taking Hot and Cold Backups, Exports etc.

Configured Oracle EBS integrated soa gateway for SOAP services on 12.2.6

Implemented AP,AR, OE, INV modules .

Worked with the team to implement Ebiz Rel 12.1.3, IDAM 11.1.2.1 and IDM 11.1.1.6.

Integrated IDAM/IDM with Ebiz Rel 12.1.3.

Implemented 11g IDM (11.1.1.6) /IDAM(11.1.1.5),IDAM 11.1.2,OAM 11

Webgate 11.1.1.5 and AccessGate 1.2.1 for SSO/OID configuration.

Client: Eaton Steel

Migrated the Ebiz 11.5.10.2, from SunSolaris to Linux.

Upgrading E-biz Rel 11.5.10.2 to 12.2.4.

Applied minimum baseline patch on 11.5.10.2 for direct upgrade to Rel 12.2.

Upgraded Rel 11.5.10.2 to Rel 12.2.4

Enabling of online patching after the upgrade.

Cloning of Rel 12.2.4 from develop instance.

Application of online patching using adop in Rel 12.2.

Configured PCP and Application Tier Load Balancing using Big IP.

Worked with the development team for tuning the database and E-BIZ.

Cloning of E-biz instance from Production to development servers.

Administration and maintenance of Concurrent managers.

Monitoring the databases, server load, invalid objects, CPU, blocking, Locks, long running sessions, scheduling jobs and alerting based on the metrics using OEM.

Creation of system backup scripts and made a regular backup strategy for Cold backup, hot backup scripts.

Maintenance of Oracle Application Instances including applying patches, Backup & Recovery.

Monitoring and diagnosing database performance through monitoring of alerts.

Taking Hot and Cold Backups, Exports etc.

Implemented AP,AR GL, Oracle Projects .

Client: Edw. C. Levy Co

Migration of E-biz 12.1.3 from AIX to Oracle Database Appliance X5-2

Creation of Database on ODA using oakcli.

Conversion of character set from WE8MSWIN1252 to AL32UTF8.

Upgraded the database from 11.2.0.3 to Rel 12.1.0.2 on ODA server.

Migrating the database using Transportable Tablespace from AIX to Linux.

Cloning of E-biz instance from Production to development servers.

NON-RAC to RAC migration.

Administration and maintenance of Concurrent managers.

Worked with the development team for tuning custom codes.

Monitoring the databases, server load, invalid objects, CPU, blocking, Locks, long running sessions, scheduling jobs and alerting based on the metrics using OEM.

Creation of system backup scripts and made a regular backup strategy for Cold backup, hot backup scripts.

Maintenance of Oracle Application Instances including applying patches, Backup & Recovery.

Monitoring and diagnosing database performance through monitoring of alerts.

Implemented AP,AR, GL, INV and Oracle Projects.

Client: American Axle

Worked with the team to implement Ebiz Rel 12.1.3, IDAM 11.1.2.1 and IDM 11.1.1.6.

Integrated IDAM/IDM with Ebiz Rel 12.1.3.

Upgraded Rel 12.1.1 to 12.1.3

Upgrade the database to 11.2.0.4.

Migration of Database from Exadata X2 machine to X5.

Client: Amway

Worked with the team to implement Ebiz Rel 12.1.3, IDAM 11.1.2.1 and IDM 11.1.1.6.

Integrated IDAM/IDM with Ebiz Rel 12.1.3.

Migrated E-biz 12.1.3 from X2 Exadata Machine to X-5 Machine.

Implemented Best Practices for migration E-Business Suite and regular databases to Oracle Exadata.

Applied the patches on DBservers,IB switches and cells.

Maintenace and Monitoring of Cells for database performance .

Configured the tnsnames using SDP protocol for connectivity between App tier and Database.

Migration of Database from X2 Exadata Machine to X-5 Machine.

Client: Hulu Plus

Upgraded E-biz Rel 12.1.1 to 12.1.3

Upgrade the database to 11.2.0.4.

Fujitsu Consulting May, 2013 – April, 2014

Mac Donald Corporate, Chicago, IL

Installation of E-biz 12.2.2 on Red Hat Linux and Maintenance of Run and Patch environment.

Integrating E-biz 12.2.2 with OAM 11.1.2.1/OID 11.1.1.6/ Webgate 11.1.2.1and Access gate

Cloning of Rel 12.2.4 from develop instance.

Application of online patching using adop in Rel 12.2.4

Installation of Rel 12.1.3 on AIX 6.1.

Migration of Oracle Applications Rel 12.1.3 from AIX to Red hat Linux.

Migrated Oracle Ebiz Database 11.2.0.3 from AIX to Linux.

Implemented 11g IDM (11.1.1.6) /IDAM (11.1.1.5), IDAM 11.1.2, OAM 11.1.2, Webgate 1.1.1.5 and Access Gate 1.2.1 for SSO/OID configuration.

NON-RAC to RAC migration.

Shared APPL_TOP configuration.

Cloning Development instance from Production for development purpose.

Arrow Electronics Inc., US Feb, 2009 – Mar, 2013

Snr Oracle Applications DBA

Installation and configuration of R12 with 2 node RAC on linux.

Upgraded Rel 11.5.10.2 to Rel 12.1.1

Upgraded Rel 12.1.1 to 12.1.3

Installation and configuration of Oracle Application Rel 11.5.10.2 with 10g - 3node RAC on AIX on veritas clusterware.

Implemented Hardware Load Balancing of web tier and implemented Parrallel concurrent processing on admin tier.

Upgraded E-business database and CRS from 10g to 11gR2 and added concurrent node for better performance.

Installed Oracle APEX 4.0.1 and integrated it with SSO.

Cloning development instance from Production for development purpose.

Converting RAC instance from gpsfile system to ASM.

Installation and configuration of ASM for RAC instance.

Creation of RMAN system backup scripts and made a regular backup strategy for hot backup scripts.

Performed database administration functions including object sizing, Table space maintenance and overall disk space management

Implemented OBIEE 11g with Oracle database 11g.

Configuration and Administration of OBIEE 11g.

Planning to move Oracle Exadata Database Machine X3-2 with full rack configuration.

Installation of 10gOAS for OID/SSO and integrating 11i and Rel 12 with OID/SSO.

Implemented IDAM (11.1.1.5), IDAM 11.1.2, OAM 11.1.2, Webgate 11.1.1.5

Installation and configuration of vertex with Oracle Ebiz 11.5.10.2.

Installation and configuration of Oracle SOA suite 11gR1.

The First American Apr, 2007 – Feb, 2009

Snr Oracle Applications DBA

Implemented Oracle Application Rel 11.5.10.2 with 10g RAC on Sunsolaris 5.10 on Veritas storage Foundation for Oracle RAC.

Implemented Hardware Load Balancing of web tier and implemented Parrallel concurrent processing on admin tier.

Performed database administration functions including object sizing, Table space maintenance and overall disk space management.

Installation and configuration of, workflow and discoverer 4i.

Upgradation of discoverer to 10g from 4i.

Implemented SSL for Oracle Application and for Discoverer 10g.

Implement Hardware load balancing for web and forms server.

Cloning of RAC to non-RAC instance.

Setup of DR site for failover of Database and Application. Using Data guard.

Arbonne International, US Nov, 2006 – Apr, 2007

Senior Oracle Applications DBA

Implemented 11.5.10.2 HRMS and Financials and maintaining Oracle Applications Rel 11.5.9 Production and Development instances. Responsible for cloning development instance from Production for development purpose.

Installation of Oracle 9i/10g, installation and setup for 9iRAC and 10gRAC, Database migrating Oracle 9i to 10g.

Installed and patched for 11.5.9/10 instances, including foreign languages and Discoverer 4.1.48.06.

Installed, configured, trouble-shoots Oracle/SQL database and Oracle 10g Application server (including Portal, Single-Sign-on, Discoverer and third party application system) in all servers. Upgrades/Patching database and system based on Development/Operations request

Installation and managing Oracle Network products.

Tuning Oracle server along with Operating System to obtain optimal performance.

Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.

Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process.

Tuning performance monitoring and tuning, Optimization, Parameters, Tuning Issues, Bitmap indexes, Hash Joins.

Provided support for Oracle 10g RAC Cluster database both production and dev. Adding New Node and removing node for maintenance

Managing Veritas Clusters for HA, I2 Implementation.

Involvement in Disaster recovery

Table Partitioning, Creating Index Organized tables, Creating Locally Managed Tablespaces.

Cloning databases.

Setting up new environments (Development, Production etc)

Taking Hot and Cold Backups, Exports etc.

Performed database administration functions including object sizing, Table space maintenance and overall disk space management.

Installation and configuration of vertex, workflow and discoverer 4i. Upgradation of discoverer to 10g from 4i.

Implemented SSL for Oracle Application and for Discoverer 10g.

Implement Hardware load balancing for web and forms server.

Xansa Inc., U.K 3 Years

Senior Oracle Applications DBA

Worked in British Telecom project (Offshore DBA Pool) as Senior APPS DBA.

We are Responsible for the offshore support for British Telecom.

I look after the maintenance and support of Applications or trouble shoot any database related issue.

We are maintaining Oracle Applications Rel 11.0.x/11i Production and Development instances.

We are responsible for Cloning development instance from Production for development purpose, Installation and configuration of Oracle 8i RDBMS and Oracle application Release 11i on HP UNIX.

Replatforming of oracle instances from Sun Solaris to HP-UNIX. Performed database administration functions including object sizing, Table space maintenance and overall disk space management, Application of client, forms and database server patches.

Currently working in O2 Production Support project (Offshore DBA Pool) as Senior APPS DBA. We are Responsible for the offshore support for O2 Production server. Apart from BT and O2 support we are also supporting

St Assembly and Test ltd, Singapore 2 years

Senior Oracle Applications DBA

Upgraded Release 11.5.7 to 11.5.9

Responsible for maintaining Oracle Applications Rel 11.5.7 Production and Development instances.

Cloning development instance from Production for development purpose.

Installation and configuration of Oracle 8i RDBMS and Oracle application Release 11i on HP UNIX.

Upgraded oracle Application from Rel 11.0.2 to Rel 11.5.7 on HP-UNIX.

Performed database administration functions including object sizing, Table space maintenance and overall disk space management.

Creation of system backup scripts and made a regular backup strategy for Cold backup, hot backup scripts. Database Recovery Application of client, forms and database server patches.

Foodbex Pvt Ltd, Singapore 1 year

Oracle Applications DBA

Installed and configured Oracle8i/8 RDBMS, Oracle Application Release 11i, Apache Web server and Webdb on Sun Solaris Sparc (2.6).

Installed and configured Oracle 8 RDBMS and Oracle Application Release 11i on Sun Solaris Sparc (2.8). Performed database administration functions including object sizing, tablespace maintenance and Overall disk space management.

Creation of system backup scripts and made a regular Backup strategy for Cold backup, hot backup scripts.

Database Recovery Application of client, forms and database server patches.

Tuning of customized application including reports and back-end customization by using different application tuning technique.

STG International Ltd, BOTSWANA (AFRICA)

Oracle Applications DBA

Performed upgrade from Oracle RDBMS version 8 to Oracle 8i.

Performed Migration from Oracle RDBMS version 7 to Oracle 8.

Installed and configured Oracle8i/8 RDBMS, Oracle Application Release 11i, Apache Webserver and Webdb on Sun Solaris Sparc (2.6).

Installed and configured Oracle 8 RDBMS and Oracle on Sun Solaris Sparc (2.8). On-call support to all production servers.

Developed and implemented the instance strategy for the development, QA and Production databases. Performed database administration functions including object sizing, tablespace maintenance and overall disk space management.

Creation of system backup scripts and made a regular backup strategy for Cold backup, hot backup scripts.

Database Recovery Application of client, forms and database server patches.

Tuning of customized application including reports and back-end customization by using different application tuning techniques.

Performed application system administration functions including user application setup, assigning

Responsibilities, GUI Menu customization. Creation of concurrent programs.

General Motors, Germany

Database Administration

Upgraded oracle application from Rel 11.0.2 to 11.0.3 on HP UNIX.

On-call support to all production servers.

Developed and implemented the instance strategy for the development, QA and Production databases. Performed database administration functions including object sizing, tablespace maintenance and overall disk space management.

Installation of oracle 7.3 on HP-UNIX.

Database Administration and tuning.

Tuning of application and memory.

Creating backup and recovery strategies.

Tools: SAR R/3H, ORACLE 7.3/APPS11.0.2

Education

Bachelor of Engineering (B.E) in Electronics Engineering, University of Pune, India.

Contact this candidate