Vansh BBackend Engineer

Hiring for Backend Engineer? Start here.

APIs that holdup when trafficspikes.

Backend engineer for data-heavy systems: ETL pipelines, analytical databases, caching layers and low-latency APIs at scale.

6B+

rows in production ClickHouse

500ms

P90 query latency

750+

matches ingested automatically

About me

I am Vansh Bordia, a backend engineer for data-heavy systems. My happiest place is a hard data problem: messy multi-source JSONL, an analytical query that needs to run in milliseconds, a pipeline that must not lose a row.

I built the systems behind RiftWatch: custom ETL, ClickHouse and Postgres tuned for analytics, Redis caching, FastAPI on Kubernetes. Correctness first, then speed, then scale, always measured.

Why me

I build the systems behind the dashboard: custom ETL over messy JSONL, analytical databases tuned for the query pattern, Redis where it counts, containers everywhere. Correctness first, then speed, then scale.

I build the systems behind the dashboard: custom ETL over messy JSONL, ClickHouse and Postgres tuned for analytics, Redis caching, FastAPI services on Kubernetes. Correctness first, then speed, then scale.

6B+ rows in production ClickHouse, sub-500ms P90

Custom ETL reconciling inconsistent multi-source schemas

FastAPI services on Kubernetes with ephemeral scaling

Role stack

Python / FastAPI / PostgreSQL / ClickHouse / Redis / Apache Spark / Kafka / Docker / Kubernetes / API Design / ETL Pipelines / Query Optimization

Relevant work

RiftWatch

Esports intelligence platform, acquired by a pro org

  • 750+ pro matches processed into 6B+ analytical rows in ClickHouse
  • 20 orgs at peak including Tier-1 across Americas and EMEA
  • VALORANT-specific Gemma models plus RAG over live patch data
  • Agentic harness routing tools, models and queries; sub-500ms P90
PythonFastAPIClickHousePostgreSQLRedisKubernetesReact
Visit project

VLR Dev API

Type-safe Python library for Valorant data, published on PyPI

  • Type-safe Python library for Valorant data, published on PyPI
  • Retry logic, rate limiting and schema validation built in
  • Earned official Riot data API access in 2 weeks, not 9 months
PythonPyPIREST
Visit project

DDL Showcase

Interactive SQL schema visualizer, 100% client-side

  • Dual-dialect SQL parser, PostgreSQL plus ClickHouse
  • Interactive ER diagrams with auto-layout and relationship inference
  • 100% client-side, data never leaves the browser
TypeScriptReactSQL
Visit project

ACF Import/Export

Production WordPress plugin in the official directory

  • Production WordPress plugin in the official directory
  • Secure file handling and sanitization per WP standards
PHPMySQLWordPress
Visit project

Contact

Need backends that survive scale? Talk to me.

GitHubLinkedInBehanceDribbbleKaggleInstagramTwitterFacebookYouTubeTwitchSpotifyReddit