Summary
Overview
Work History
Education
Skills
Certification
Custom
Accomplishments
Languages
Timeline
Generic
Vikash Kumar

Vikash Kumar

Kolkata

Summary

8.9 years of experience in Database and EBS application Administration on On-Premise, OCI and Exadata DB system including experience in implementation, upgrade, maintenance and support, Backup and restore, Troubleshooting of EBS Application with Oracle RAC and non-RAC database hosted on Linux and Solaris Operating System.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Oracle Apps DBA

Deloitte Consulting US India Pvt Ltd
Kolkata
07.2021 - Current
  • Maintenance and support of OCI Exadata X9M Grid Infrastructure, RAC database 12c and 19c, EBS application 12.2.11, and R12.2.13 of Dev, QA, and Production live environments.
  • Worked with multiple clients during my tenure at Deloitte on different systems for maintenance and support, upgrade, migration, and implementation.
  • Migrated EBS R12.2.4, along with 12c database, from on-premise to OCI ExaCS cloud.
  • Oracle database upgrade from 12c RAC to 19c RAC database.
  • Oracle EBS upgrade from R12.2.8 to R12.2.11.
  • Cloning automation using shell scripting and establishing a refresh process helped ALC reduce the refresh time by almost 60% compared to the past time after OCI migration for a database of around 17 TB using active dataguard duplicate.
  • SSL certificate renewal on all the lower and production environments.
  • Setup of Automated health check report for Grid Infrastructure, Database, EBS application, and Weblogic services using shell script.
  • Grid Infrastructure, Database, OEM, and EBS application patching, and WebLogic security patching on Exadata system quarterly with respect to critical patch updates (CPU Patches) released by Oracle.
  • Collaborated closely with team members to achieve project objectives and meet deadlines.
  • Assisted with customer requests and answered questions to improve satisfaction.

Oracle Apps DBA

Tata Consultancy Services
Kolkata
02.2016 - 07.2021
  • Administration of Production server, 2-Node RAC Database (11.2.0.3) with ASM, and 2-Node Application tier (R12.2.4) in master-slave architecture, and 5 non-RAC development and QA Instances on On-premise.
  • Oracle RAC implementation and configuration of Grid Infrastructure and Database versions 11g and 12c.
  • Production database upgrade from 10.2.0.3 to 11.2.0.4 on Solaris.
  • Oracle E-Business Suite upgrade from 12.0.4 to 12.1.3 and 12.1.3 to 12.2.4.
  • Platform migration of Oracle Database 11.2.0.4 from Solaris to Linux.
  • Platform migration of E-Business Suite 12.1.3 from Solaris to Linux.
  • 2-Node RAC Grid and Database upgrade to 12c (12.1.0.2) and 19c.
  • Parallel, concurrent processing setup in R12.2.4.
  • JWS implementation to open Oracle Forms browser independently.
  • ASM and Filesystem storage migration from one system to another.
  • Workflow Notification mailer setup in R12.2.4 and R12.1.2.
  • 2-Node RAC Database ASM storage migration from old SAN to new SAN (Data, OCR, Votedisk, and Archive diskgroup replacement)
  • Enable ASMLib disks to use multipathing to avoid a single point of failure.
  • Demo upgrade to a single Database node of 12c and configure Data Guard and Data Guard broker to manage standby.
  • Carried out activity of ETCC patching on Application tier, version R12.2.4.
  • FMW web tier upgrade and application of DST Time zone patches on application tier, R12.2.4.
  • Carried out application of an average of 6 to 7 patches using ADOP in the application tier R12.2.4 and 3 to 4 instance refreshes in a month.
  • Carried out DR drill activity several times for audit purposes. Cases checked are Read-only standby, Switchover, back switchover, Snapshot standby, and failover.
  • Implement the automated Hot Backup scripts for the daily full backup.
  • Defragmentation of tablespace to reclaim unused blocks.
  • Knowledge of the run/patch dual filesystems and database objects within EBS 12.2.
  • RAC to non-RAC and non-RAC to RAC cloning knowledge.
  • Database tuning, Application Tuning, and performance monitoring.
  • Fine-tuning initialization parameters, I/O, memory, and operating system kernel parameters.
  • Implementing and maintaining database security (creating and maintaining users, roles, and assigning privileges).
  • Responsibility for user management ticket, user creation and deletion, responsibility assignment, etc.
  • Migrated RAC nodes archiving to ASM from local, low-performing disks.
  • Analyzed RAC Node eviction issue due to OS compatibility issue with NETAPP or SAN storage and suggested for OS upgrade.
  • Carried out DR drill activity several times for audit purposes. Cases checked are Read only standby, Switchover, Back switchover, Snapshot standby, and failover.

