Adesh Yadav
Database Administrator
Noida
Summary
Skilled PostgreSQL Database Administrator with 4+ years of experience in managing production databases in Banking and Government sectors. Expertise includes PostgreSQL Administration, Performance Tuning, High Availability, and Disaster Recovery. Proven ability in deploying environments, troubleshooting performance issues, and automating infrastructure.
Overview
4
4
Certifications
4
4
years of professional experience
Work History
Senior PostgreSQL Database Administrator
BUSINESSNEXT
Noida
06.2026 - Current
- Managed PostgreSQL production databases for Banking and BFSI customers, ensuring high availability and performance for clients including HDFC Bank, Punjab National Bank (PNB), and Muthoot Finance.
- Provisioning and deploying new PostgreSQL database servers on AWS EC2 and On-Premise Linux infrastructure.
- Managing Patroni High Availability clusters including failover, leader election and cluster maintenance activities.
- Administered PgBackRest backup infrastructure, implementing Full, Differential, Incremental Backups and Point-in-Time Recovery (PITR) to safeguard critical data.
- Troubleshooting production issues related to blocking sessions, deadlocks, replication lag, WAL growth, vacuum issues and long-running queries.
- Tuning PostgreSQL configuration parameters including Shared Buffers, Work Mem, Maintenance Work Mem, Checkpoints, WAL and Autovacuum.
- Working closely with Development, Application and Infrastructure teams for database performance improvement and production stability.
PostgreSQL Database Administrator
Innominds Pvt Ltd (EnterpriseDB Project)
Delhi
03.2025 - 06.2026
- Provided L2/L3 PostgreSQL production support for Government Railway projects under EnterpriseDB subscription.
- Managed EPAS, Patroni, EFM clusters, streaming replication, and logical replication environments to ensure high availability and reliability for critical applications.
- Configured Barman backup, disaster recovery, and PITR solutions to safeguard data integrity and ensure rapid recovery in case of failures.
- Performed PostgreSQL performance tuning, query optimization, and capacity planning to enhance database efficiency and support growing user demands.
- Implemented Streaming Replication failover automation using EFM (EnterpriseDB Failover Manager) to reduce manual intervention during outages.
- Configured Barman Backup, Disaster Recovery and PITR solutions.
- Identified, and resolved table/index bloat issues using VACUUM and VACUUM FULL.
- Collaborated with EnterpriseDB engineering team to resolve critical production incidents.
- PostgreSQL Community to EPAS migrations.
PostgreSQL Database Administrator
ANR Software Pvt. Ltd.
Noida
03.2022 - 03.2025
- Installed, configured and administered 50+ PostgreSQL production databases across Linux and Windows environments.
- Provided 24x7 Production Support while maintaining 99.9% database availability for global restaurant brands including McDonald's, Taco Bell, Chipotle and Pizza Hut.
- Executed PostgreSQL installation, upgrades, patch management, and database migration to ensure seamless operation and minimal downtime.
- Configured streaming replication, read replicas, and high availability environments to enhance database resilience and reliability.
- Oversaw backup and recovery processes using pg_dump, pg_restore, and Barman for multi-TB production databases, ensuring data integrity and availability.
- Optimized SQL queries, execution plans and PostgreSQL parameters resulting in significant application performance improvements.
- Configured PgBouncer Connection Pooling for high concurrent workloads.
- Developed automation scripts using Shell Scripting reducing repetitive DBA tasks and improving operational efficiency.
Education
Master of Computer Applications (MCA) -
Shobhit University
Meerut, UP01-2023
Bachelor of Computer Applications (BCA) - undefined
Shobhit University
Meerut, UP01-2021
Skills
PostgreSQL Administration
PostgreSQL Performance Tuning
Query Optimization
High availability solutions
Streaming Replication
Logical Replication
Disaster Recovery
PITR
WAL Management
PgBackRest
Patroni Cluster Administration
PostgreSQL Security
Barman
Certification
EDB Postgres AI DB Advanced v17 – EDB
Timeline
Senior PostgreSQL Database Administrator
BUSINESSNEXT
06.2026 - Current
PostgreSQL Database Administrator
Innominds Pvt Ltd (EnterpriseDB Project)
03.2025 - 06.2026
PostgreSQL Database Administrator
ANR Software Pvt. Ltd.
03.2022 - 03.2025
Bachelor of Computer Applications (BCA) - undefined
Shobhit University
Master of Computer Applications (MCA) -
Shobhit University