Hemanth K

About Hemanth K

I\'m a senior Database Engineer with deep experience managing and optimizing enterprise-scale databases across DB2, PostgreSQL, MySQL, SQL Server in both on-prem and cloud environments. I specialize in Performance tuning, HADR setups, Encryption, Backup planning, Query optimization and Large-scale data migrations. I have Strong hands-on experience with AWS RDS and Aurora, including automation, scaling, monitoring, and cross-region replication.

Experience

1. Senior Database Engineer

   CGI Business Consulting

   Mar 2019 — Present · Sacramento, CA, US

   Managed and optimized large-scale DB2, PostgreSQL, MySQL, and SQL Server production environments supporting 24/7 mission-critical applications.PostgreSQLConfigured and administered PostgreSQL on LinuxPerformed database installations, upgrades, patches, and capacity planning across multiple clusters and environments.Improved query performance up to 10x by analyzing EXPLAIN/ANALYZE, optimizing indexes, and reducing execution bottlenecks.Customized autovacuum thresholds and implemented bloat control strategies for heavily updated tables.Performed VACUUM and ANALYZE operations to maintain table health, prevent bloat, and ensure optimal query performanceAutomated routine DBA tasks using Python, Bash, and SQL scripts (vacuum tuning, health checks, log cleanup, failover testing).Implemented enterprise-grade backup systems using pgBackRest with compression, retention policies, and off-site storage.Enforced least-privilege access, RBAC, and privilege audits; implemented RLS (Row-Level Security) for multi-tenant applications.

Education

• Wilmington University

  Master of Technology, Information Technology