Harshita Ugde

PostgreSQL Developer with 4.5 years of hands-on experience in database development, query optimization, performance tuning, ETL support, and production issue resolution. Experienced in designing and maintaining stored procedures, functions, triggers, views, and database objects for enterprise applications. Skilled in troubleshooting complex database issues, optimizing SQL queries, and collaborating with cross-functional teams to deliver reliable and scalable database solutions.

Seeking opportunities as a PostgreSQL Developer / Database Developer to leverage strong database expertise.

PostgreSQL Developer - Tata Consultancy Services

(2021-12)

• Developed and maintained stored procedures, functions, triggers, and views to support efficient database operations.
• Optimized SQL queries and improved database performance using pgBadger reports, indexing strategies, and execution plan analysis.
• Reduced execution time of long-running procedures from 2–3 hours to approximately 15 minutes, achieving over 85% performance improvement.
• Collaborated with business and ETL teams to gather requirements, validate data mappings, and support successful ETL implementations.
• Improved database performance through query tuning, indexing optimization, and performance analysis.
• Supported cross-functional teams by providing data-driven solutions and database-related support.
• Resolved over 100 production support tickets monthly, ensuring data accuracy, system stability, and operational continuity.
• Shared data with vendors based on business requirements, ensuring accuracy and alignment with organizational objectives.
• Performed ETL testing and data validation to ensure data accuracy, consistency, and completeness across source and target systems.

B.Tech - Computer Science Engineering - Sagar Institute of Research & Technology (SIRT), Indore (2017-08 - 2021-12)