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.
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
.NET Developer | ASP.NET Core | ERP and SaaS | Azure | OpenAI
100%
Job Success
Lahore, Pakistan - 12:29 am local time
Are you building an ERP system, scaling a SaaS platform, or integrating AI into your .NET application? I deliver production-grade solutions that work reliably on time and to spec.
With 8+ years of experience in .NET development, I have built multi-tenant SaaS platforms, enterprise ERP systems, AI-powered APIs, and real-time cloud applications for clients across Europe, North America, and the Middle East.
My core expertise:
- ERP and SaaS platform development (multi-tenant, enterprise-grade, ASP.NET Core)
- OpenAI and Azure OpenAI integrations into .NET applications
- ASP.NET Core and .NET 8 APIs, MVC, and Microservices Architecture
- Azure cloud deployment, Functions, and DevOps CI/CD pipelines
- Angular and React frontends with clean architecture
- SQL Server schema design, EF Core, and query optimization
- Full Stack Web API development with REST and SignalR
- Third-party integrations: Stripe, Twilio, ShipEngine, FedEx, PayPal
Recent work includes:
- A large-scale full-stack ERP with .NET Core, Angular, and React Native (5-star, $5,000+ contract)
- A multi-tenant SaaS platform for Danish organizations (Skulebridge) built on ASP.NET Core
- An industrial marketplace on .NET 8 microservices with Azure, FedEx, and UPS API integration
- Azure Functions and API integration projects with Stripe and ShipEngine
- CustomGPT AI chatbot SaaS platform and OpenAI .NET integrations
I write clean, maintainable code and communicate clearly at every stage. 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