Software Engineer — I design, ship, and scale production web applications with React, TypeScript, Node.js, and PostgreSQL.
Experienced full-stack engineer with a track record of migrating legacy platforms to modern architectures and building real-time, high-throughput backend systems. I like hard problems, clear code, and mentoring people.
View my contributions on GitLab.
- Lead migrations from legacy PHP systems to React and Next.js without stalling the teams that depend on them
- Build real-time product workflows — queues, photo capture, seller APIs — used by dealerships at production scale
- Design data pipelines across PostgreSQL and BigQuery (partitioning, materialized views, indexing) so dashboards stay fast as volume grows
- Replace polling and brittle backends with Node.js, Redis, and serverless patterns that hold up under load
Currently focused on: database performance, query caching, and table partitioning.
Frontend — React, TypeScript, Next.js, Tailwind CSS, shadcn/ui
Backend — Node.js, Go, Python, PHP
Data — PostgreSQL, BigQuery, MySQL, SQL Server, Redis
Infra — Google Cloud, Docker, Kubernetes, Argo CD, nginx
Architectures — SPAs, PWAs, serverless
Carketa — Software Engineer, 2022–present
Vehicle and dealership software. Migrated a core PHP platform to React/Next.js. Built a reconditioning system (tasks, photos, real-time seller API sync) adopted by ~10 new dealerships a month. Cut dashboard query time by 75% with a BigQuery and PostgreSQL pipeline.
nth-child consulting — Software Engineer, 2017–2022
Led a PHP-to-React/Next.js rewrite of a solar appraisal platform used to sell installation contracts. Replaced a polling-based support system with a Node.js and Redis queue (25% shorter wait times, zero downtime). Shipped a custom proposal tool that increased revenue by 10%.
More writing and projects: andrewgbliss.com
On andrewgbliss.com:
- Making a React sliding animation with Motion
- Use UIDs over auto increment — why auto-increment IDs leak data, and how Cuid2 helps
- Forget UUIDs and GUIDs — unique IDs that hold up at scale
Open to interesting problems, collaborations, and conversations about web architecture, security, and product design.
- Site: andrewgbliss.com
- LinkedIn: linkedin.com/in/andrewgbliss
- GitLab: gitlab.com/andrewgbliss



