You will get design and optimize your SQL Server database schema and queries
Top Rated
Project details
Is your database slow or poorly structured? I will design,
review, and optimize your SQL Server database whether
starting fresh or fixing what you have.
8+ years building SQL Server databases for enterprise ERP
systems, SaaS platforms, multi-tenant apps, and high-traffic
web applications.
What I deliver:
Schema Design
• Normalized relational schema (1NF, 2NF, 3NF)
• Primary keys, foreign keys, constraints
• Multi-tenant schema with full data isolation
• ERP, CRM, SaaS, and e-commerce database design
Query and Index Optimization
• Identify slow queries using execution plans
• Composite and covering index strategy
• Fix N+1 problems in Entity Framework and ORMs
• Reduce query time from seconds to milliseconds
Stored Procedures
• Optimized T-SQL stored procedures and functions
• Replace slow ORM queries with targeted procedures
Performance Audit
• Full schema and query pattern review
• Written report with prioritized recommendations
Works with SQL Server on-premise and Azure SQL.
All deliveries include SQL scripts and documentation.
Message me before ordering to discuss your requirements.
review, and optimize your SQL Server database whether
starting fresh or fixing what you have.
8+ years building SQL Server databases for enterprise ERP
systems, SaaS platforms, multi-tenant apps, and high-traffic
web applications.
What I deliver:
Schema Design
• Normalized relational schema (1NF, 2NF, 3NF)
• Primary keys, foreign keys, constraints
• Multi-tenant schema with full data isolation
• ERP, CRM, SaaS, and e-commerce database design
Query and Index Optimization
• Identify slow queries using execution plans
• Composite and covering index strategy
• Fix N+1 problems in Entity Framework and ORMs
• Reduce query time from seconds to milliseconds
Stored Procedures
• Optimized T-SQL stored procedures and functions
• Replace slow ORM queries with targeted procedures
Performance Audit
• Full schema and query pattern review
• Written report with prioritized recommendations
Works with SQL Server on-premise and Azure SQL.
All deliveries include SQL scripts and documentation.
Message me before ordering to discuss your requirements.
Database Type
MySQL, MS SQL, PostgreSQLWhat's included
| Service Tiers |
Starter
$150
|
Standard
$400
|
Advanced
$800
|
|---|---|---|---|
| Delivery Time | 1 day | 7 days | 14 days |
Number of Revisions | 1 | 2 | 5 |
Schema Diagram | - | ||
Permissions Setup | - | ||
Import/Export Data | - | - | |
Admin Panel Setup | - |
29 reviews
(28)
(1)
(0)
(0)
(0)
This project doesn't have any reviews.
MB
Michael B.
May 31, 2026
.NET Core | Angular | React Native Full-Stack
Aamir successfully completed a large and complex full-stack development project. He demonstrated strong expertise in .NET Core, Angular, and React Native throughout the engagement. His code quality was excellent, communication was clear, and he consistently delivered tasks on time. Aamir was proactive in solving technical challenges, paid close attention to requirements, and provided valuable suggestions that improved the final product. His professionalism, reliability, and technical skills made him a valuable part of the project. I would highly recommend Aamir for any .NET Core, Angular, React Native, or full-stack development work and would gladly work with him again in the future.
LB
Lyam B.
Mar 1, 2026
Upwork Message Metadata Inquiry
DM
Daniel M.
Feb 1, 2026
C# DLL Integration Specialist Needed
calm and analytical manner brought the project to a successful conclusion
CH
Chris H.
Nov 17, 2025
Integrate FedEx Shipping Rates into Google Sheet via API (OAuth 2.0 Auth) -= Fixed Price
MB
Michael B.
Nov 11, 2025
Azure Func Expert | .NET, API, Stripe, ShipEngine
Aamir once again delivered excellent work! He built and configured the Azure Functions and API integrations perfectly, with great attention to detail and solid communication throughout. Highly recommended for any .NET or Azure-related projects.
About Aamir
Senior .NET Developer | ASP.NET Core | Azure | OpenAI Integration
100%
Job Success
Lahore, Pakistan - 9:30 pm local time
scalable web applications, ERP systems, and AI-powered solutions
for clients across Europe and North America. 100% Job Success
across 32 completed projects.
I specialize in ASP.NET Core, C#, Azure, and OpenAI integrations
helping businesses automate workflows, modernize legacy systems,
and ship production-grade software on time.
What I deliver:
- ASP.NET Core and .NET 8 APIs, MVC, and microservices
- Azure cloud deployment, Functions, and DevOps pipelines
- OpenAI and Claude API integrations into .NET applications
- Angular and React frontends with clean architecture
- SQL Server schema design, EF Core, query optimization
- Third-party integrations: Stripe, Twilio, ShipEngine, PayPal
I have built multi-tenant SaaS platforms, enterprise ERPs,
real-time dashboards, and AI chatbot backends. I write clean,
maintainable code and communicate clearly throughout every project.
Open to fixed-price projects, hourly contracts, and long-term
retainer arrangements.
Steps for completing your project
After purchasing the project, send requirements so Aamir can start the project.
Delivery time starts when Aamir receives requirements from you.
Aamir works on your project following the steps below.
Revisions may occur after the delivery date.
Step 1
We create Schema design up to 10 tables and ER diagram PDF T-SQL scripts Basic indexing strategy
Step 2
ER diagram + data dictionary T SQL scripts + stored procedures advanced indexing + partitioning