⚡ THE "ONE-MAN IT DIVISION" PLATFORM ARCHITECT

Architecting Resilient Platforms,
Fullstack, Mobile & Core DBA.

🚀 CUSTOMIZE BRIEFING FOR YOUR ROLE:

👔 Senior DBA, Fullstack Platform & Mobile Architect Immediate Fit

🎯 Target Roles: Senior DBA, Platform Engineer, Fullstack & Mobile Architect.

🏢 Enterprise Pedigree: PT Link Net Tbk (99.98% SLA), AFPI Fintech Data Center (ISO 27001).

💼 Availability: Open for Full-Time & High-Impact Consulting (Remote / Hybrid / On-Site).

📄 ATS Match Score: 98/100 verified on Workday, Taleo, and Greenhouse.

💬 Telegram Direct (@riprlutuk) ↗

telemetry.sh

riprlutuk@prod-k8s:~$ fleetctl status --live

├─ [DBA] PostgreSQL 16 & MSSQL AlwaysOn ● 99.98% STREAMING

├─ [API] Go & Python Microservices ● 200 OK (2.1ms)

├─ [APP] Vue 3 PWA & PGlite WASM ● OFFLINE SYNC

└─ [SEC] ISO 27001 & FortiGate VPN ● 100+ NODES ENFORCED

QUERY OPT: 4,200ms → 18ms (-99.5%) ISMS: ISO 27001 Certified

Uptime SLA

99.98%

Core DBA

4 RDBMS

ISMS Compliance

ISO 27001

7+ Years Enterprise Exp

4 Engines Multi-DBA Fleet

100+ Nodes Fintech & DRC

99.98% Uptime SLA

JKT-DC1 (AFPI Data Center): 0.8ms

SIN-AWS: 7.9ms

Postgres HA Replica: 0-Lag (100% Synced)

Grafana Blackbox SLA: 99.98%

Recruiter & Hiring Fast-Track

The 30-Second Candidate Profile

Verified production track record, core competencies, and hiring specifications at a single glance.

HERI RISKI ANTO, S.Kom

Senior DBA & Platform Engineer

🏆 7+ Years Prod IT 🛡️ ISO 27001 ISMS Lead ⚡ 99.98% SLA Record

Bridges the gap between deep database internals (PostgreSQL, MSSQL, Oracle), high-throughput backend microservices (Go, Python, Laravel), and enterprise security governance.

KEY STACK & CAPABILITIES:

📥 Download ATS PDF ↗ ✈️ Telegram: @riprlutuk ↗

📋 HIRING SPECIFICATIONS 98/100 ATS Match

Target Roles Senior / Lead DBA, Infra & Backend Platform

Experience 7+ Years Production Track Record

Work Model Remote • Hybrid • On-site (JKT / TNG)

Availability ● Open for Full-Time & Consulting

Education S.Kom (Informatics) + ISO 27001 Certified

Languages Indonesian (Native), English (Professional)

🎯 1-Click Candidate Compatibility Radar:

Select your open position to evaluate Heri's verified production match:

⚡ RADAR READY

✅ 100% COMPATIBILITY MATCH 7+ Years Track Record

Proven production experience managing high-availability multi-engine clusters at PT Link Net Tbk (99.98% SLA), query plan optimizer, partition tuning, and RMAN automated disaster recovery.

✈️ Chat Telegram ↗

🧠 Technical Architecture Quick Challenge:

Test real-world DBA & Security problem-solving scenarios solved by Heri in production:

⚡ 3 Quick Scenarios

Scenario 1: A financial table with 10,000,000 rows suffers a 4,280ms slow query during monthly ledger aggregation. What is the optimal production fix?

✅ Correct! Heri applied this covering index technique to reduce query execution time from 4,280ms down to 12.4ms (345x speedup) with 100% in-memory buffer hits.

Scenario 2: A sudden burst of 15,000 microservice worker connections exhausts PostgreSQL max_connections (500), causing backend 503 errors. How do you resolve it?

✅ Correct! Heri deployed PgBouncer transaction pooling, allowing 15,000 concurrent client connections to be multiplexed seamlessly into 50 persistent database connections with only 14% server RAM usage.

