I will optimize mongodb aggregations and postgresql queries


About this gig
Is your Node.js backend slow due to unoptimized database queries? Whether you need complex MongoDB aggregation pipelines or advanced PostgreSQL query optimization, I am here to help.
As a backend-focused Software Engineer, I specialize in architecting high-performance database solutions and eliminating bottlenecks across both NoSQL (MongoDB) and SQL (PostgreSQL).
What I Offer:
MongoDB Aggregation: Multi-stage pipelines ($lookup,$facet, $group,$unwind) for complex data processing.
PostgreSQL Optimization: Query tuning, complex JOINs, CTEs, and EXPLAIN ANALYZE profiling.
Indexing & Performance: Compound, B-Tree, and GIN indexing to slash query latency.
Schema Architecture: Mongoose & Prisma/PostgreSQL schema modeling and validation.
Bug Fixing: Resolving slow queries, population issues, and N+1 bottlenecks.
Why Choose Me:
- Clean, production-grade code with error handling.
- Performance-first profiling & benchmarking.
- Clear communication and dedicated technical support
Please message me with your project details before placing an order to discuss the best architecture!
Get to know MONJURUL ISLAM
FULL Stack Engineer, Backend and MongoDB, PostgreSQL Optimization Specialist
- FromBangladesh
- Member sinceAug 2022
Languages
Bengali, English
My Portfolio
Other Software Development Services I Offer
FAQ
What do you need from me to start working?
I will need access to your schema design/models or the specific database structure you are working with. Also, sharing the current unoptimized code/query and sample mock data will help me test and deliver the pipeline quickly.
Can you write pipelines for complex multi-stage filtering and dashboards?
Yes, absolutely! I specialize in writing complex multi-stage pipelines using operators like $lookup, $facet, $group, $match, and $unwind. Whether you need relational data joins or complex metrics for a dashboard, I can optimize it.
Will your optimization change my existing database schema?
Usually, no. My primary goal is to write efficient queries and leverage proper indexing to speed up performance without breaking your schema. However, if I find critical flaws in your schema design, I will suggest architectural improvements first.

