I will design, fix and optimize your sql db and stored procedures
About this Gig
Is your SQL Server database slow, throwing errors, or poorly designed? I can fix it, optimize it, or build it from scratch the right way.
--- What I fix ---
Slow or broken queries (query tuning, execution plan analysis)
Buggy stored procedures, functions or triggers
Data inconsistencies and integrity issues
Missing or incorrect indexes
Deadlocks, timeouts and concurrency issues
Entity Framework / ADO.NET database layer problems
--- What I design & build ---
Database schema design from scratch (normalized, scalable)
Stored procedures for complex business logic
User-defined functions (scalar & table-valued)
Triggers for auditing and automation
Views for reporting and data access layers
Database migration scripts
--- How it works ---
1. Share your issue, schema or requirements
2. I review and confirm scope before you order
3. I deliver clean, tested SQL scripts with clear explanations
Send me a message first I always confirm I can solve your exact problem before you spend a cent.
Warm regards,
Fenil
Platform:
MongoDB
•
MS SQL
•
MySQL
•
PL/SQL
•
PostgreSQL
•
SQLite
•
SQL Server
Expertise:
Big data
•
Data structure
•
Design
•
Normalization
•
SQL
FAQ
Will you need direct access to my SQL Server?
No. A script export of your schema, sample data, and the relevant stored procedures is enough for most tasks. For complex performance work, sharing an anonymised execution plan or query stats also works well.
My query is very slow — can you speed it up?
Yes. I analyse the execution plan, identify bottlenecks (missing indexes, full scans, bad joins), and rewrite or tune the query. Share the query and table structure and I'll tell you what I can improve before you order.
Can you fix a stored procedure that is giving wrong results?
Absolutely. Logic bugs in stored procedures are one of the most common issues I fix. Share the procedure, expected output, and actual output — I'll diagnose and correct it.
Do you work with existing databases or only new ones?
Both. Most of my work is on existing databases — fixing, optimising, and extending them. I adapt to your current schema and naming conventions rather than forcing a rewrite.

