Resume

Page * of *

Manoj Gorai

Email-Id: adxhb2@r.postjobfree.com

Phone: +1-319-***-****

Cedar Rapids, IA, USA

Education : Bachelor in Engineering from Visvesvaraya Technological University, Belgaum, Karnataka, India in 2004

Experience Summary:

I am associated with Tata Consultancy Services Ltd, Kolkata for the past 12+years with overall experience of 16+years. My prime expertise area as an Oracle Database Administrator with relevant exp of 13+years. In IT industry I have mainly worked in insurance and manufacturing domain but currently involved in Retail Domain. Extensive experience in Database implementations for new Project Work, BAU activities and Database transitions. Comprehensive experience as an Oracle DBA proficient in Oracle 12C and 19C Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Database upgrade and Tuning Oracle 12C/19c and 13C OEM on Unix Environment. My current role is an Oracle DBA architect and Implementation Lead for Oracle database of TCS BanCs Application.

Technology work on:

Below is a list of important hardware, software products and tools that I have worked with. Hardware Software Products Tools Used

IBM AIX Based Power

Systems

RHEL5,6 and 7

OEL5 Systems

Oracle Database Version 10g and

11g,12C,19C

Oracle Real Application Cluster

19C and 12C

Oracle 11gR2,12C and 19C

Standalone

Oracle 12C and 19C ASM

Oracle RMAN,

TOAD

13C Release 4 OEM

Commvault Backup

integration

Professional Certification Member Since / Date Certified Oracle 10g OCA Administration Jun/ 2009

ITIL Foundation 2011 Certification Dec/ 2015

Oracle 11g OCP Professional Aug/ 2016

AWS Certified Solutions Architect Feb/ 2020

Resume

Page 2 of 5

Career Summary:

Since 2011 Tata Consultancy Services

Period : Jun 2018 –Till Date

Client Name: Money Services Inc. Cedar Rapids, IA, USA Position: Oracle Architect and DBA lead

Project Description: The Trans America is an E2E Implementation and Support project in TCS including the Infrastructure Service. This group’s primary responsibility is to implement the various technologies like Citrix, Unix, VMs, Oracle Database as an IT Infrastructure etc.

Responsibilities

My primary responsibility is requirement gathering for Oracle Database Build, provisioning users access, Prepare the database to as per BanCs application, designing the high level Database architecture diagram along with below responsibilities.

Architecting, planning, designing, deploying and supporting RAC database environment on Oracle 12C and 19C.

Architecting, planning, designing, deploying and supporting OEM 13C for Monitoring oracle services for production and Non prod environment.

Installing & configuring Oracle cluster ware & Database Software and database creation in RAC on Oracle 12C and OEM 13C.

Upgrade of Grid Cluster ware(RAC) and Oracle database from 12C to 19C. Upgrades/Patching - Evaluate and upgrade Oracle databases to remain within premier support and avoid extended maintenance fees, Quarterly database patching,

Participation in Annual DR drill (internal and external), TDE Key rotation, Remediate security vulnerabilities, Biannual user access reviews, Provide SOX, SOC1 client requested evidence, Review and Providing reports (data) as requested.

Work with Oracle support on SR's, Application troubleshooting/support and coordinate with application & support team for the impacted databases

Integration of Commvault Backup tool with Oracle 12C and 19C database.

Implementation and Configuration of OEM 13C for day to day monitoring.

Implementing and maintaining database security (create and maintain users, roles and assign privileges).

Migration of database from RAC to single instance and vice-versa.

Oracle Transparent Data Encryption implementation in Table space level for data encryption.

Oracle Database vault implementation to protect Customer PII data.

Oracle Vault Realm design to protect PII data of Customer.

Worked on Oracle GG to setup real time replication on PoC env to implement as part of DR solution.

Client Name: Morrison's Supermarket Plc, Bradford, UK Position: Oracle Database Lead

Project Location: Bradford, UK

Project Description: The Morrison's is a Support project in TCS including the Infrastructure Service to provide support and troubleshoot for testing team on project base requirement. DBA's are the primary responsibility is to implement the various database technologies like Oracle, AWS, MS SQL. Resume

Page 3 of 5

Responsibilities:

Below were my engagement during my client site stays at client site(Oct-2016- Oct-2017):

Primary responsibility was to prepare the strategy for database migration, Implementation and test the strategy in lower environment like SIT,UAT and CPTE. Then implement the same strategy for Production re-platform activity. Those database holds the application of Decode, SSB, SOA and Appworx.

Based on re-platform activity project from HP Super dome to Linux environment, build new database servers as per requirement with Morrison's standard and deliver it to client after the configuration of Oracle database for testing purposes.

Worked on various ongoing project like Exadata migration from X2 to X6 as an Oracle DBA lead and provide support for related interface for migration activity. Exadata migration done by Oracle, London's team. Our main involvement was to provide support on post re-platform activity.

Worked on database migration for the above said application..

Backup plan implementations with RMAN using Commvault Tool.

Provide support for day to day activity to resolve issues during testing activity for Non MOM application database re-platform project.

Troubleshooting of ASM issues during version installation of ASM on Linux server in 12C.

Troubleshooting and provide support to Customer of Oracle Database during re-platform activity to 11gR2.

Client Name: Kingfisher Plc,UK

