Farista Latuconsina

Senior Backend Engineer  ·  Bandung, Indonesia

Farista
Latuconsina

I architect backend systems for performance and scale — databases, gateways, and the infrastructure layer everything else depends on.

View WorkGet in Touch

Currently

Autobahn Security GmbH

Senior Backend Engineer

Jul 2024 — Present

By the numbers

8+

Years engineering

18

Gov. regions served

10

City govts advised

4×

Avg query speedup

Current Stack

NestJSRustPostgreSQLNATSBullMQRedis
scroll
01 — About
Farista Latuconsina

About Me

I'm Farista Latuconsina — a backend engineer who gravitates toward the hard problems: systems that don't scale, queries that shouldn't be that slow, architectures that make the next feature unnecessarily painful to build.

Eight years of that instinct has taken me from building nationwide GIS platforms for Indonesian government agencies and consulting for the World Bank, to designing data infrastructure at a German cybersecurity company. At Autobahn Security I've introduced a unified API gateway, a consistent-hashing sharding mechanism, and a multi-tenant RLS system that enforces tenant isolation transparently at the database layer — the kind of foundational work that every service depends on.

Outside of work, I'm equally obsessed with the developer side: I run Neovim full-time on a split keyboard, use Vimium in the browser, build my own Lua plugins, and lean heavily on AI tools to augment and accelerate my engineering workflow. If a tool is in my stack, it's been optimised.

Experience

8+ Years

Currently

Autobahn Security

Location

Bandung, Indonesia

Education

CS Honours, Indonesia University of Education

02 — Skills

Technical Stack

Languages

TypeScriptRustPHPPythonC#SQLLua

Frameworks

NestJSNode.jsExpress.jsLaravelFlaskASP.NET

Infrastructure

DockerKubernetesAWSGCPAirflowDBT

Messaging & Data

PostgreSQLRedisBullMQNATSRabbitMQMongoDBMySQL
03 — Projects

Selected Work

Multi-Tenant RLS System

Designed and implemented Row-Level Security across PostgreSQL and NestJS for a multi-tenant SaaS platform. Built a NestJS interceptor library that automatically parses auth context, resolves tenant identity, and enforces RLS policies at the query execution layer — transparently, without per-endpoint wiring.

NestJSTypeScriptPostgreSQLRLSJWT

Unified API Gateway with Long-Flight Support

Architected a centralized API gateway unifying all endpoint requests across services. Introduced a long-flight mechanism via BullMQ to handle asynchronous, long-running jobs without holding HTTP connections — reducing timeouts and simplifying client-side retry logic.

NestJSTypeScriptBullMQRedisDocker

3D Bin Packager

A PHP library that solves 3D bin packing problems — efficiently allocating items into containers while minimising wasted space. A pure algorithmic exercise that accumulated 26 GitHub stars organically.

PHPAlgorithmsBin Packing

simpleterm.nvim

A minimal, fast, and aesthetically clean floating terminal plugin for Neovim. Built out of frustration with heavyweight alternatives — does one thing well: drop a terminal into any buffer without disrupting your editing flow.

LuaNeovimTerminal
04 — Experience

Work History

Senior Backend Engineer

Autobahn Security GmbH

Jul 2024 — Present

Jakarta Metropolitan Area · Hybrid

  • —Work across a microservices platform built on NestJS, Rust, Flask, and Airflow — services communicate over NATS for internal calls and RabbitMQ for scan orchestration workflows.
  • —Architected a unified API gateway with a long-flight job mechanism (BullMQ) to decouple HTTP request lifecycles from long-running backend processes.
  • —Designed a database sharding strategy using consistent hashing, enabling horizontal data partitioning without application-layer rewrites.
  • —Built a multi-tenant RLS system spanning PostgreSQL policies and a NestJS interceptor library that enforces tenant isolation transparently at query time.
  • —Optimised caching strategies with Redis to reduce database load and improve response times across high-frequency endpoints.
  • —Migrated ETL pipelines from Node.js to Rust multi-threaded processing: 50% faster throughput, ~80% reduction in memory usage.
  • —Developed a PostgreSQL partition procedure enabling partition pruning, achieving a 4× improvement in query execution time on large datasets.