Education

Bachelor of Technology - Electronics & Communication Engineering, DGPA 8.46

Calcutta Institute of Technology
West Bengal, India
08-2015

Higher Secondary - PCM, Percentage - 83.6

Kendriya Vidyalaya
Bailey Road, Patna, Bihar
04-2011

Senior Secondary - PCM, Percentage - 82.8

Kendriya Vidyalaya
Bailey Road, Patna, Bihar
04-2009

Skills

  • Database administration
  • EBS Application Administration
  • Database administration on OCI ExaCS
  • Oracle RAC
  • Oracle ASM
  • Grid infrastructure
  • OCI migration
  • Platform migration from Solaris to Linux
  • Database upgrades
  • EBS upgrades from R121 to R122
  • Disaster Recovery
  • OEM
  • EBS Asserter & SSO
  • Backup and Restore
  • Cloning
  • Patching
  • Shell scripting & automation
  • Linux
  • Troubleshooting

Certification

  • 1Z0-082 Oracle Database Administration I Certification
  • 1Z0-083 Oracle Database Administration II Certification
  • Oracle Database Administration 2019 Certified Professional
  • Oracle Cloud Infrastructure Architect Associate 2023
  • Oracle Cloud Infrastructure Foundations 2023 Associate

Custom

  • Oracle Enterprise Manager 12C
  • Oracle Database upgrade to 12c
  • Database Administration 11g
  • AWS Solution Architect Associate

Accomplishments

  • Twice awarded the Spot Award, and once awarded the Applause Award by the client at Deloitte for migrating the database to OCI and upgrading it
  • Outstanding award for platform migration of 12c database and EBS application from Solaris to Linux
  • Applause award for completing four certifications in a quarter by Deloitte
  • Awarded for the English essay competition at the school level
  • Awarded for the Hindi essay competition at the school level

Languages

Hindi
First Language
English
Proficient (C2)
C2

Timeline

Oracle Apps DBA

Deloitte Consulting US India Pvt Ltd
07.2021 - Current

Oracle Apps DBA

Tata Consultancy Services
02.2016 - 07.2021

Bachelor of Technology - Electronics & Communication Engineering, DGPA 8.46

Calcutta Institute of Technology

Higher Secondary - PCM, Percentage - 83.6

Kendriya Vidyalaya

Senior Secondary - PCM, Percentage - 82.8

Kendriya Vidyalaya

Similar Profiles

  • Jarvise Paul

    Jarvise PaulJarvise Paul

    Senior Consultant at Deloitte Consulting US INDIA Pvt. Ltd.Senior Consultant at Deloitte Consulting US INDIA Pvt. Ltd.

  • Agrim Saraswat

    Agrim SaraswatAgrim Saraswat

    Specialist Senior at Deloitte Consulting US India Pvt LtdSpecialist Senior at Deloitte Consulting US India Pvt Ltd

  • Kirty Agrawal

    Kirty AgrawalKirty Agrawal

    Senior Consultant at Deloitte Consulting US-India Pvt. Ltd.Senior Consultant at Deloitte Consulting US-India Pvt. Ltd.

  • ASWINI KUMAR SHARMA

    ASWINI KUMAR SHARMAASWINI KUMAR SHARMA

    Associate General Manager – Procurement at AMPIN Energy Transition Pvt. Ltd.Associate General Manager – Procurement at AMPIN Energy Transition Pvt. Ltd.

  • ANJELA BANERJEE

    ANJELA BANERJEEANJELA BANERJEE

    Legal Intern at Kolkata Municipal Corporation CourtLegal Intern at Kolkata Municipal Corporation Court

CREATE PROFILE
Vikash Kumar