Vinay Kumar Dumpa

Experience

1. Database Engineer

   Amazon

   Oct 2022 — Present · Hyderabad, IN

   Acting as a DBE managing Multi-TiB sized PostgreSQL and Oracle Databases.Key Roles:• Improved Observability of Database Systems by adding additional monitoring to DB Error logs and Statistics.• Setup RDS/Aurora PostgreSQL and Oracle Databases to provide High availability across regions and AZs.• Diagnosed and fixed Performance issues reported by Application teams through DB Instance, Hardware and Query tuning through settings and plan hints. Some of these issues include but not limited to- Query execution slowness - PostgreSQL Logical Replication slowness - High concurrent locking - Low Cache hit ratio - IO throttling - Vacuum runtimes - Checkpointing - Replication conflicts• Resolved OOM issues through Instance class and Memory parameter tuning.• Performed Day to Day tasks like DB Minor version upgrades, managing table bloating, Index rebuilds and Vacuuming.• Performed Major version upgrades like v11 to v14 and v14 to v16.• Driven RCA documentations and prepared action plans to improve service availability.• Reduced overall cost of expenditure by tuning Instances, IO configuration to right capacity, archiving DB data and log data in CloudWatch.• Created Python scripts for Data retrieval from Databases through Pandas and fastparquet.• Worked on DB heterogenous migrations using AWS DMS and fixed issues related to performance and functional throughout migration lifecycle.

Education

• Government Polytechnic Warangal

  Diploma, Diploma in Electronics and Communication Engineering

  2009 — 2012

• Vidya Jyothi Institute Of Technology

  Bachelor of Technology (B.Tech.), Electronics and Communication Engineering

  2012 — 2015

• Vidya Jyothi Institute Of Technology

  State board, General Studies

  2005 — 2009