Scenario 3: Under ISO/IEC 27001:2022 (A.8.11 Data Masking) & UU PDP, staging and analytics databases require production testing data without exposing citizen NIK or unmasked PII. What is the standard architecture?

✅ Correct! Heri implemented automated ETL sanitization with salted cryptographic hashing, column-level masking, and pgAudit immutable trails, passing ISO/IEC 27001:2022 and OJK audits with zero non-conformity findings.

Interactive Architecture

Production Systems Under the Hood

Explore interactive system topologies engineered by Heri Riski Anto. Click on any node to inspect latency, security controls, and design decisions.

👉 Swipe horizontally to trace pipeline tiers • Tap node to inspect

DBA Superpowers & Metrics

Quantified Production Impact

Real performance benchmarks and operational metrics achieved across enterprise databases.

⚡ 10M-Row Aggregation Latency

Execution plan analysis, composite B-tree indexing, and partition pruning on PostgreSQL & SQL Server.

Before (Full Table Scan) 4,200 ms

After (Optimized Index Scan) 18 ms

🚀 99.5% Latency Reduction

🛡️ Disaster Recovery SLA (HA/DR)

Automated WAL/Binlog shipping, RMAN backups, and automated restoration verification protocols.

Recovery Point Objective (RPO) < 15 mins

Recovery Time Objective (RTO) < 1 hour

✅ 99.98% High Availability

🔄 CDC Stream Ingestion Throughput

Debezium Kafka streaming from OLTP to ClickHouse columnar database for real-time analytical queries.

Peak Event Throughput 10,000+ evt/s

OLAP Aggregation Latency < 40 ms

📊 Sub-Second Analytics

Interactive Diagnostic Lab

DBA Query Optimizer & Execution Plan Visualizer

Experience real-world database bottleneck resolution live in the browser. Select a high-load production scenario to inspect raw execution plans vs Heri's index tuning & architectural refactor.

PostgreSQL 16

10M Row Ledger Table: Sequential Scan vs B-Tree Composite Index

A monthly financial aggregation query on a 10,000,000 row transaction table takes 4,280ms, triggering CPU spikes and locking connection threads.

⚠️ UNOPTIMIZED WORKLOAD

📄 SQL WORKLOAD & DDL INPUT

SELECT tenant_id, DATE_TRUNC('month', created_at) AS tx_month, 
       SUM(amount) AS total_volume, COUNT(*) AS tx_count
FROM financial_transactions
WHERE tenant_id = 'afpi_node_99' 
  AND created_at >= '2025-01-01' 
  AND status = 'COMPLETED'
GROUP BY 1, 2;

📊 EXPLAIN (ANALYZE, BUFFERS) OUTPUT EXECUTION TREE

Seq Scan on financial_transactions (cost=0.00..428,940.10 rows=14,200 width=48) (actual time=42.10..4280.45 rows=14,198 loops=1)
  Filter: ((created_at >= '2025-01-01'::date) AND (status = 'COMPLETED'::text) AND (tenant_id = 'afpi_node_99'::text))
  Rows Removed by Filter: 9,985,802
  Buffers: shared hit=8,201 read=342,100
Planning Time: 0.852 ms
Execution Time: 4280.950 ms

Execution Latency

4,280 ms

Optimizer Cost

428,940

Buffer Cache vs Disk I/O

342,100 Disk Read

Bottleneck Diagnosis: Click "Apply Heri's DB Optimization" to see the index tuning and architecture refactor.

🚨 Production SRE Resilience Drill: Simulate automated incident response under 40,000 req/s load.

[System Idle] Click "Run SRE Drill" to test multi-tier perimeter & database failover drill.

Interactive Sandbox & Craftsmanship

Flagship Production Platforms

Enterprise database engines, real-time CDC streaming pipelines, and fullstack platforms. Click [⚡ Test / Inspect] on any card to run live interactive simulations!

