Database Indexing Is Not Free: Understanding Performance and Trade-offs
A practical look at B-Tree indexes, write overhead, page splits, fill factor, and why ID strategy matters for production databases.
Jakarta, Indonesia · Software Engineer
I build reliable backend systems with Go.
I am a backend-focused Software Engineer with 4+ years of experience building production systems in Go, mostly around financial products, transaction flows, async workers, and service integrations.
Go, event-driven architecture, database performance, and resilient service design.
Selected work
Production backend systems for financial products.
- 4+ years building backend systems
- 500M IDR/day RTGS transfer capability shipped
- 99% availability target supported for event ingestion
Writing
Notes on databases, data structures, and backend engineering.
Array
A short note on fixed-size arrays, contiguous memory, direct addressing, and why array access is O(1).
Experience
Recent role and systems shipped.
Software Engineer
Bank Raya · Jakarta
Sept 2024 - Present
- Built recurring debit orchestration with cron scheduling, async workers, and idempotent execution safeguards.
- Designed RTGS transfer infrastructure integrated with Core Banking (UKO) for secure high-value transaction processing.
- Developed MultiQRIS Cashier authorization flows for 1,500+ merchants and 4,300+ NMIDs using RBAC and governed wallet access.
- Built event tracking ingestion APIs for reliable analytics collection across production workloads.
Stack
Tools I use to design, ship, and operate services.
Languages
Go, PHP, Ruby
Data Stores
MySQL, PostgreSQL, MongoDB, Redis, OpenSearch
Messaging
RabbitMQ, Google Pub/Sub
Platform
GitHub Actions, Kubernetes, Linux, Datadog, Rollbar
Backend Work
Event-driven architecture, Concurrency, RBAC, Caching, Retries, API integration
Practice
Unit testing, Code review, CI/CD, Agile/Scrum