Summary
Overview
Work History
Education
Skills
ACHIEVEMENTS
Timeline
Generic
Akashi

Akashi

Database Administrator
Noida

Summary

Database Administrator with 4.5 years of experience managing Oracle (11g–21c), PostgreSQL (15/16), and MySQL databases in 24x7 production environments. Strong expertise in performance tuning (AWR, ASH, execution plans), RMAN backup & recovery, Oracle Data Guard, PostgreSQL streaming replication, and database patching (RU/PSU using OPatch).

Experienced in Oracle Cloud Infrastructure (OCI) and AWS (EC2, VPC, S3, EBS) administration. Skilled in implementing oracle_fdw for cross-database integration, ensuring high availability, disaster recovery, and optimized database performance.

Overview

5
5
years of professional experience
2
2
Languages

Work History

Database Administrator

Vitrama Inc
09.2025 - Current
  • Administer and optimize Oracle 11g, 12c, 19c, and 21c, and PostgreSQL 15 and 16 databases in 24x7 production, UAT, and development environments on Linux platforms.
  • Manage and maintain Oracle Cloud Infrastructure (OCI), including Compute Instances, Block Volumes, VCN, and Object Storage.
  • Deploy and manage database workloads on AWS EC2, configure VPC (subnets, route tables, security groups), manage EBS volumes, and utilize S3 for backup and archival storage.
  • Perform advanced SQL performance tuning using AWR, ASH, ADDM, SQL Tuning Advisor, and Execution Plans (EXPLAIN / EXPLAIN PLAN) to resolve performance bottlenecks and improve query response time.
  • Design and optimize indexing strategies (B-Tree, Bitmap, Partitioned Indexes) to enhance execution efficiency and minimize full table scans.
  • Proactively monitor databases using Oracle Enterprise Manager (OEM), alert logs, and trace files to ensure system stability and high availability.
  • Implement and manage backup and recovery strategies using RMAN, pg_basebackup, Oracle Data Pump (EXPDP/IMPDP), and mysqldump, including point-in-time recovery (PITR).
  • Configure and maintain Oracle Data Guard (Physical and Active Data Guard), ensuring disaster recovery readiness and minimal RPO/RTO.
  • Set up and administer PostgreSQL streaming replication, WAL archiving, replication slots, and standby monitoring.
  • Implement oracle_fdw (Oracle Foreign Data Wrapper) to enable secure cross-database connectivity between Oracle and PostgreSQL environments.
  • Perform database patching using OPatch, including Release Updates (RU) and PSU application in standalone and RAC environments.
  • Execute database upgrades, cloning, refresh, and migration activities across multiple environments.

Database Administrator

Comviva Technologies
06.2021 - 09.2025
  • Streamlined backup and recovery processes, enhancing overall system stability and availability.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
  • Optimized database performance by monitoring health and implementing tuning recommendations.

Education

BE - CSE

Chandigarh University
05-2021

Skills

Databases: Oracle (11g, 12c, 19c,21c), PostgreSQL (v15, v16), MySQL,Patching,AWS, OCI

Backup & Recovery: RMAN, Oracle Data Pump (EXPDP/IMPDP), pg_basebackup,pg_dump

Performance Tuning: AWR, ASH, EXPLAIN PLAN, SQL Trace, PostgreSQL EXPLAIN/ANALYZE

ACHIEVEMENTS

Unit Level Discretionary Award-Rising start-Agility Provided support to the DFS Core Team during product testing on Oracle Cloud, ensuring optimal database performance, availability, and issue resolution., CREDO CAP- RESPONSIVENESS Created partitions for the entire 2024–2025 year and took full ownership of complex production calls, ensuring seamless operations and issue resolution.duction calls.

Timeline

Database Administrator

Vitrama Inc
09.2025 - Current

Database Administrator

Comviva Technologies
06.2021 - 09.2025

BE - CSE

Chandigarh University
Akashi Database Administrator