I will design and optimize databases, write sql, nosql queries, and create erd diagrams
Experienced Programmer, AI, FullStack Engineer and Fluent Translator
Level 1
Has met certain performance criteria and shows strong potential in the marketplace.
About this Gig
Confused by complex queries? Need a solid database schema before you start building? I'll sort it out.
Database design and querying is a core part of my work and one of the areas I enjoy most. Whether you need a clean ERD, optimized SQL queries, or a full NoSQL schema for MongoDB, I'll deliver structured, documented, and scalable solutions.
What I cover:
- Database design normalized relational schemas (1NF, 2NF, 3NF, BCNF)
- ERD diagrams professional entity-relationship diagrams with cardinality
- SQL queries SELECT, JOIN, GROUP BY, subqueries, window functions
- Stored procedures, triggers, and views
- MySQL, PostgreSQL, SQL Server
- MongoDB schema design, aggregation pipelines, indexing
- Performance tips indexes, query optimization, execution plans
What you get:
- Clean, well-commented SQL scripts or MongoDB queries
- ERD as an image (PNG/PDF) and editable format where possible
- Brief explanation of design choices and any trade-offs
Share your requirements, existing tables, or dataset details and I'll tailor the solution to your exact needs.
Platform:
MongoDB
•
MS SQL
•
MySQL
•
PostgreSQL
Expertise:
SQL
•
NoSQL
•
ER diagrams
•
Query optimization
FAQ
Which database systems do you work with?
MySQL, PostgreSQL, SQL Server, and MongoDB. If you're using SQLite for a small project, I can handle that too.
Can you reverse-engineer a schema from existing data?
Yes, share your data or existing tables and I'll build the ERD and schema around it.
Will the queries work with my specific database version?
I'll write standard SQL that works across major versions. Let me know which system you're using and I'll optimize for it.
Do you fix slow or broken queries?
Absolutely. Query optimization and debugging is included, just share what you have.
Can you design a MongoDB schema instead of relational?
Yes. I'll design the collections, embedding/referencing strategy, and aggregation pipelines based on your use case.
