~/andro/profile

Andro.

Jakarta, Indonesia Status: Available 4+ yrs experience

I design and operate large-scale data infrastructure — from tuning multi-hundred-million-row query engines to shipping self-serve BI platforms. Currently focused on distributed OLAP systems and backend reliability for logistics workloads.

View Projects Contact Me
tech_stack.status 7 online
PHP 90%
MySQL 88%
Apache Doris 85%
SQL Tuning 92%
Docker 80%
Python 75%
Grafana 78%
Last sync: just now
02 / Selected Work

Projects

A snapshot of recent infrastructure and platform work. Replace these with your own case studies — descriptions, tags, and links are all placeholders.

FE BEBE BEBE
STATUS: DEPLOYED

Doris HA Cluster Migration

Rebuilt a single-node deployment into a 3-Follower / 3-BE high-availability cluster with FQDN mode and automated S3 backups, cutting query latency significantly.

Apache DorisDockerGrafana
View case study
STATUS: DEPLOYED

Superset BI Platform Rollout

Containerized Apache Superset with a custom Doris connector, resolving build-time dependency issues, enabling self-serve dashboards across business teams.

SupersetDockerPython
View case study
PHP App ETL Doris
STATUS: IN PROGRESS

Logistics Order Data Pipeline

Built a near-real-time ETL pipeline syncing order and shipment data from a PHP/MySQL application into a Doris fact table for operational reporting.

PHPMySQLETL
View case study
STATUS: DEPLOYED

Query Performance Optimizer

Diagnosed slow queries on a ~149M-row fact table caused by partition pruning and bucket imbalance — restructured distribution and refreshed statistics.

SQLApache DorisPerf Tuning
View case study
{ } beginTransaction() → commit() → rollback()
STATUS: DEPLOYED

PHP DBAL Transaction Layer

Refactored a legacy application's database layer with Doctrine DBAL, standardizing transaction handling and error recovery across services.

PHPDoctrine DBALMySQL
View case study
$ diagnose --fe --be checking replication lag... 3 nodes healthy
STATUS: PROTOTYPE

Cluster Diagnostics CLI

A lightweight CLI for quickly checking FE/BE node health, metadata mismatches, and replication lag across Doris clusters.

PythonApache DorisCLI
View case study
03 / Get In Touch

Contact Me

Open to backend and data platform roles, freelance projects, or a quick chat about query optimization. Reach out through any channel below.

EMAIL andro@example.com
GITHUB github.com/andro-dev
LINKEDIN linkedin.com/in/andro-dev
LOCATION Jakarta, Indonesia

The fastest way to reach me is by email — I usually reply within a day. Feel free to attach a brief about your project, timeline, and stack.

Send an Email