Summary
Overview
Work History
Education
Skills
Certification
Technicalskills
Personal Information
Awards
Rolehistory
Timeline
Generic

Adarsh VB

Pune,MH

Summary

Adarsh is a seasoned Oracle Apps and Core DBA with over 11 years of technical expertise. He specializes in managing intricate Oracle environments and has a track record of 8+ years of hands-on experience with Oracle Database 11g, 12c, and 19c, as well as Oracle E-Business Suite R12.1.3 and R12.2.8. Adarsh excels in critical tasks such as installation, configuration, patching, cloning, and Data Guard implementation. His proficiency extends to Oracle Cloud technologies, including OCI, IDCS, OMC, and Azure, which he seamlessly integrates to optimize operational efficiency and scalability. Adarsh is skilled in SQL and proficient in leveraging automation and scripting to streamline processes, minimize downtime, and enhance system performance. He also has 3+ years of operational support experience encompassing UC4 schedule monitoring, Oracle user account management, and seamless code migrations across development, testing, and production environments. Adarsh is recognized for his leadership skills and consistent delivery of client expectations. He combines technical expertise with strategic insight to provide reliable and innovative database solutions.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Manager (Technical Support)

Global
04.2022 - Current
  • Company Overview: Current Organization - Global Pune, India
  • Project / Client Name / Location – XYZ (USA)
  • Installation of Oracle Databases 12C/19C and EBS Application 12.2.8
  • Performed oracle database upgrade from 12C to 19C
  • Performing day to day activities like database patching, monitoring, health checkup and user activities
  • Monitoring, troubleshooting RMAN backups and cloning
  • Monitoring and controlling Oracle 12C and 19C databases using oracle enterprise manager 13C(OEM)
  • Managing and installing OIC agents in servers
  • Consistently monitored alert log files, trace files, user sessions daily and took appropriate actions to kill Inactive sessions
  • Maintaining tablespace management, datafiles, tables, indexes, multiplexing control files and redo log files
  • Performing daily refresh(clone) from block volume cloning (OCI) method from Production
  • Performing yearly basis certificates renewal and upload in instances
  • Tracing, troubleshooting with database performance
  • Giving proper assistance or guidelines to Developers for any resolution
  • I used to explain plan, AWR, ADDM, SQL Trace and TKPROF to tune the database
  • Coordinating with team members and giving proper updates
  • WebLogic services down process and upload EAR files
  • We have a central support tool, where cases are queued up daily
  • We need to pick up cases and resolve depending upon the severity of the bug
  • Performed System Administration Tasks such as Creating Users, Purging, Run Concurrent Requests and Compiling Invalid Objects
  • Writing shell scripts for oracle housekeeping tasks, RMAN backup, Alert notification, Automation scripts
  • Managing and monitoring Oracle Workflow
  • Managing Vertex monthly tax code updates and vertex database
  • Monitoring and Raising Oracle Service Request
  • Code Migration through FNDLOAD, WFLOAD
  • Maintaining GTM services and updating certificates
  • Registering & configuring remote Application Printers
  • Oracle Applications System Administration such as managing concurrent programs and requests, application security, user registration, assignment of responsibilities and Profile options
  • Working with the Development Team to fix the problems in Applications
  • Raising and supporting Oracle SR through Metalink
  • Managing Custom concurrent managers, Request groups, and Concurrent programs, Users, responsibilities, functions, Menus, Folders
  • Handling and managing ServiceNow priority tickets, service tasks and change requests
  • SSL Certificate update in EBS OCI Load Balancer and database wallet
  • Current Organization - Global Pune, India
  • Project / Client Name / Location – XYZ (USA)

Software Engineer

XYZ Technologies
04.2015 - 03.2022
  • Company Overview: Previous Organization - XYZ Technologies
  • Project / Client Name / Location – XYZ Corporation
  • Installation of Oracle Databases 11G / 12C and EBS Application 12.1.3/12.2.8
  • Performing day to day activities like database patching, monitoring, health checkup and user activities
  • Monitoring, troubleshooting RMAN backups and cloning
  • Monitoring and controlling Oracle 11g database using oracle enterprise manager 12C /13C(OEM)
  • Consistently monitored alert log files, trace files, user sessions daily and took appropriate actions to kill Inactive sessions
  • Maintaining tablespace management, datafiles, tables, indexes, multiplexing control files and redo log files
  • Maintaining database user account creation, modified, deactivated, privileges, roles, assigning responsibilities
  • Manages undo tablespaces, temporary tablespace
  • Managing and doing daily refresh instance from Production instance to handling production issues
  • Use of Remedy software for code migration using CVS
  • Tracing, troubleshooting with database performance
  • Analyzing and validating database objects
  • Giving proper assistance or guidelines to Developers for any resolution
  • I used to explain plans, AWR, ADDM, ASH, SQL Trace and TKPROF to tune the database
  • Coordinating with team members and giving proper updates
  • WebLogic services down process and upload EAR files
  • We have a central support tool, where cases are queued up daily
  • We need to pick up cases and resolve depending upon the severity of the bug
  • Performed System Administration Tasks such as Creating Users, Purging, Run Concurrent Requests and Compiling Invalid Objects
  • Writing shell scripts for oracle housekeeping tasks, RMAN backup, Alert notification, Automation scripts
  • Managing and monitoring Oracle Workflow
  • Managing Vertex monthly tax code updates and vertex database
  • Monitoring and Raising Oracle Service Request
  • Code Migration through FNDLOAD, WFLOAD
  • Managing and installing OIC in servers
  • Registering & configuring remote Application Printers
  • Oracle Applications System Administration such as managing concurrent programs and requests, application security, user registration, assignment of responsibilities and Profile options
  • Working with the Development Team to fix the problems in Applications
  • Raising and supporting Oracle SR through Metalink
  • Managing Custom concurrent managers, Request groups, and Concurrent programs, Users, responsibilities, functions, Menus, Folders
  • Handling and managing ServiceNow priority tickets, service tasks and change requests
  • Previous Organization - XYZ Technologies
  • Project / Client Name / Location – XYZ Corporation

