Summary
Overview
Work History
Education
Skills
Languages
Certification
Accomplishments
Timeline
Generic

Komal Gupta

Noida

Summary

Results-driven IT professional with 6+ years of comprehensive experience, including over 4+ years as an Oracle Database Administrator and 2 years in mobile device support. Skilled in managing and maintaining database environments, ensuring high availability, and optimizing performance. Adept at providing end-to-end technical support for mobile devices and ensuring seamless integration with enterprise systems. Proven ability to deliver solutions aligned with business objectives and client requirements.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Oracle Database Administrator

TATA CONSULTANCY SERVICE
Noida
11.2017 - Current
  • I have been working as an Oracle DBA on a 24/7 BAU, project production support basis.
  • Good understanding of database architecture.
  • Handling user management, table space management, and performance issues.
  • Exposure of PSU patching on standalone databases, RAC databases, and SAP databases grid home.
  • I have worked on Oracle databases of 11g, 12c, and 19c with RAC, standalone, and Data Guard configuration.
  • Exposure of Standby Rebuild Activity.
  • Exposure of refresh activity for schema and full database.
  • Performed backup and recovery operations using the RMAN utility and Data Pump.
  • Exposure of setup and configuration data guard.
  • Exposure of database creation for the 19c version for standalone and RAC.
  • OEM configuration.
  • Automation initiative for repetitive administrative work using shell scripts.
  • Checking the daily database reports twice a day and taking proactive measures to prevent any database outages, such as database availability checks, space checks, alert logs, archive destination space, listener availability, and blocking locks, etc.
  • Basic knowledge of MariaDB.
  • Documented troubleshooting steps and solutions in a knowledge base for future reference.
  • Experience in Capacity and Patching Planning.

Education

Bachelor of Computer Applications -

BBD University
Lucknow
07-2017

Skills

  • Database Management: Oracle Database 11g, 12c, 19c, RMAN, Data Guard, ASM, OEM, SQL, MariaDB
  • Patch management
  • Capacity planning
  • Performance tuning: query optimization, AWR/ASH reports, indexing strategies
  • Backup and Recovery: RMAN backup strategies, Flashback recovery, Data Pump
  • Mobile Device Support: Android, iOS, and MDM solutions (eg, Intune, AirWatch)
  • Tools and Technologies: Unix/Linux, Windows Server, Shell scripting
  • Soft skills: troubleshooting, communication, problem-solving, team collaboration, leadership
  • Management Tool: BMC Remedy (Incident Management, Change Management, Problem Management)

Languages

Hindi
First Language
English
Proficient (C2)
C2

Certification

  • Oracle Database 12c SQL Certified Associate (External)
  • AWS Certified Solutions Architect - Associate (External)
  • ITIL Foundation Certification
  • Unix/Linux basics and commands_Foundation
  • Generative AI Foundation

Accomplishments

  • Awarded with 6 “On the Spot Award” from time to time.
  • Awarded with 6 "On the Spot (Team) Award"
  • Awarded with Award for Excellence, Beyond Performance Award, Applause Award and Service Commitment Award
  • I have lead the Team as Lead the offshore Team for 2 Years.
  • Continuous Feedback Star Certificate

Timeline

Oracle Database Administrator

TATA CONSULTANCY SERVICE
11.2017 - Current

Bachelor of Computer Applications -

BBD University

Similar Profiles

CREATE PROFILE
Komal Gupta