[ 01 // GO-GATEWAY ] ● ACTIVE

DDAG

Zero-Trust Dynamic SQL API Gateway

High-performance Go gateway dynamically reflecting SQL schemas and exposing PostgreSQL, MySQL, MSSQL, and Oracle databases as secure, governed REST APIs with JWT auth and PgBouncer connection pooling.

⚡ Overhead < 2.5ms

🛡️ Security JWT + RBAC

💾 Engines 4 RDBMS

⚡ REST API GATEWAY SIMULATOR 200 OK (1.2ms)

GET /api/v1/query?dialect=postgres&tenant=afpi_node_99 Payload: { "status": "success", "rows": 14200, "jwt_auth": "VERIFIED_PASS" }

Go (Golang) Postgres MSSQL

GitHub ↗

[ 02 // CDC-ENGINE ] ● ACTIVE

ch-olap-pipeline

Universal Real-Time CDC Streaming Engine

Continuous Change Data Capture streaming pipeline capturing transactional mutation logs from OLTP into ClickHouse columnar storage for sub-second analytical reporting over 50M+ rows.

🔄 Streaming 0-Lag CDC

📈 Database ClickHouse

⚡ Speedup 100x vs OLTP

🔄 KAFKA CDC EVENT INGESTION 0.024s (50M rows)

Event Stream: Debezium WAL → Kafka Topic [fintech.mutations] → ClickHouse ReplacingMergeTree (Throughput: 33.3 GB/s)

Debezium Kafka ClickHouse

Demo ↗ GitHub ↗

[ 03 // GOVERNANCE ] ● ACTIVE

OpenOrg

Organization Governance & Headless CMS

Single-tenant organization management platform with digital membership ID (KTA), SKP academy credentialing, governance hierarchy, and tamper-resistant cryptographic certificate verification.

🏛️ Hierarchy Multi-Tier

📜 SKP Engine Accredited

🔐 Security Tamper-Proof

🔍 KTA & CERTIFICATE VERIFIER HASH VALID

KTA-ID: [ID-89102-KTA] • Status: ACCREDITED SHA-256: 7f83b1657ff1fc53b92dc18148a1d65dfc2d4b1fa3d677284addd200126d9069

TypeScript CMS Digital KTA

GitHub ↗

[ 04 // CIVIC-TECH ] ● ACTIVE

WargaHub

Neighborhood Governance & Transparent Ledger

Community information system, transparent budget ledger, and digital musyawarah consensus for RT/RW neighborhoods powered by embedded offline-capable WASM PostgreSQL database.

🏡 Scope RT/RW Admin

⚡ Database PGlite WASM

📱 Client Offline PWA

💰 EMBEDDED PGLITE WASM QUERY 0.4ms (WASM)

SELECT SUM(nominal) FROM kas_rt_rw; Result: Rp 42.850.000 (100% Transparansi & 0 Selisih Pembukuan)

Fastify Vue 3 PWA PGlite WASM

GitHub ↗

[ 05 // ENTERPRISE-SAAS ] ● ACTIVE

PasPapan

Enterprise HRIS & Biometric Operations

Comprehensive enterprise workforce operations featuring Anti-Mock GPS & Face ID attendance, automated 1-click payroll calculation, KPI appraisal matrix, and multi-branch dashboards.

👥 Workforce Multi-Branch

📍 Biometrics Anti-Mock GPS

💰 Payroll 1-Click Auto

📍 BIOMETRIC RADAR SCANNER SPOOF: 0.00%

GPS: [-6.2088, 106.8456] • Anti-Mock: PASSED Face Match Confidence: 99.4% • Attendance Logged in 0.4s

Laravel Livewire Face ID

Demo ↗ GitHub ↗

[ 06 // DATA-INTEGRATION ] ● ACTIVE

pg2ora-cdc

PostgreSQL to Oracle Real-Time CDC

High-availability Change Data Capture integration synchronizing real-time financial ledger mutations from PostgreSQL to Oracle Database 19c with schema mapping and DLQ replay.

🔄 Sync Mode Real-Time CDC

💾 Target DB Oracle 19c

🛡️ Integrity DLQ Replay

🔄 SCHEMA MAPPER & DLQ MONITOR 0 LAG SYNCED

Postgres [WAL LSN: 0/16B3748] → Kafka Connect → Oracle 19c [Redo SCN: 89410294] (DLQ Errors: 0)

Debezium Postgres Oracle 19c

GitHub ↗

[ 07 // SENTINEL-MONITORING ] ● ACTIVE

db-port-monitoring

Multi-Database Port & Connection Health Sentinel

Enterprise zero-credential database port availability & latency probe platform. Features Prometheus Blackbox Exporter, resilient chunked PostgreSQL time-series ingestion daemon, downtime event tracking, and 7-panel Grafana SLA KPI executive reporting.

📡 Scrape 5m Cadence

🛡️ Security 0 DB Creds

💾 Storage Postgres TS

📡 TCP PROBE & SENTINEL TELEMETRY ALL PORTS UP (0.6ms)

PROBE [postgres:5432, mysql:3306, oracle:1521, mssql:1433, clickhouse:9000] → STATUS: 100% UP, RTT: 0.62ms, Writer Ingest: SYNCED (0 Gap)

Prometheus Blackbox PostgreSQL Grafana

GitHub ↗

Crisis Resolution & Post-Mortems

Production Incident War Stories

Real high-stakes database crises diagnosed and resolved under pressure. Zero data loss, fast RTO, and verified root-cause remediation.

CRITICAL INCIDENT // AFPI FDC RTO: < 8 Mins

14,000 req/s Connection Starvation & Max Connections Saturation

Root Cause: Synchronized nationwide OJK credit inquiries exhausted max_connections (500), cascading 504 timeouts across 100+ fintech lenders.

Heri's Fix: Deployed PgBouncer transaction-mode pooler multiplexing 2,500 active app clients into 45 backend DB connections. Server load plummeted by 85% with 0ms wait queue.

PostgreSQL 16 PgBouncer OJK Regulated

TRANSACTION LOCK // VESTORA.ID Collision: 0%

Crowdfunding Campaign Flash Sale Asset Allocation Deadlock

Root Cause: Concurrent investor pledges locked shared project ledger rows non-deterministically, triggering deadlocks and transaction rollbacks.

Heri's Fix: Implemented PostgreSQL advisory locks paired with deterministic alphabetical resource locking order, achieving zero deadlock collisions at 100% campaign concurrency.

Advisory Locks Isolation Levels Fintech Escrow

REPLICATION LAG // LINK NET Lag: 42m → 1.1s

40GB Standby Replication Lag Threatening Executive SLA

Root Cause: Unindexed bulk batch ingestion saturated single-threaded WAL streaming receiver on standby replicas, causing 42-minute lag.

Heri's Fix: Partitioned ingestion tables by monthly range with unlogged staging, tuned WAL sender buffers and parallel workers, slashing replication lag to < 1.2s.

WAL Streaming Partitioning 99.98% SLA

“Heri possesses that rare combination of deep database internals mastery and strict regulatory discipline. His leadership in implementing ISO 27001 and scaling the Fintech Data Center across 100+ platforms was flawless.”

🛡️

Fintech Data Center Leadership

AFPI • OJK Regulated Ecosystem

“When our crowdfunding investment engine was experiencing race conditions during peak flash campaigns, Heri redesigned our transactional locking mechanism in 48 hours. Zero deadlocks ever since.”

🚀

Engineering Leadership

Vestora.id • Sharia Crowdfunding

Public Open Source Works

GitHub Repositories Explorer

Real-time public repositories created and maintained by Heri Riski Anto on GitHub. Search and filter across 49+ projects.

Loading repos...

Career History

Professional Experience

7+ years of consistent production delivery, infrastructure hardening, and high-availability engineering.

Database Administrator (DBA)

PT Link Net Tbk

Feb 2025 – Present • Jakarta / Remote

🔄 Oracle ➔ Postgres 16 🍃 MongoDB ➔ AWS DocDB ☁️ AWS RDS ➔ TencentDB 📊 Grafana Observability

Oracle to PostgreSQL Migration: Architected zero-downtime migration from Oracle 19c to PostgreSQL 16, translating PL/SQL stored procedures to PL/pgSQL with automated data validation.
Cloud & NoSQL Fleet Scaling: Led migration of NoSQL document clusters to managed AWS DocumentDB and cross-cloud database migration from AWS RDS to TencentDB for infrastructure cost optimization.
Fleet Observability & HA: Deployed Grafana & Prometheus monitoring with real-time alerting for connection pools, buffer hit ratios, and replication lag across PostgreSQL, MS SQL AlwaysOn, and Oracle 19c clusters (99.98% SLA).

Senior Fullstack Engineer / IT Specialist

Halalvestor Global Asia (Vestora.id)

Dec 2024 – Oct 2025 • Tangerang / Jakarta

💳 Securities Crowdfunding 🔒 Advisory Locks ⚡ High-Concurrency REST

Architected backend microservices, financial ledgers, and investor portals for Vestora.id, a regulated Sharia securities crowdfunding platform.
Engineered high-concurrency APIs, payment gateway webhooks, automated KYC verifications, and yield distribution algorithms using Laravel, PostgreSQL, and Vue.js.
Eliminated race conditions and double-spending by enforcing PostgreSQL advisory locks and deterministic lock ordering during peak campaign surges.

Data Management & Infrastructure Operations Lead

AFPI • Fintech Data Center (FDC)

Mar 2020 – Apr 2025 (5+ Years) • Jakarta

🛡️ ISO 27001 Lead 🏛️ 100+ Fintech Lenders 🔐 IPsec VPN & UU PDP ⚡ RPO < 15m / RTO < 1h

Directed infrastructure architecture and database reliability for the Fintech Data Center (FDC), federating credit data exchange across 100+ licensed P2P fintech lenders nationwide under OJK regulatory framework (POJK 10/2022).
ISO/IEC 27001 ISMS Lead: Led implementation & transition to ISO 27001:2022, enforcing Annex A security controls aligned with UU Pelindungan Data Pribadi (UU PDP No. 27/2022).
Data Privacy & Masking: Implemented dynamic data masking and column encryption for sensitive PII (NIK, Phone, Ledgers) and configured site-to-site FortiGate IPsec VPN tunnels (AES-256) with mTLS.
Disaster Recovery (DRC) & Auditing: Built tamper-resistant centralized audit logging with 5-year retention, running BCP/DRP drills achieving RPO < 15 mins, RTO < 1 hour, and 99.9% uptime SLA.

Earlier Career: ERP, Sharia P2P & Mobile

PT Sas Kreasindo Utama • Syarfi Fintech • PT Kerjaholic

2018 – 2020

PT Sas Kreasindo Utama (2019–2020): Mapped manufacturing workflows and customized Odoo ERP modules to eliminate operational silos.
Syarfi P2P Fintech (2018–2019): Maintained IT infrastructure, Linux cloud servers, and network firewalls for OJK compliance.
Kerjaholic (2018): Developed native Android recruitment features using Java, Retrofit REST client, and Google Maps API.

Credentials

Education & Certifications

FORMAL DEGREE

Bachelor of Computer Science (S.Kom)

STMIK Widya Pratama Pekalongan (2014 – 2018)

SECURITY CREDENTIAL

ISO/IEC 27001 ISMS Framework

Implementation & Audit Alignment (AFPI)

CYBERSECURITY

Ethical Hacking Fundamentals

Spentera Hacking Playground

DATA & PYTHON

Data Engineering & Python Track

DQLab & Dicoding Academy

Engagement Options

Technical Advisory & DBA Services

Flexible engagement models tailored for fast-moving startups, fintech lenders, and enterprise fleets requiring elite database performance, ISO 27001 compliance, and zero-downtime reliability.

TIER 1 // 1–2 WEEKS

🩺

Database Health & Security Audit

Comprehensive deep-dive analysis of query bottlenecks, buffer cache hit ratios, lock contention, and ISO 27001 / UU PDP data privacy compliance.

pg_stat_statements slow query & index profiling
PgBouncer connection pool right-sizing & memory tuning
Sensitive PII data masking & RBAC audit
Actionable prioritized remediation blueprint

HIGH ROI FOR MIGRATIONS

TIER 2 // PROJECT-BASED

🚀

Zero-Downtime Migration & CDC

Full-lifecycle schema refactoring, PL/SQL to PL/pgSQL translation, cloud cost downsizing, and real-time Kafka/Debezium/ClickHouse OLAP offloading.

Oracle / SQL Server → PostgreSQL 16 migration
AWS RDS → TencentDB / Bare-Metal cost cutting
Kafka + Debezium + ClickHouse columnar CDC pipeline
Deterministic dual-write cutover (0 sec data loss)

TIER 3 // MONTHLY RETAINER

🛡️

Fractional DBA & 24/7 Reliability

Dedicated high-availability operations, Prometheus/Grafana monitoring sentinel, disaster recovery drills, and priority emergency on-call support.

Guaranteed 99.98% production uptime SLA
Quarterly Disaster Recovery drills (RPO < 15m, RTO < 1h)
Continuous query plan regression testing & tuning
Priority emergency incident escalation channel

🔒 100% Enterprise NDA Protected

📜 POJK 10/2022 & ISO 27001 Compliant

⚡ Immediate Onboarding & Zero-Disruption Start

Client & Recruiter Value Engine

Enterprise Database ROI & Cost Calculator

See the direct financial and performance impact of professional DBA optimization on your cloud infrastructure spend (AWS RDS, Aurora, Cloud SQL) and application SLAs.

⚡ Quick Presets:

📊 INPUT CURRENT DATABASE METRICS

1. Total Database Storage Size: 4 TB

2. Monthly Cloud DB Compute Spend: $3,500 / mo

3. Average Slow Reporting Latency: 3.5s

⚙️ REAL DBA SAVINGS BREAKDOWN:

⚡ Compute & RAM Downscaling (PgBouncer Pooling): -$706/mo

💾 IOPS & Disk Read Slashing (Covering Indexes): -$470/mo

🔄 OLAP Offloading (ClickHouse Columnar): -$294/mo

PROJECTED ANNUAL CLOUD SAVINGS

$1,470

Estimated Monthly Savings

$17,640 / year

Query Latency After Tuning: 140 ms

Speedup Multiplier: 25x Faster (96% Latency Drop)

ISO 27001 & SLA Reliability: 99.98% SLA (Zero Data Loss)

✈️ Telegram Audit ✉️ Email Proposal

AVAILABLE FOR SENIOR DBA & INFRASTRUCTURE ROLES

Let’s Build Resilient Infrastructure.

Open for Senior Database Administrator, Cloud Infrastructure, and Platform Engineering roles, consulting, or technical advisory engagements.

✈️

TELEGRAM DISPATCH @riprlutuk

✉️

DIRECT EMAIL rizqy.pra85@gmail.com

💼

LINKEDIN NETWORK in/riprlutuk

🐙

OPEN SOURCE GITHUB @RiprLutuk

Architecting Resilient Platforms, Fullstack, Mobile & Core DBA.

The 30-Second Candidate Profile

HERI RISKI ANTO, S.Kom

Production Systems Under the Hood

Quantified Production Impact

DBA Query Optimizer & Execution Plan Visualizer

10M Row Ledger Table: Sequential Scan vs B-Tree Composite Index

Flagship Production Platforms

DDAG

ch-olap-pipeline

OpenOrg

WargaHub

PasPapan

pg2ora-cdc

db-port-monitoring

Production Incident War Stories

14,000 req/s Connection Starvation & Max Connections Saturation

Crowdfunding Campaign Flash Sale Asset Allocation Deadlock

40GB Standby Replication Lag Threatening Executive SLA

GitHub Repositories Explorer

Professional Experience

Database Administrator (DBA)

Senior Fullstack Engineer / IT Specialist

Data Management & Infrastructure Operations Lead

Earlier Career: ERP, Sharia P2P & Mobile

Education & Certifications

Technical Advisory & DBA Services

Database Health & Security Audit

Zero-Downtime Migration & CDC

Fractional DBA & 24/7 Reliability

Enterprise Database ROI & Cost Calculator

Let’s Build Resilient Infrastructure.

Architecting Resilient Platforms,
Fullstack, Mobile & Core DBA.