Oracle Sysadmin Support

ABC Corporation
05.2012 - 04.2015
  • Company Overview: ABC Corporation is the world leader in the manufacture, distribution and service of electronic test tools and software
  • We are providing them with Oracle and IT-Operations support
  • Working with 24x7 IT Operations
  • Handle all major escalations and ensure speedy resolution
  • Handling Sysadmin issues like creating/modifying Oracle accounts, code migration from Dev to Test and Test to Prod, Other migrations like UC4 chains, programs, value sets etc
  • Monitoring UC4 (Appworx) jobs and Tivoli jobs
  • Submitting the jobs or chains as per developer’s requirement
  • Administered database user accounts: creation, modification, deactivated user accounts, assigning responsibilities and monitored access rights
  • Monitor various tools like UC4, Tivoli, Footprints, BMC Remedy and OpenNMS
  • Oracle Applications System Administration such as managing concurrent programs and requests, application security, user registration, assignment of responsibilities and Profile options
  • Escalating Network/power outages to appropriate teams by all types of mediums like telephonic/mail/ IM and raise a ticket for the same
  • Coordinate with Clients for monitoring work progress, escalation delays, etc
  • Monitoring calls for SLA adherence - Compliance to escalation
  • Giving proper assistance or guidelines to Developers for any resolution
  • Managing regular day-to-day problems logged by users at Service Desk With a team of Engineers as well as handling the administrative issues
  • ABC Corporation is the world leader in the manufacture, distribution and service of electronic test tools and software
  • We are providing them with Oracle and IT-Operations support

Education

S.S.C. -

H.S.C. -

MBA-IT -

01.2015

B. Com. -

01.2011

Skills

  • Oracle DBA 11g
  • Oracle DBA 12c
  • Oracle DBA 19C
  • Oracle Applications DBA
  • Monitoring
  • Installation
  • Backup and Recovery
  • Performance tuning
  • Cloning
  • CPU Patches
  • Shell scripting
  • RAC
  • ASM
  • WebLogic
  • Oracle Cloud
  • Service Now
  • Remote Desktop
  • Citrix
  • OEM
  • Remedy
  • Footprints
  • Project Director
  • UC4 Appworx
  • SQL Developer
  • Toad
  • Linux 64-bit OEL
  • RHEL
  • Cent OS
  • MS Server 2003
  • MS Server 2008
  • Win XP
  • Win Vista
  • Win 7
  • Database Upgrade
  • Unix
  • Database refresh
  • RMAN
  • AWR
  • ADDM
  • SQL Trace
  • TKPROF
  • Data Guard
  • Certificates renewal
  • Cloud technologies
  • Microsoft Azure
  • OMC
  • IDCS
  • Asserter
  • OIC
  • GTM
  • O&M
  • Oracle EBS
  • OCI
  • Load Balancer
  • Decision-making
  • Time management
  • Team leadership
  • Complex Problem-solving

Certification

  • Oracle 12 C Implementation Specialist
  • 1Z0-082 Oracle DB Administrator
  • Oracle Cloud Infrastructure 2023 Associate
  • AZ-103: Microsoft Azure Administrator
  • MCP (Microsoft Certified Professional)
  • Hardware and Networking
  • MCITP (Server 2008)

Technicalskills

Oracle DBA 11g/12c/19C, Oracle Applications DBA [12.1.3, 12.2.8], Monitoring, Installation, Backup and Recovery, Performance tuning, Cloning, CPU Patches, Shell scripting, RAC, ASM, WebLogic, Oracle Cloud, Service Now, Remote Desktop, Citrix, OEM, Remedy, Footprints, Project Director, UC4 Appworx, UC4 chain maintenance, SQL Developer, Toad, Linux 64-bit OEL/RHEL/Cent OS, MS Server 2003, MS Server 2008, Win XP, Win Vista, Win 7

Personal Information

  • Date of Birth: 05/23/90
  • Nationality: Indian
  • Marital Status: Married

Awards

  • Ekalavya Award
  • Customer Centricity Award

Rolehistory

  • Manager (Technical Support), Global, Pune, India, 04/2022 - Present
  • Sr. Software Engineer (Oracle DBA + Apps DBA), XYZ Technologies, XYZ Corporation, 04/2015 - 03/2022
  • Software Engineer (Oracle Sysadmin), ABC Corporation, ABC Data Centre, 05/2012 - 04/2015

Timeline

Manager (Technical Support)

Global
04.2022 - Current

Software Engineer

XYZ Technologies
04.2015 - 03.2022

Oracle Sysadmin Support

ABC Corporation
05.2012 - 04.2015

H.S.C. -

MBA-IT -

B. Com. -

S.S.C. -

Similar Profiles

CREATE PROFILE
Adarsh VB