You will get a fully optimized SQL Server schema and blazing-fast 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
Senior .NET & Azure Developer | ERP/CRM, API & AI Integration
100%
Job Success
Lahore, Pakistan - 9:01 am local time
Most of my work starts the same way. There is a system that works, a second system that also works, and no reliable path between them. Someone is exporting CSVs. A nightly job fails silently and nobody notices until finance closes the month. I fix that layer: durable integrations, idempotent handlers, retries with dead letter queues, and enough observability that failures surface before a client does.
Key Outcomes: Cut order processing time by 60% on a business platform by moving synchronous work into Azure Service Bus queues. Built a multi-tenant ERP and CRM now serving 9,000+ organizations with tenant isolation and role-based access. Saved clients 20+ hours a week on manual data transfers using multi-agent OpenAI reconciliation workflows. Migrated legacy .NET Framework applications to .NET 8 on Azure with no downtime for the business.
Core Services: Custom ERP and CRM development for order management, inventory, and member administration. Payments and Shipping integration including Stripe and multi-carrier shipping via ShipEngine. System and API Integration to sync sales, fulfillment, and finance data in real time. AI Integration for document intelligence, chatbots, and automated reporting. Legacy modernization and cloud migration to Azure without disrupting operations.
Tech Stack: Backend: .NET 8, 9, 10, ASP.NET Core Web API, C#, EF Core, Dapper, SignalR, gRPC, Hangfire Azure: App Service, Functions, Durable Functions, Service Bus, Blob Storage, Key Vault, Azure SQL, Application Insights Frontend: Angular, React, Next.js, TypeScript, RxJS, Tailwind Data: SQL Server, PostgreSQL, T-SQL, Redis Integrations: Stripe, ShipEngine, QuickBooks, OAuth 2.0, Webhook infrastructure AI: OpenAI API, Claude API, RAG and vector search, document extraction
Top Rated, 100% Job Success Score, 30+ completed projects.
Send me the problem and any constraints you are working under. If your architecture already has a direction, I will tell you whether it holds up. If it does not, I will tell you that too.
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