Summary
Overview
Work History
Education
Skills
Languages
Personal Information
Incident Response and Troubleshooting Activities
Monitoring and Preventive Maintenance Activities
Core DBA Activities
Accomplishments
Timeline
Generic

AKARSHAN SARNA

Summary

Oracle Database Administrator

Oracle Database Administrator with over 7 years of experience in optimizing database performance and ensuring high availability on Linux and Exadata platforms. Expertise in Oracle Data Guard, GoldenGate, and advanced performance tuning using AWR, ADDM, and OEM. Proven track record in managing large-scale database environments, implementing robust backup strategies, and maintaining data integrity. Strong problem-solving abilities with a focus on proactive monitoring and incident resolution. Excellent communication and collaboration skills, dedicated to meeting SLAs and supporting critical business operations.

Total Experience: 10+ years

Oracle DBA Experience: 7 years

Overview

10
10
years of professional experience

Work History

Senior Database Administrator - Oracle

GXI Networks INC
Noida
10.2024 - Current
  • Administered and maintained Oracle databases (11g, 12c, 19c), handling installation, configuration, patching, upgrades, and daily operations across RAC and non-RAC environments on Linux and Exadata platforms.
  • Performed database refreshes and environment cloning from Production to Non-Production using RMAN, Data Pump, and Oracle GoldenGate, ensuring data consistency and minimal downtime.
  • Designed, implemented, and managed enterprise-grade backup and recovery strategies, including regular restore validations and troubleshooting complex RMAN backup and recovery issues to ensure data integrity and high availability.
  • Successfully led the migration of database backups from IBM TSM to Dell Druva, improving backup reliability, reducing operational overhead, and enhancing recovery efficiency.
  • Played a key role in database migration from On-Premises infrastructure to Oracle Cloud Infrastructure (OCI), supporting database provisioning, validation, performance testing, and post-migration stabilization.
  • Proactively optimized database performance through in-depth analysis using AWR, ADDM, OEM, ASH, Explain Plan, Toad, OSWatcher, and ExaWatcher, resolving performance bottlenecks and improving system stability.
  • Managed and supported Oracle Data Guard configurations, including physical and logical standby databases, monitoring replication health, resolving lag issues, and performing switchover/failover operations.
  • Oversaw Oracle GoldenGate setup, configuration, monitoring, and troubleshooting, ensuring real-time data replication, high availability, and business continuity.
  • Implemented and enforced database security best practices, including Transparent Data Encryption (TDE), auditing, and access controls, ensuring compliance with organizational and regulatory standards.
  • Conducted proactive database monitoring and health checks, tracking backup status, Data Guard lag, storage capacity, GoldenGate replication health, and managing incidents, changes, and problem records in line with ITIL processes.

Oracle Database Administrator

Alchemy Techsol / Kyndryl Solutions India Pvt Ltd
Noida
06.2021 - Current
  • Administer and maintain Oracle databases (11g, 12c, 19c) including installation, configuration, and daily operations for both RAC and non-RAC environments on Linux and Exadata platforms.
  • Conduct database refreshes from production to other environments using RMAN, Data Pump, and GoldenGate.
  • Design and implement a robust backup strategy, conduct periodic restorations, and resolve RMAN backup issues to ensure data integrity and availability.
  • Optimize database performance through comprehensive analysis using tools such as AWR, ADDM, OEM, ASH, Explain Plan, Toad, OSWatcher, and ExaWatcher. Address performance issues to maintain efficient database operations.
  • Manage Oracle Data Guard configurations, including physical and logical standby databases.
  • Oversee Oracle GoldenGate environment setup and configuration to ensure seamless data replication and high availability.
  • Implement and manage database security measures, including Transparent Data Encryption (TDE) and audit trails to protect sensitive data and ensure compliance.
  • Monitor and review daily backups, Data Guard lag, capacity, GoldenGate replication, and open incidents/change reports. Coordinate with applications DBA team and developers to address and resolve issues promptly.
  • Handle partition administration for tables and indexes, and oversee patching, upgrades, and both homogeneous and heterogeneous database migrations.
  • Develop and administer disaster recovery plans to guarantee data integrity and business continuity. Plan and execute tests to validate recovery strategies.
  • Oversee database monitoring using OEM and cron jobs, taking corrective actions based on alerts to ensure system reliability and performance.
  • Work closely with internal and external support teams to meet SLAs and KPIs, especially during major incidents or critical system issues.

Senior Technical Support Executive

