Summary
Overview
Work History
Education
Skills
Certification
Disclaimer
playing Chess for refresh my mind
Timeline
Generic

Gyanendra Kumar Upadhyay

Bangalore

Summary

Around 15+ years of extensive experience with Oracle DBA /Apps DBA/ professional. Seeking a challenging career that utilizes my skills, strengths and overall portfolio also willing to work as a key player in challenging & creative environment.

Proactive and goal-oriented professional with excellent time management and problem-solving skills. Known for reliability and adaptability, with swift capacity to learn and apply new skills. Committed to leveraging these qualities to drive team success and contribute to organizational growth.

Overview

16
16
years of professional experience
6
6
Certifications

Work History

Sr. Database Advisor and Lead

IBM
08.2020 - Current
  • Support on Oracle 12c ,19c RAC on Red-Hat Linux, Oracle Enterprise Linux
  • Capable to manage team and assign work in smoothly
  • Working on scripting automation part via shell and perl scripting
  • Participating in all client meeting for technical task like patching, refresh, build DB, DR and with hardware, networking team
  • Leading the patching project every quarter for prod and non-prod databases
  • Troubleshooting issues on database and golden gate
  • Experience in managing private & public cloud environments
  • Worked on many deployments along with RU 12 patch and designing, planning, and scaling cloud
  • Creating SOP (run through docs) for patching, refresh and other major activities
  • Working with oracle support for any p1 and unknown issues related to database
  • Troubleshooting performance related issues raised by Application team on time to time
  • Monitoring Day to Day activities performed by team and mentor them if required

DBA-Lead

Infinite Computer Solution
09.2015 - 08.2020
  • Applied one-off, Language patch on the instances using ad patch /adop utilities
  • Worked on RU12 patches for 19c databases
  • Troubleshooting issues for Golden gate like lag issue, stop/start processes
  • Supporting All prod servers including cloud, creating VM, IAM and RDS as per client request
  • Working on refresh from prod to uat and development
  • Troubleshooting sysadmin, concurrent manager issues, workflow and weblogic related issues as and when required
  • Handling high sev issues, SR activities, Application deployment and automation Task
  • Applying patches through ADOP, running adadmin, fs_clone and autoconfig (on appl tier and database) as and when required

DBA -SME

Infinite Computer Solution
09.2015 - 12.2016
  • Company Overview: (Huawei)
  • Worked as a DBA -SME for Ooredo Kuwait on onsite in Kuwait, having responsibility to manage team
  • Created high level SOP's
  • Execution of backup plan attended meetings with client for transition
  • Worked as individual consultant for Etisalat Nigeria from offshore team, responsible for all type of DBA work and as a team Leader, managing the team
  • Refresh through Golden Gate for heterogeneous environment
  • Worked as a individual contributor on EBS production support for various module like HRMS, FINANCIAL, SCM etc
  • Closely working with client and supported in 24
  • 7 environment for all type of issue related to EBS and databases
  • (Huawei)

Sr Consultant DBA

Data Q Apps Technology
11.2014 - 08.2015
  • Worked in Build Team, Responsible for any type (DB, ERP, DG, ASM) of Refresh through Mystic tool
  • Applying patches on 2 node, 4 node Application and Databases
  • Applied online patched on 12.2.4 through ADOP utility and troubleshooting issues
  • Responsible for DB Recovery if Any mis happening by any team
  • Involve in validation after and before Refresh or any migration
  • Worked on Delphix Engine and Delphix storage, Having good exp in delphix refresh

DBA Consultant

TECHMATRICS SOLUTIONS PRIVATE LIMITED
11.2008 - 11.2014
  • Applied one-off, Family packs on the instances using ad patch utilities
  • Fresh installation of R12 and started all the services
  • Upgrade R12.1.3 from R12.1.1
  • Upgrade 11.2.0.2 from 11.1.0.7
  • Installed Oracle 10.2.0 on Linux
  • Flashback Database, Flashback Query, Flashback Table
  • Prepare documentation all activities and training program for all of our clients
  • Managing Apps database through adadmin

Education

Bachelor of Engineering - ECE

Skills

Problem-solving

Certification

Oracle Cloud Infrastructure (1z0-932) certified

Disclaimer

I hereby declare that all the details provided above are true to the best of my knowledge.

playing Chess for refresh my mind

When I’m not working on databases, I enjoy  exploring new technology trends or  playing chess which helps me stay refreshed and ready for the challenges ahead.

Timeline

Sr. Database Advisor and Lead

IBM
08.2020 - Current

DBA-Lead

Infinite Computer Solution
09.2015 - 08.2020

DBA -SME

Infinite Computer Solution
09.2015 - 12.2016

Sr Consultant DBA

Data Q Apps Technology
11.2014 - 08.2015

DBA Consultant

TECHMATRICS SOLUTIONS PRIVATE LIMITED
11.2008 - 11.2014

Bachelor of Engineering - ECE

Gyanendra Kumar Upadhyay