TMS Deployment, Database Setup and E2E Testing

Job ID: 40568310

Budget: $3,000 – $5,000 USD

We have developed a custom Transportation Management System (TMS) for a shipping and logistics company. The codebase is complete, builds without errors, and is ready. We need a developer/system administrator to set up the local server deployment, configure the database, establish a secure tunnel, and perform end-to-end (E2E) testing.

Tech Stack:
Backend: C# .NET Web API (Clean Architecture, MediatR, FluentValidation, JWT Authentication, EF Core).
Frontend: React (v19), TypeScript, Vite, Vanilla CSS, Axios.
Database: MS SQL Server (Local).
Security & Networking: JWT tokens, Cloudflare Tunnel (for secure remote access without opening router ports).
Scope of Work:
Database Setup: Run EF Core migrations on our local Windows-based MS SQL Server machine.
Local Deployment: Deploy the React frontend (Vite build) and C# Web API backend to run on our office's local host machine.
Secure Remote Access: Install and configure Cloudflare Tunnel on the local server so employees can access the app securely via a custom subdomain (e.g., tms.ourdomain.com) from anywhere, without exposing public IP ports.
E2E Testing: Verify the frontend-backend connection, test the JWT login flow, role-based authorization (Admin vs. Operator), database writes, and Excel exports. Fix any minor deployment/integration bugs.
Required Skills:
C# .NET Core / Web API
MS SQL Server & Entity Framework Core
React / TypeScript / Vite
DevOps / Local Self-Hosting / Cloudflare Tunnel / IIS setup
Please apply with your estimated time and budget. We will share the codebase zip after an initial chat.