Pudi Tirumala Ganesh

About Pudi Tirumala Ganesh

Results-driven PostgreSQL DBA & PLSQL Developer with 2.5 years of experience in database administration, query optimization, and performance tuning. I help companies enhance database efficiency, improve query execution time, and ensure high availability by implementing robust database strategies.How I Add Value: Optimized SQL queries for a high-traffic e-commerce platform, reducing query execution time by 40% and improving overall application performance. Implemented database replication and backup strategies, ensuring 99.9% uptime and seamless disaster recovery. Designed PL/pgSQL procedures and functions to automate repetitive tasks, saving 10+ hours of manual work per week. Led data migration from Excel sheets to PostgreSQL for a government organization, ensuring 100% data integrity.Beyond my technical expertise, I enjoy collaborating with cross-functional teams to solve complex database challenges. I thrive in environments where I can optimize performance, automate processes, and contribute to business growth.I get excited about opportunities where I can leverage PostgreSQL expertise to build scalable, secure, and high-performing databases.Let’s connect! Reach me at p••••••••@gmail.com.

Experience

1. Database Administrator

   Invensis

   May 2023 — Present · Vijayawada, IN

   Project: APCO (Andhra Pradesh State Handloom Weavers Cooperative Society – HRMS & E-Commerce System)Project Overview:The project includes Inventory Management, Sales, POS (Point of Sale), Discount Management, and Reporting Modules. Key responsibilities include database administration, performance tuning, and developing complex SQL queries for business reports.Key Responsibilities & Contributions: Database Administration & Optimization • Managed database security, created users, and controlled permissions. • Performed database installations, upgrades, backup & restore operations. • Optimized complex queries and tuned PostgreSQL server parameters for better performance. Development & Data Processing • Developed PL/pgSQL procedures, functions, and triggers to support application logic. • Designed and implemented complex SQL queries for reports on sales, inventory, and customer analytics. • Automated scripts to extract, transform, and load (ETL) data from Excel to PostgreSQL. Performance Monitoring & High Availability • Worked on replication services to ensure data consistency and high availability. • Monitored and fine-tuned PostgreSQL performance using pg_stat_statements, logs, and EXPLAIN ANALYZE. • Created multiple PostgreSQL instances on a single server to support various applications. Reporting & Data Insights • Developed MIS Reports to analyze highest-selling products, showroom performance, and revenue trends. • Provided insights on sales revenue, customer demographics, and stock availability. Automation & Scripting • Automated alerts for CPU usage, database size, disk space, and system health checks. • Created custom SQL scripts for scheduled tasks using PostgreSQL extensions like pg_cron.This role has strengthened my expertise in PostgreSQL administration, performance tuning, query optimization, and database security

Education

• Lendi Institute of Engineering and Technology (LIET)

  Bachelor of Technology - BTech

  2012 — 2016