You will get Custom SQL Database Performance Tuning and Data Migration
Project details
Are slow database execution plans, unoptimized indexes, or deadlocks bottlenecking your enterprise systems? Moving legacy data assets to modern infrastructure requires expert oversight to ensure zero data loss and maximum runtime performance.
Leveraging 20 years of mastery in MS SQL Server, Oracle, and PostgreSQL, I specialize in engineering high-performance data layers and executing seamless migrations.
### 🛠️ What I Will Do:
• **Advanced Query Tuning:** Analyze execution plans to eliminate expensive scans and deadlocks.
• **Schema Modernization:** Refactor legacy stored procedures and relational structures.
• **Secure Data Migration:** Build ETL pipelines to safely move data to cloud environments.
Get a resilient, lightning-fast database layer built to scale. Let's discuss your data goals!
Leveraging 20 years of mastery in MS SQL Server, Oracle, and PostgreSQL, I specialize in engineering high-performance data layers and executing seamless migrations.
### 🛠️ What I Will Do:
• **Advanced Query Tuning:** Analyze execution plans to eliminate expensive scans and deadlocks.
• **Schema Modernization:** Refactor legacy stored procedures and relational structures.
• **Secure Data Migration:** Build ETL pipelines to safely move data to cloud environments.
Get a resilient, lightning-fast database layer built to scale. Let's discuss your data goals!
Database Type
MySQL, MS SQL, MS Access, Oracle, SQLite, PostgreSQL, MongoDB, Azure Cosmos DBWhat's included
| Service Tiers |
Starter
$150
|
Standard
$600
|
Advanced
$1,500
|
|---|---|---|---|
| Delivery Time | 3 days | 7 days | 14 days |
Number of Revisions | 1 | 2 | 3 |
Schema Diagram | - | - | - |
Permissions Setup | - | - | - |
Import/Export Data | - | - | - |
Admin Panel Setup | - | - | - |
Frequently asked questions
2 reviews
(2)
(0)
(0)
(0)
(0)
This project doesn't have any reviews.
KB
Kay B.
Mar 2, 2014
Access Database Development1
Good job
KB
Kay B.
May 22, 2013
Access Database Development1
Good job
About Jam Zamarrud
Jam Zamarrud Iqbal
Kastrup, Denmark - 8:45 pm local time
With over 20 years of enterprise-level software engineering experience—including 11 years driving high-impact technical solutions in Copenhagen, Denmark—I specialize in architecting, developing, and optimizing high-performance distributed systems. As an expert Team Lead and Full-Stack Architect, my primary focus is building robust, low-latency .NET backend systems, seamlessly paired with modern, responsive frontends and AI automation.
My engineering philosophy centers around performance tuning, clean code, and memory-efficient system design. I bring a deep mastery of the .NET ecosystem alongside hands-on leadership experience guiding agile teams to deliver end-to-end, mission-critical software.
### Core Expertise
* Architecture & System Design: Microservices, Multi-tier (n-Tier) Architecture, Domain-Driven Design (DDD), Dependency Injection (Autofac/Unity), and SOLID principles.
* Backend & API Development: Advanced C# .NET, ASP.NET Core, RESTful APIs, gRPC, GraphQL, Web Services, and specialized asynchronous programming.
* Frontend & UI Engineering: Designing modern, responsive user interfaces using React.js, AngularJS, TypeScript, JavaScript, HTML5, CSS3, and .NET MAUI for cross-platform applications.
* Cloud & Messaging: MS Azure Cloud Services, Azure DevOps pipelines, Docker, Kubernetes, RabbitMQ, and Azure Service Bus.
* Data Mastery & Optimization: Expert-level query tuning and indexing across MS SQL Server, PostgreSQL, Oracle, and Redis Caching. Advanced handling of big data using MongoDB and NoSQL.
* AI & Automation: Seamless integration of Machine Learning (ML.NET, Azure ML), OpenAI API, and Natural Language Processing (NLP) models to automate complex business workflows.
* Engineering Leadership: Employee mentorship, code reviews, static code analysis (SonarQube), TDD/BDD practices, and technical consulting within Scrum, SAFe, and Kanban frameworks.
### Highlighted Project Successes & Accomplishments
* Renewable Energy Systems: Designed and sustained complex software applications for large-scale enterprise energy projects, collaborating across global, cross-functional engineering teams.
* High-Performance Infrastructure: Reconstructed high-speed data processors (such as low-latency order books) prioritizing rapid data structures and eliminating restrictive abstractions.
* Enterprise Automation: Successfully engineered a 26-module automation system and modernized core patent office workflows via localized IPAS implementations.
### Technical Stack & Tooling
* Languages: C#, TypeScript, JavaScript, Python, SQL, XML, JSON
* Backend Frameworks: .NET 8/Core, ASP.NET Core, Entity Framework Core, gRPC, GraphQL, REST, Web API, WCF, Node.js
* Frontend Libraries: React.js, AngularJS, Bootstrap, jQuery, AJAX, .NET MAUI, WPF
* Cloud & DevOps: MS Azure, Docker, Kubernetes, CI/CD (Azure Pipelines, Jenkins), Terraform, Git
* Databases & Caching: MS SQL Server, PostgreSQL, Oracle, MongoDB, Redis
* Message Queues: RabbitMQ, Azure Service Bus
* Testing & Quality: NUnit, xUnit, Moq, SonarQube
---
### How We Can Collaborate:
1. Send an Invitation: Click the "Invite to Job" button on my profile with your project details.
2. Discovery Consultation: We will jump on a brief Zoom call via Upwork to discuss your architecture, blockers, and goals.
3. Execution Plan: I will deliver a clear roadmap, architectural strategy, or a proof-of-concept to get your project moving immediately.
Click "Invite" above to discuss your project and get your applications performing at their absolute peak.
Steps for completing your project
After purchasing the project, send requirements so Jam Zamarrud can start the project.
Delivery time starts when Jam Zamarrud receives requirements from you.
Jam Zamarrud works on your project following the steps below.
Revisions may occur after the delivery date.
Performance Audit & Plan Analysis
I deeply analyze your current database execution plans to locate expensive table scans, bad indexing, and deadlocks. I then deliver a structured optimization roadmap highlighting the highest-impact query fixes.
Schema Tuning & Object Refactoring
I optimize database performance by systematically rebuilding indexes, restructuring slow relational views, and rewriting complex legacy stored procedures to maximize query processing efficiency.