Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Abhigyan Kumar Piyush

Pune

Summary

Accomplished Oracle Application Database Administrator at Capgemini, skilled in performance tuning and backup recovery using RMAN. Successfully migrated databases with minimal downtime while enhancing system availability. Proficient in SQL and incident management, delivering robust support and technical documentation to optimize database operations and user satisfaction.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Oracle Application Database Administrator

Capgemini
Pune
10.2021 - Current
  • Managed day-to-day operations of the production environment, ensuring high availability.
  • Coordinated with vendors to resolve hardware and software-related issues.
  • Developed backup and recovery procedures using the RMAN utility.
  • Deployed scripts to automate various tasks, such as backups and log rotation.
  • Migrated existing databases from one version to another, with minimal downtime.
  • Provided support to end users regarding any issues related to Oracle applications or databases.
  • Configured ASM storage for better management of physical disks used in the cluster environment.
  • Conducted regular health checks for all databases running on different platforms.
  • Created tablespaces, users, roles, and profiles to manage database security.
  • Monitored database performance, tuning the system for optimal performance.
  • Managed user access control through the creation, modification, and deletion of roles and privileges based on ServiceNow tickets.
  • Assisted in troubleshooting application issues related to the Oracle Database Server.
  • Analyzed disk usage and allocated disk space accordingly.
  • Configured OCI basic components, including virtual networks, storage, and compute instances.

Education

Bachelor of Technology (C.B.C.S.) (2014 COURSE) - ELECTRONICS & TELE-COMMUNICATION

Bharati Vidyapeeth ( Deemed To Be University)
Pune, India
08-2021

SENIOR SCHOOL CERTIFICATE EXAMINATION,2016 (CBSE Board) -

Kendriya VidyalayaNo.1 Adampur, Jalandhar
Jalandhar , Punjab
05-2016

SECONFARY SCHOOL EXAMINATION (SESSION : 2012-14) (CBSE Board) -

Kendriya VidyalayaNo.1 Adampur, Jalandhar
Jalandhar , Punjab
05-2014

Skills

  • Technical - C, C
  • Shell scripting
  • SQL , PL/SQL - Intermediate
  • Oracle Database 12c and 19c Management
  • Performance Tuning: AWR, SQL Tuning
  • System Administration
  • Access Management
  • Oracle E-Business Suite (EBS) R1228
  • Backup and Recovery: RMAN, ASM
  • Technical documentation
  • Ticket Handling
  • Cloud Services – Oracle Cloud Infrastructure (OCI)
  • Tools: SQL Developer, Oracle Enterprise Manager (OEM)
  • Incident Management
  • Patch management

Certification

  • Oracle Cloud Data management 2022 Foundations Certified Associate
  • Oracle Cloud Infrastructure 2022 Certified Foundations Associate
  • Oracle Cloud Data management 2023 Foundations Certified Associate
  • Oracle Cloud Infrastructure 2023 Certified Foundations Associate
  • Oracle Cloud Infrastructure 2024 Certified Foundations Associate
  • Oracle Cloud Infrastructure 2024 Data Certified Foundations Associate
  • Oracle Cloud Infrastructure 2024 Generative AI Certified Professional

Languages

English
First Language
Hindi
Proficient (C2)
C2

Timeline

Oracle Application Database Administrator

Capgemini
10.2021 - Current

Bachelor of Technology (C.B.C.S.) (2014 COURSE) - ELECTRONICS & TELE-COMMUNICATION

Bharati Vidyapeeth ( Deemed To Be University)

SENIOR SCHOOL CERTIFICATE EXAMINATION,2016 (CBSE Board) -

Kendriya VidyalayaNo.1 Adampur, Jalandhar

SECONFARY SCHOOL EXAMINATION (SESSION : 2012-14) (CBSE Board) -

Kendriya VidyalayaNo.1 Adampur, Jalandhar

Similar Profiles

CREATE PROFILE
Abhigyan Kumar Piyush