Role
Full-Stack Engineer
Duration
2022 – 2023
Year
2023
Overview
Mastery Cloud TMS is a high-traffic SaaS platform serving large-scale transportation and logistics providers. I joined as a Full-Stack Engineer with a primary focus on frontend performance and a pivotal role in driving the platform's database migration from MySQL to PostgreSQL — all while keeping the system live for customers.
The Challenge
Migrating a production logistics database from MySQL to PostgreSQL without service interruption required careful planning, phased execution, and real-time validation against both systems simultaneously.
Architectural Approach
Phased DB Migration Strategy
Authored PRDs and technical migration maps to guide a structured, risk-mitigated transition from MySQL to PostgreSQL, including specialized handling for geolocation data.
Data Integrity Automation Script
Built a TypeScript script that simultaneously queried both databases, performed deep record comparison, and generated discrepancy reports — replacing manual QA entirely.
GraphQL Query Optimization
Audited schemas to remove unnecessary fields and applied strategic database indexes, making PostgreSQL queries faster than the legacy MySQL system.
P90 Load Testing
Used JMeter to benchmark API endpoints at the 90th percentile response time, ensuring the system handled high-concurrency loads without latency spikes.
Results & Impact
Data Integrity
QA Overhead
Query Performance