I will design and optimize databases, write sql, nosql queries, and create erd diagrams

Pakistan

I speak Urdu, English

14 orders completed

Experienced Programmer, AI, FullStack Engineer and Fluent Translator

I'm a versatile professional, and a Computer Science student ready to assist you in various creative, communication, and technical tasks. With a passion for effective communication, I excel in conveyi...

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.

Database type:

Centralized database

Key-value database

Platform:

MongoDB

MS SQL

MySQL

PostgreSQL

Expertise:

SQL

NoSQL

ER diagrams

Query optimization