I will design relational database schema and write complex sql queries for postgresql
Web developer
About this Gig
Are you struggling with slow database queries? Or do you need a bulletproof relational database schema designed from scratch? Look no further!
I am a Database Engineer and Backend Developer with a strong background in Competitive Programming (Codeforces Max Rating: 1379). My brain is trained to handle extreme edge-cases and write highly optimized query logic. I do not just write queries; I architect data structures that scale.
What I can do for you:
- Relational Database Schema Design and Normalization (1NF, 2NF, 3NF)
- Complex SQL Query Writing (CTEs, Advanced Joins, Window Functions)
- Query Performance Tuning (Using EXPLAIN ANALYZE, B-Tree Indexing)
- PL/pgSQL Development (Custom Functions, Procedures, Triggers)
- Database Migration and Data Cleaning (Excel/CSV to PostgreSQL/MySQL)
Databases I Excel In:
- PostgreSQL, MySQL, Prisma ORM
Why Choose Me?
- Clean, documented, and production-ready code.
- 100% logical precision with edge-case handling.
- Maximum query execution speed optimization.
Please drop a message with your database schema or requirements before placing an order. Let us make your database lightning fast!
Database type:
Relational database
Platform:
MySQL
•
PostgreSQL
Expertise:
Data structure
•
ERD
•
Normalization
•
SQL
•
Performance
FAQ
Do you need my live database credentials to optimize or design it?
No, your data security is my priority. You can just share the database schema structure (DDL script) and some dummy data. I will write, test, and optimize everything on my local machine and send you the clean, verified SQL script.
Can you optimize database queries generated via ORMs like Prisma?
Yes, absolutely! I have extensive experience with Prisma ORM and PostgreSQL. I can analyze the generated raw SQL queries, pinpoint bottlenecks using EXPLAIN ANALYZE, and suggest exact indexes or schema improvements to boost speed.
What metrics do you look at during Query Performance Tuning?
I deep-dive into query execution plans using EXPLAIN ANALYZE. I scan for costly Sequential Scans (Seq Scan), optimize heavy multi-table JOINS, convert complex subqueries into clean CTEs, and implement efficient B-Tree indexing strategies.
I have a custom/complex business requirement. Can you design the schema?
Yes. With my competitive programming background, I excel at mapping out complex logical flows. Just share your business rules, and I will handle normalization (1NF, 2NF, 3NF), define foreign key constraints, and deliver a production-ready ERD diagram and database schema.