Xavient Digital/Telus International
Noida
07.2019 - 06.2021
  • Managed and maintained 11g/12c databases on Linux and Exadata platforms, ensuring high availability and performance.
  • Performed database refreshes using RMAN (Recovery Manager) and Data Pump utilities to ensure data integrity and availability.
  • Responded to and resolved incidents, changes, and requests, maintaining smooth database operations.
  • Monitored and addressed OEM (Oracle Enterprise Manager) and CRON job alerts to proactively manage system performance and health.
  • Created and managed restore points to facilitate data recovery and ensure system resilience.
  • Executed schema and table-level data copy activities using Impdp (Data Pump Import) and Expdp (Data Pump Export) utilities for data migration and backup purposes.
  • Managed database users, objects, and privileges to ensure proper access controls and security.
  • Developed and implemented application code changes to enhance database functionality and performance.
  • Generated AWR (Automatic Workload Repository), ADDM (Automatic Database Diagnostic Monitor), and ASH (Active Session History) reports to share with application team.
  • Configured and scheduled RMAN backups to ensure regular data protection and recovery options.
  • Collaborated with application teams to coordinate scheduled changes and application releases, aligning database activities with overall application development and deployment plans.

Engineer Product Support

HCL Technologies Ltd.
Noida
10.2015 - 12.2016
  • Oversaw and facilitated technical support to customer accounts, ensuring high levels of satisfaction and account retention.
  • Delivered technical support for telecom products through both calls and emails, addressing and resolving customer issues effectively.
  • Provided assistance with billing inquiries, resolving discrepancies and ensuring accurate account charges.
  • Implemented strategies to enhance customer retention, addressing concerns and providing solutions to maintain long-term relationships.

Education

Bachelor Of Commerce -

Delhi University
New Delhi, DL
01.2018

12th Standard -

NIOS Noida
New Delhi, DL
01.2014

10th Standard -

CBSE Board
New Delhi, DL
01.2012

Skills

Operating Systems:

  • Oracle Linux
  • IBM AIX
  • Windows

RDBMS :

  • Oracle 19c/12c/11g

Ticketing Tools:

  • ServiceNow
  • Remedy
  • JIRA

Data Replication:

  • Oracle GoldenGate

Tools:

  • PuTTY
  • WinSCP
  • TOAD
  • Secure CRT
  • OEM

Tuning Tools:

  • OEM (Oracle Enterprise Manager)
  • AWR (Automatic Workload Repository)
  • ADDM (Automatic Database Diagnostic Monitor)
  • ASH (Active Session History)

Languages

  • English
  • Hindi

Personal Information

  • Date of birth: Nov/18/1996

Incident Response and Troubleshooting Activities

  • Joining calls for P3, P2, and P1 issues
  • Alert log incidents
  • SQL performance tuning
  • Connectivity issues
  • Long-running queries
  • Execution plan management
  • User account and privileges management
  • ⁠Locks Blocking and Deadlock
  • Redo log and archive log management
  • Storage-related issues
  • Database recovery
  • Replication lag in GoldenGate/Data Guard
  • Patch-related issues
  • Backup and restore failures
  • Purging and space reclaim

Monitoring and Preventive Maintenance Activities

  • Filesystem capacity alerts
  • Tablespace capacity alerts
  • Standby alerts
  • GoldenGate alerts
  • DBA job failure alerts
  • Backup failure alerts
  • FRA alerts
  • Poor performance alerts
  • Processes and sessions alerts
  • DBPing failure alerts
  • DB health checks
  • Other OEM alerts

Core DBA Activities

  • DB home and database patching
  • Upgrading databases
  • Gathering statistics
  • Monthly RMAN restoration
  • Changes in production/pre-production environments
  • Database creation
  • Objects creation
  • Configuring GoldenGate
  • User creation
  • Creating standby databases
  • Script deployment
  • Export, import, and copy data
  • RMAN restoration & refresh
  • DB migration
  • Supporting OS patching
  • Supporting Exadata patching
  • Restore point creation and Flashback
  • Taking manual backups
  • Generating AWR, ADDM, and ASH reports
  • Decommissioning
  • Switchover and Failover on Data Guard

Accomplishments

  • Successful Database Migrations: Led the migration of several large-scale databases from legacy systems to Oracle 19c, minimising downtime and ensuring seamless transitions with zero data loss.
  • Compliance and Audit Success: Conducted monthly database restorations for Oracle Databases, achieving full compliance with internal and external regulations.
  • Streamlined Support Request Tracking: Optimised the process of tracking a high volume of Service Requests (SRs) raised on the Oracle Support website by integrating and utilising JIRA, leading to improved organisation, faster issue resolution, and enhanced communication with Oracle support teams.

Timeline

Senior Database Administrator - Oracle

GXI Networks INC
10.2024 - Current

Oracle Database Administrator

Alchemy Techsol / Kyndryl Solutions India Pvt Ltd
06.2021 - Current

Senior Technical Support Executive

Xavient Digital/Telus International
07.2019 - 06.2021

Engineer Product Support

HCL Technologies Ltd.
10.2015 - 12.2016

Bachelor Of Commerce -

Delhi University

12th Standard -

NIOS Noida

10th Standard -

CBSE Board

Similar Profiles

CREATE PROFILE
AKARSHAN SARNA