Prasad Pote

Software Engineer

India3 yrs 1 mo experience

Key Highlights

Achieved 20-40% performance gains in database systems.
Expert in building high-performance stored procedures and complex queries.
Strong collaboration with cross-functional teams for optimized solutions.

Stackforce AI infers this person is a Database Developer specializing in performance tuning and optimization for enterprise applications.

Contact

Skills

Core Skills

Database DesignQuery Optimization

Other Skills

Stored ProceduresAzure DevOps ServerPostgreSQLQuery Performance TuningIndexingMySQLProduction SupportClickHouseGitlabZohoAzure devopsJenkinsAgile MethodologiesDblinkMicrosoft Excel

About

SQL / Database Developer with 3+ years of hands-on experience designing, optimizing, and maintaining production databases using PostgreSQL, SQL Server, MySQL, and ClickHouse. I specialize in building high-performance stored procedures, complex queries, indexing strategies, and scalable database solutions that directly improve reporting speed and system efficiency. My work has resulted in measurable performance gains (20–40%) in real-world applications including real estate analytics platforms and enterprise ERP systems. Experienced in cross-team collaboration with API/frontend developers, data migrations, multi-database operations, and translating business logic into optimized database structures. Core strengths include: • Query performance tuning & indexing • Stored procedures, triggers, and functions • Analytical and reporting queries • Production issue troubleshooting • Database design & optimization Currently seeking opportunities where I can contribute to scalable database systems and performance-driven engineering teams.

Experience

3 yrs 1 mo

Total Experience

1 yr 6 mos

Average Tenure

Current Experience

Estater

Database Developer

Aug 2024 – Feb 2026 · 1 yr 6 mos · Pune District · Remote

Developed and optimized PostgreSQL stored procedures, functions, triggers, and views for a large-scale real estate analytics platform.
Improved reporting query performance by up to 30% through indexing and query restructuring.
Implemented multi-database operations using DBLink.
Converted PostgreSQL logic into ClickHouse analytical queries for faster reporting.
Collaborated with API/frontend teams to deliver optimized database solutions.
Documented database architecture and business logic for maintainability.

Stored ProceduresAzure DevOps ServerDatabase DesignQuery Optimization

Sghi-tech

SQL Developer

Dec 2022 – Jul 2024 · 1 yr 7 mos · Pune · On-site

Designed and maintained relational database structures using SQL Server and MySQL in production environments.
Developed database objects including tables, views, indexes, constraints, stored procedures, and functions aligned with application requirements.
Optimized complex SQL queries involving joins, subqueries, group by clauses, analytical functions, and set operations to improve data retrieval performance.
Performed DDL, DML, DCL, and TCL operations while ensuring data integrity and consistency.
Supported backend database workflows for ERP-style applications, troubleshooting query issues and improving execution efficiency.
Collaborated with development teams to translate business requirements into efficient database solutions.
Applied indexing and query restructuring techniques to enhance reporting and transactional performance.
Familiar with Java fundamentals and database interaction concepts.

Stored ProceduresMySQLDatabase DesignQuery Optimization