You will get a diagnosis and measured fix for API or SQL performance bottlenecks
Project details
Slow systems often fail across layers: a query plan, index, mapping path, request fan-out, serialization behavior, retry pattern, or legacy assumption may be the real constraint. I trace the agreed workload through the system, establish a reproducible baseline, and focus effort where evidence shows it matters.
I do not promise a specific percentage improvement before inspecting the system. You receive a defensible diagnosis, transparent tradeoffs, contained changes when included, and before/after evidence for the agreed test workload.
One workload must be agreed during discovery. Hosting, third-party fees, new infrastructure, broad rewrites, data cleanup, unrelated endpoints, and major scope changes are excluded. Production changes require buyer approval and access. Revisions address the agreed diagnosis or implementation, not new workloads.
I do not promise a specific percentage improvement before inspecting the system. You receive a defensible diagnosis, transparent tradeoffs, contained changes when included, and before/after evidence for the agreed test workload.
One workload must be agreed during discovery. Hosting, third-party fees, new infrastructure, broad rewrites, data cleanup, unrelated endpoints, and major scope changes are excluded. Production changes require buyer approval and access. Revisions address the agreed diagnosis or implementation, not new workloads.
Programming Languages
JavaScript, TypeScript, C#Coding Expertise
Performance Optimization, SecurityWhat's included
| Service Tiers |
Starter
$750
|
Standard
$2,000
|
Advanced
$5,000
|
|---|---|---|---|
| Delivery Time | 5 days | 10 days | 15 days |
Number of Revisions | 1 | 2 | 2 |
Number of Pages | 1 | 1 | 1 |
Design Customization | - | - | - |
Content Upload | - | - | - |
Responsive Design | - | - | - |
Source Code | - |
Frequently asked questions
About Zach
Software & Data Architect | AI Automation, APIs, Performance and SaaS
Kansas City, United States - 5:06 pm local time
High-value engagements include:
- Software and solution architecture for SaaS products and internal platforms
- API, backend, database, and integration design or modernization
- SQL and application performance investigation
- AI-enabled workflow automation and internal business tools
- Data modeling, operational data workflows, and legacy-system analysis
- Technical risk assessments, implementation roadmaps, and hands-on remediation
My work combines architecture with delivery. In one measured production API workload, I helped improve throughput from approximately 1.15 requests per second to approximately 51 requests per second while reducing median latency from about 21.5 seconds to about 450 milliseconds; the optimized workload reached approximately 710 milliseconds at p95. I have also led the architecture and implementation of a large real-time auction marketplace with WebSocket bidding, catalog and lot workflows, operational tools, imports and exports, payments-related flows, and extensive automated tests. The concentrated 2.5-month build produced approximately 225,000 lines of application code and 289,000 lines of tests - evidence of delivery scale, not a substitute for quality.
I work across Next.js, React, TypeScript, Node.js, NestJS, REST APIs, WebSockets, SQL Server, PostgreSQL, Prisma, cloud infrastructure, automated testing, and system architecture. My background also includes healthcare-adjacent and privacy-sensitive workflows, real-time marketplaces, SQL optimization, vendor integrations, and production web platforms.
My delivery process starts with the business outcome, constraints, access, and failure modes. I investigate the system across layers, identify the smallest defensible scope, document tradeoffs, and use modern AI-assisted engineering workflows to execute quickly. The implementation is backed by focused tests, reviewable milestones, technical documentation, and clear communication with business and technical stakeholders. Final scope and architecture always depend on the systems and access available; I do not promise an unknowable performance result before inspection.
If you have a slow workload, unreliable integration, disconnected workflow, or product that needs a credible technical plan, tell me what is happening now and what outcome matters. I can help turn that ambiguity into a prioritized path and maintainable implementation.
Steps for completing your project
After purchasing the project, send requirements so Zach can start the project.
Delivery time starts when Zach receives requirements from you.
Zach works on your project following the steps below.
Revisions may occur after the delivery date.
Baseline and discovery
I confirm scope, access, success criteria, and establish a reproducible baseline.
Root-cause findings
I trace the agreed workload across application and data layers and document evidence.