Software Engineer

Cityplan Indonesia

Mar 2018 — Apr 2024

Bandung, West Java · Hybrid

  • —Developed an integrated spatial planning information system for 18 cities and counties in Indonesia, facilitating public access to spatial plans and integrating with OSS for space utilisation conformity submissions.
  • —Built a public-facing information system enabling citizens to monitor spatial planning through integrated reporting channels, enhancing transparency in KKPR and PMP UMK assessments.
  • —Created a social media analysis platform to parse and capture social conversations, empowering planners with data-driven insights for strategic decisions.
  • —Partnered with product managers to design and deliver advanced spatial analysis tools, improving workflow efficiency and stakeholder engagement across urban planning initiatives.

Back-End Developer

PT. Bio Farma

Jun 2023 — Feb 2024

Remote · Contract

  • —Designed and implemented an optimised ERD to accommodate complex audit business processes and historical data recording.
  • —Developed comprehensive APIs covering auditor management, audit scheduling, findings recording, corrective actions, reporting, and notifications.

System Analyst

PT. Zafina Analitika Inspektama

Jul 2023 — Dec 2023

Remote · Contract

  • —Collaborated with stakeholders through interviews to gather and analyse business requirements, ensuring alignment with user needs.
  • —Utilised modelling techniques to visualise system requirements and design solutions, enabling stakeholders to understand proposed functionalities.

System Analyst / Developer

PT. Semen Indonesia (Persero) Tbk.

Jan 2022 — Sep 2022

Remote · Contract

  • —Conducted comprehensive analysis of existing e-COQ workflow software and database, using testing, debugging, and code reviews to identify inconsistencies.
  • —Spearheaded the implementation of 12 feature enhancements and bug fixes, providing support throughout testing and production phases.

Software Engineering Team Lead

PT. Selaras Citra Nusantara Perkasa, Tbk.

Jun 2020 — Mar 2022

Bandung, West Java · Contract

  • —Managed and directed a team of 4 engineers in rebuilding the company's core applications, achieving a cost reduction of approximately 65%.
  • —Orchestrated the transition from closed-source software algorithms to scalable open-source solutions.

Short-Term Consultant

World Bank Group

Apr 2020 — Jun 2021

Remote · Contract

  • —Implemented the MSDI framework to drive data-driven decision-making across 10 city governments in Indonesia.
  • —Enhanced efficiency and interoperability of spatial data analytics pipelines for each municipality.
  • —Ensured sustainability and user benefit of newly developed applications.

Software Developer

Balai Besar Bahan dan Barang Teknik (B4T)

Dec 2017 — Mar 2019

Bandung, West Java · Part-time

  • —Built a proficiency testing platform across 7 schemas used by 30+ laboratories worldwide.
  • —Developed a digital laboratory inspection system, reducing paper-based form usage by 70%.
05 — Writing

Recent Posts

How PostgreSQL Partition Pruning Gave Us a 4× Query Speedup

A practical walkthrough of implementing table partitioning and why the query planner's partition-pruning behaviour is the real win — not just the storage savings.

Coming soonMedium

Building a Multi-Tenant RLS System That Doesn't Leak

Row-Level Security in PostgreSQL is powerful but the failure modes are subtle. Here's how I built an NestJS interceptor layer that enforces tenant isolation at query time — and why I had to.

Coming soonMedium

Consistent Hashing for Database Sharding: A Practical Guide

Sharding without consistent hashing means every topology change reshuffles your data. Here's how to implement it properly and what the math actually means for your key distribution.

Coming soonMedium

My Neovim Setup for Backend Development

After years of IDE dependency, I went all-in on Neovim with a split keyboard. Here's the config, the plugins, and the workflow changes that made it worth it.

Coming soonMedium
06 — Contact

Get in Touch

Not actively looking, but always open to interesting conversations about backend systems, performance engineering, or architecture problems worth solving. Feel free to reach out.

him@latuconsinafr.com
GitHubLinkedIn