Pushpendra Kumpawat

About Pushpendra Kumpawat

I am a PostgreSQL Database Administrator with 2 years of experience in managing and optimizing databases on Linux environments, ensuring high availability, security, and performance. Skilled in installation, configuration, and upgrades of PostgreSQL clusters on Linux systems. Strong in performance tuning – query optimization, indexing strategies, vacuuming, and analyzing execution plans. Hands-on with backup & recovery using pg_dump, pg_basebackup, and PITR strategies. Experienced in replication & HA setups (streaming replication, logical replication, pgPool-II, Patroni). Proficient in monitoring & alerting with Grafana, Prometheus, pgBadger, and native PostgreSQL views (pg_stat_activity, pg_stat_statements). Good knowledge of Linux administration – shell scripting, process management, cron jobs, and system performance tuning. Familiar with automation using Ansible for database deployments, configuration management, and routine DBA tasks. Experienced in security & compliance – user management, SSL/TLS, and access control. Work closely with developers on schema design, query optimization, and stored procedures.I am passionate about PostgreSQL, Linux, and automation tools, continuously learning advanced features like partitioning, JSONB, full-text search, and PostGIS. My goal is to grow into a Senior DBA role and contribute to building scalable, secure, and automated database infrastructures.

Experience

1. Database Administrator

   Casepoint

   Mar 2022 — Present · Surat, IN

   Surat, Gujarat, India

Education

• Pacific University Udaipur

  Bachelor of Technology, Computer Science

  2016 — 2020

• Kendriya Vidyalaya

  High School

  2016