Looks Like This Service Is On Hold
I will write and optimize sql queries and mongodb aggregations
About this Gig
Need a query for a report, export or application, or want to improve an existing slow query?
I'm Raphael from Smart Experiences in Germany. I write and review SQL queries and MongoDB aggregations with a focus on correct results, readable code and practical performance improvements.
Depending on the agreed scope, I can help with:
- Joins, filters, grouped reports and aggregations
- MongoDB aggregation pipelines
- Query rewrites and execution-plan analysis
- Index recommendations
- Views, stored procedures and reusable queries
You receive the agreed queries with an explanation of the changes and assumptions. Performance depends on your data, schema and environment; any improvement must be checked against representative data.
Please send your database engine/version, schema, current query and expected result before ordering. Use anonymized sample data where possible. We confirm query count and complexity first. Full database audits, migrations, infrastructure changes and ongoing support are separate scopes.
For a broken query or database error, please use my troubleshooting service. Communication is available in German and English.
Database type:
Non-relational database
•
Relational database
Platform:
MongoDB
•
MySQL
•
SQLite
•
SQL Server
Expertise:
SQL
•
NoSQL
My Portfolio
FAQ
Can you work with production data?
Yes, but preferably with read-only access or anonymized data exports (JSON/CSV/SQL dump). I always follow data privacy best practices.
Do you optimize existing queries?
Absolutely. I analyze query plans (EXPLAIN/ANALYZE), suggest indexes, and rewrite queries for better performance.
Can you create stored procedures, functions, and views?
Yes, I can create and optimize stored procedures, views, and user-defined functions in MySQL and SQL Server.
Do you also work with MongoDB?
Yes. I build and optimize MongoDB aggregation pipelines (match, group, lookup, facet, etc.) for efficient results.
What do you need from me to start?
Please provide your database type/version, schema or sample data, and a clear description of your requirements.
Do you sign NDAs?
Yes, I am open to signing a non-disclosure agreement if required.