Position: Oracle Database Administrator

Project Description: The Kingfisher Plc is an E2E Implementation of SAP and Support project in TCS including the Infrastructure Service. This group’s primary responsibility is to implement the various technologies like Citrix, IT Infrastructure for Oracle database etc

Responsibilities:

Installation and Configuration and patching of Oracle database Servers 12C Software on Unix based system like AIX and Linux.

12C ASM installation on AIX and Linux based production and development server.

Capacity planning activity for the storage migration for oracle databases.

Migration of Storage of Oracle database from Raw to File system and Raw to ASM on keeping existing version same.

Up-gradation of Oracle database from 11gR2 to 12C.

Up-gradation of ASM from 11gR2 to 12C with latest Patch set implementation, Optachauto apply.

Troubleshooting of Oracle Database on ASM during version up gradation of ASM to 12C

Troubleshooting of Oracle Database during version up gradation to 12C.

12C EM configuration for newly upgraded databases, ASM and Listener etc Client Name: Diligenta- Friends Life, UK

Position: Oracle Database Administrator

Project Description: The Friend's Life is an E2E Implementation and Support project in TCS including the Infrastructure Service. This group’s primary responsibility is to implement the various technologies like Citrix, IT Infrastructure for Oracle database etc.

Responsibilities

Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment on Oracle 11gR2

Installing & configuring Oracle cluster ware & Database Software and database creation in RAC on Oracle 11gR2

Troubleshooting using cluvfy & handling common issues that arise during integration of the whole – bugs, network issues, configuration files issues, OCR issue, de-installation & cleanup of cluster-ware on oracle 11gR2

Backup and Recovery strategy planning and implementation using RMAN. Resume

Page 4 of 5

Cross-Platform Database migration using RMAN from Linux to AIX and vice-versa over 2TB and troubleshoot during the migration activity.

Database migration using RMAN and Transportable table space.

Database migration from Non-RAC to RAC environment on AIX platform.

Backup and recovery testing on RAC environment.

Implementing and maintaining database security (create and maintain users, roles and assign privileges).

Database creation and configuration as per the requirement provided to team.

Many day to day activities to like users drop and creation request, schema export/import using datapump utility.

Migration of database from RAC to single instance. Utso Software Solutions

Period : Apr 2007 – Jan 2011

Client Name: Tata Steel, Jamshedpur/Tata Consultancy Services, Jamshedpur Position: Oracle Database Administrator

Project Location: Jamshedpur, India

Project Description: The Product Alliance Group is a support and implementation project in TCS. This group’s primary responsibility is to support various clients for various technologies like Oracle Database, Oracle 10g Application Server, Weblogic and various other Oracle Products with IBM Lotus notes, Citrix, Microsoft etc. Responsibilities:

Installation and Configuration of Oracle database Servers 10g and 11g on Unix based system like AIX,HP-UX Itanium, PA-RISC on 64bit,OEL 5.

Migration of Oracle database from 9i to 10gR2 and from 10g to 11g on Unix based system.

Up-gradation of Oracle database from 10gR1 to 11gR2.

Up-gradation of Oracle database from 9i to 10gR2 with latest Patch set implementation, Optach apply.

Planning and Preparation DC and DR site production site.

Implementation of DR for data centre on Oracle 11gR2 on Unix based system.

Experience with ‘graceful’ switchover and switchback between primary and standby databases.

Troubleshooting on many aspects depends upon our client's issue on production database server. Ayoki Fabricon Pvt Ltd

Period : Jul 2005 – Dec 2005

Position: Trainee Engineer

Project Location: Pune, India

Project Description:: Ayoki Fabricon Pvt. Ltd. is a company incorporated to handle any nature of work with its keenness to grow and adopt modern management and productive systems. Additionally, it takes complete responsibility in execution of work such as consultant’s approval, Fabrication, Erection and Installation, assistance for Commissioning and Testing before handing over to the Client.

Ayoki has undertaken and successfully completed various projects such as Bulk Material Handling, Oil & Gas Plants, Distilleries, Foundries, Pollution Control Equipments, Steel Plants, Sugar Plants, Cement Plants, Boilers and Co-generation Plants in India and Abroad. Ayoki owns various Machinery / Equipments / Tools required for site Fabrication and Erection. Responsibilities: Went through various training programme of Boiler erection phase. Resume

Page 5 of 5

Soudamini Instruments

Period : Jan 2005 – Jun 2005

Position: Design Engineer

Project Location: Pune, India

Project Details: Manufacturer, Supplier, Exporter of high voltage Relays, protection Relay's, solid state Relays, Electro- Magnetic Relays, Precision Instruments, Safety Devices And Solenoids For Diesel Engines. Responsibilities: Design of Eletro-magnetic train using Cad/Cam design software. Personal Details

Sex: Male

Nationality: INDIAN

Marital Status: Married

Number of Children: 1

Passport Details:

Name Nationality Passport Number Place of issue Date of issue Date of Expiry Manoj Gorai Indian V2863374 Chicago 11/11/2021 11/10/2031 Declaration:

I hereby declare that all the information furnished in this application is complete and correct to the best of my knowledge and belief.

Place: - Cedar Rapids, USA Manoj Gorai

Date: - 06/01/2023 Signature

Contact this candidate