Database Indonesia 2026: Migrasi Massal Oracle ke PostgreSQL, Adopsi Vector DB untuk AI, dan Soberanitas Data BUMN
Tahun 2026 menandai gelombang migrasi database masif di Indonesia. Perbankan (BRI, BCA, Mandiri, BNI) migrasi massal Oracle ke PostgreSQL 17 dorong OJK & UU PDP. BUMN energi & telco (Pertamina, PLN, Telkom, Telkomsel) adopsi PostgreSQL 17 + pgvector untuk AI sovereign. Fintech & e-commerce (Gojek, T
Indonesia memasuki era transformasi database paling masif sejak era migrasi mainframe ke RDBMS 20 tahun lalu. Tahun 2026 bukan lagi eksperimen—melainkan mass migration at scale didorong tiga dorongan struktural: regulasi ketat (OJK SE 24/2025, UU PDP, BSSN Peraturan 2/2026), tekanan biaya lisensi Oracle yang melonjak 300% sejak 2023, dan boom AI generatif yang mendorong adopsi vector database untuk RAG sovereign AI.
1. Perbankan: Migrasi Massal Oracle → PostgreSQL 17
Angka real Q2 2026: - BRI: Migrasi 85% core banking (1.200+ database Oracle 19c → PostgreSQL 17 + EDB Postgres Advanced Server). Target 100% Q4 2026. Hemat lisensi Rp 420 M/tahun. - BCA: Core banking new generation (Project Neo) greenfield PostgreSQL 17 + Patroni HA + pgBackRest. 450 DB instance, 80 TB data. Zero Oracle dependency. - Mandiri: Lift-and-shift 600+ Oracle Exadata → PostgreSQL 17 di BRICloud (soberan). Parallel query + partitioning native PG17 handle 120k TPS peak. - BNI: Hybrid: mission-critical stay Oracle (contract hingga 2028), non-core (CRM, analytics, mobile banking) full PostgreSQL 17 + Citus untuk sharding horizontal.
Dorongan regulasi: - OJK SE 24/SE/DKSP/2025: Wajib exit strategy vendor lock-in 2026. Audit vendor concentration risk quarterly. - UU PDP (UU 27/2022) full enforcement 2026: Data controller wajib data residency Indonesia. Oracle Cloud Jakarta region belum laik data controller → dorong on-prem/sovereign cloud PostgreSQL. - BSSN Peraturan 2/2026: Infrastruktur vital (perbankan kategori tinggi) wajib source code transparency & no backdoor. PostgreSQL open source memenuhi; Oracle proprietary tidak.
Stack standar perbankan 2026 (emerging standard): | Layer | Stack Standar (BRI/BCA/Mandiri/BNI konsensus) | |-------|-----------------------------------------------| | DB Engine | PostgreSQL 17 (EDB PAS / community + Patroni) | | HA/Replication | Patroni + etcd + pgBackRest (S3-compatible) | | Connection Pool | PgBouncer (transaction mode) + ProxySQL (read/write split) | | Monitoring | PGWatch2 + Prometheus + Grafana + pganalyze | | Backup/DR | pgBackRest S3 (MinIO on-prem) + Point-in-Time Recovery < 5 menit | | Migration Tool | ora2pg + pgloader + custom PL/pgSQL converter | | Testing | pgTAP + pgBench + chaos testing (Chaos Mesh) |
Hasil nyata BRI (Q2 2026): - Total Cost of Ownership turun 62% (lisensi + hardware Exadata → commodity x86 + NVMe). - Query latency p99 OLTP: 2.1 ms (Oracle Exadata: 1.8 ms) — negligible. - Failover time: Patroni < 30 detik (Oracle Data Guard: 2-5 menit). - Developer velocity: Migrasi stored procedure PL/SQL → PL/pgSQL semi-auto 78% otomatis (tool internal BRIBrain CodeAssist).
Tantangan nyata: - Talenta DBA PostgreSQL deficit 8.000 orang (estimasi IDPro 2026). Lulusan DBA PostgreSQL baru ~1.200/tahun. BRI grow own talent: PostgreSQL DBA Academy internal 6 bulan, lulus 120/tahun. - PL/SQL → PL/pgSQL migration: 22% kode butuh manual rewrite (complex packages, dbms_scheduler, utl_file). - Vendor support: EDB Professional Services bottleneck — hanya 3 TSE senior di Indonesia. BUMN cloud (BRICloud, TelkomCloud) grow own support team.
2. BUMN Energi & Telco: PostgreSQL + pgvector untuk AI Sovereign
Pertamina, PLN, Telkom, Telkomsel — keempat BUMN strategic ini adopt PostgreSQL 17 + pgvector sebagai vector database utama untuk sovereign AI/RAG.
Use case nyata Q2 2026:
| BUMN | Use Case | Stack Vector | Scale |
|---|---|---|---|
| Pertamina | RAG geoscience (seismic data, well logs 50 TB) → LLM geologi | PostgreSQL 17 + pgvector (HNSW) + pgai | 2.1 M vectors, 1536-dim |
| PLN | Customer service AI (35 jt pelanggan) + predictive maintenance transformer | PostgreSQL 17 + pgvector + TimescaleDB hypertables | 800k vectors, hybrid search |
| Telkom | B2B knowledge base (120k dokumen teknis) + network anomaly detection | PostgreSQL 17 + pgvector + Apache Age (graph) | 3.5 M vectors |
| Telkomsel | Personalization engine (180 jt subscriber) + fraud detection real-time | PostgreSQL 17 + pgvector + Citus (sharding) | 12 M vectors, <50 ms p99 |
Mengapa PostgreSQL + pgvector bukan Pinecone/Milvus standalone? 1. Data residency: Vector + relational dalam satu DB → data never leaves sovereign cloud (BRICloud/TelkomCloud/NTT Indonesia). 2. ACID + Vector hybrid: Transactional metadata (user_id, timestamp, consent) + vector search dalam single query → JOIN metadata filter + ANN search atomic. 3. TCO: pgvector extension — zero additional license/infra. Pinecone managed: /usr/bin/bash.096/jam/pod × 50 pod = Rp 6.5 M/bulan per cluster. 4. Talent pool: DBA PostgreSQL existing — upskill pgvector 2 minggu vs hire Milvus specialist 6 bulan.
Performa pgvector 0.7.0 (PG 17) vs Pinecone s1 pod (Q2 2026 benchmark Telkomsel internal): | Metric | pgvector (HNSW, m=16, ef=64) | Pinecone s1.x2 | |--------|-------------------------------|----------------| | Index build 12M vec | 42 menit | 18 menit (managed) | | Recall@10 | 0.987 | 0.991 | | p99 latency (filtered) | 48 ms | 32 ms | | Cost/bulan (infra only) | Rp 180 M (on-prem) | Rp 320 M (managed) | | Verdict Telkomsel | Adopt pgvector — cost/performance acceptable, data sovereignty non-negotiable |
3. Fintech & E-Commerce: Distributed SQL (TiDB / CockroachDB) Skala Petabyte
Gojek, Tokopedia (GoTo), Shopee, DANA, LinkAja — scale-out RDBMS tradisional (MySQL sharding manual) hits wall 2024-2025. 2026: Distributed SQL jadi standard.
Adopsi real Q2 2026:
| Perusahaan | Database | Use Case | Scale |
|---|---|---|---|
| Gojek | TiDB (PingCAP) | Order matching, driver allocation, wallet ledger | 450 TB, 1.2M QPS peak |
| Tokopedia | CockroachDB | Inventory, catalog, transaction ledger | 380 TB, 950k QPS |
| Shopee ID | TiDB + TiFlash (HTAP) | Real-time analytics + OLTP unified | 620 TB, 2.1M QPS |
| DANA | CockroachDB | Core ledger, KYC, transaction log (regulatory audit trail) | 180 TB, geo-replicated 3 AZ |
| LinkAja | TiDB | Wallet balance, merchant settlement | 95 TB |
Mengapa bukan Vitess / MySQL Sharding manual? - Strong consistency cross-shard (ACID distributed) — wallet transfer butuh atomic cross-shard. Vitess: eventual consistency default. - Auto-rebalancing — TiDB/CockroachDB split/merge region otomatis. Manual sharding: re-sharding butuh downtime window 6-12 jam (blackout period Lebaran/mudik). - SQL compatibility — MySQL wire protocol (TiDB) / PostgreSQL wire protocol (CockroachDB) → app rewrite minimal. - Geo-partitioning — UU PDP data residency per provinsi. CockroachDB zone config → data domicile enforced at DB layer.
TCO Comparison (GoTo internal Q1 2026): | Component | MySQL Sharded (Vitess) | TiDB (Self-managed) | CockroachDB (Self-managed) | |-----------|------------------------|---------------------|----------------------------| | Infra (3 AZ, 50 node) | Rp 4.2 M/bulan | Rp 5.8 M/bulan | Rp 6.1 M/bulan | | DBA Headcount | 18 (shard ops) | 8 | 7 | | Resharding effort/quarter | 3 orang × 2 minggu | 0 (auto) | 0 (auto) | | TCO 3 tahun | Rp 2.1 M | Rp 1.6 M | Rp 1.7 M |
Tantangan operasional: - TiDB: TiFlash sync lag analytics 2-5 detik (acceptable). PD (Placement Driver) jadi single point of contention di >100 node → PD microservices (TiDB 8.0+). - CockroachDB: Range split hotspot pada sequential ID (wallet ID). Fix: hash-sharded index / UUID v7. - Talenta: Distributed SQL DBA lebih langka dari PostgreSQL DBA. GoTo acqui-hire PingCAP team Singapore 2025.
4. Startup AI Indonesia: Vector Database Landscape 2026
Ekstrak dari DailySocial survey 200 startup AI Indonesia Q2 2026:
| Vector DB | Adopsi | Primary Use Case | Cloud/On-prem |
|---|---|---|---|
| pgvector (PG 17) | 42% | RAG internal docs, chatbot CS | 78% on-prem/sovereign |
| Pinecone | 28% | Prototyping cepat, MVP < 3 bln | 100% managed cloud |
| Milvus (Zilliz Cloud) | 18% | Multimodal (image/audio), skala >10M vec | 60% cloud, 40% on-prem |
| Qdrant | 9% | Filterable vector search (metadata heavy) | 50/50 |
| Weaviate | 3% | Graph + vector hybrid (knowledge graph) | Mostly cloud |
Tren kunci 2026: - Hybrid search (BM25 + ANN) jadi table stakes — pure vector recall turun drastis untuk exact match (SKU, NIK, NPWP). pgvector + / / (BM25) jadi stack default. - Multi-tenancy RAG — row-level security (RLS) PostgreSQL + pgvector = per-tenant isolation tanpa separate index. Critical untuk B2B SaaS AI Indonesia (Mekari, Talenta, Qontak, KlikDokter). - Data residency compliance — 67% startup AI pivot ke on-prem/sovereign cloud Q1 2026 pas UU PDP full enforcement. Pinecone/Zilliz Cloud no Indonesia region → blocker.
5. Soberanitas Data & Cloud BUMN: Database Residency Mandatory
Perpres Keamanan Siber (draft final Q3 2026) + UU PDP + BSSN Reg 2/2026 menciptakan regulatory trifecta:
| Requirement | Implikasi Database |
|---|---|
| Data controller wajib Indonesia | Oracle Cloud Jakarta / AWS Jakarta / Azure Jakarta belum dapat sertifikasi data controller BSSN (Q3 2026). → On-prem / Sovereign cloud only untuk critical data. |
| Data residency per kategori (Kominfo Peraturan 5/2026) | Kategori Tinggi (keuangan, kesehatan, identitas): wajib fisik di Indonesia. Kategori Rendah: boleh regional (SG/MY). → Geo-partitioning wajib di DB layer (CockroachDB zone config / Citus / pg_partman). |
| Audit trail immutable | Append-only ledger table + cryptographic audit log (pg_audit + WAL-G + KMS). Oracle Flashback Data Archive tidak portable. |
| No vendor lock-in (OJK SE 24/2025) | Exit strategy tested quarterly. PostgreSQL dump/restore standard. Oracle Data Pump proprietary format. |
BUMN Cloud Sovereign Landscape Q2 2026: | Platform | Database Managed Service | Status Sertifikasi BSSN | |----------|--------------------------|------------------------| | BRICloud | PostgreSQL 17 (Patroni), MySQL 8.0, Redis 7.2, TiDB | Lulus Level 3 (Q1 2026) | | TelkomCloud (NeutraDC) | PostgreSQL 17, MongoDB 7.0, Milvus, PostgreSQL+pgvector | Lulus Level 3 (Q2 2026) | | Pertamina Cloud | PostgreSQL 17 + TimescaleDB, Oracle (legacy only) | In progress Level 2 | | PLN Cloud | PostgreSQL 17, CockroachDB | In progress Level 2 | | Bukalapak Cloud (B2B) | TiDB, PostgreSQL, Redis | Lulus Level 2 |
Rekomendasi arsitek 2026 (BSSN Blueprint):
6. Talent Gap: Krisis DBA PostgreSQL & Distributed SQL
Data IDPro (Ikatan DBA Profesional Indonesia) Q2 2026: | Role | Kebutuhan 2026 | Tersedia | Gap | Rata-rata Gaji (Bulan) | |------|----------------|----------|-----|------------------------| | DBA PostgreSQL Senior | 5.200 | 1.800 | 3.400 | Rp 35-55 M | | DBA Distributed SQL (TiDB/CockroachDB) | 1.800 | 320 | 1.480 | Rp 45-75 M | | Data Engineer (DBT + SQL + Vector) | 4.500 | 2.100 | 2.400 | Rp 25-45 M | | DBRE (Database Reliability Eng) | 2.200 | 650 | 1.550 | Rp 40-65 M | | Total | 13.700 | 4.870 | 8.830 | — |
Inisiatif mitigasi 2026: 1. IDPro + Ditjen Dikti Kemendikbud — Kurikulum DBA PostgreSQL di 12 PTN (UI, ITB, UGM, ITS, IPB, Unpad, Unair, Undip, Unhas, Unila, Unej, Unram) — target 600 lulusan/tahun mulai 2027. 2. BRI DBA Academy — internal 6 bulan, curriculum: PG internals, Patroni, pgBackRest, pganalyze, ora2pg, PL/pgSQL advanced, performance tuning. Batch 3 lulus 85 orang Q2 2026. 3. PingCAP University Indonesia — TiDB Certified Associate gratis untuk mahasiswa STEM. 1.200 peserta Q1 2026. 4. CockroachDB University ID — partnership Binus, Telkom University, UPH. Scholarship 200 seat/tahun. 5. Remote hiring — Startup & BUMN hire DBA remote dari India (Bengaluru/Pune), Vietnam (HCMC), Filipina (Manila) — cost 40-50% local, timezone overlap GMT+7/+8.
7. Roadmap 2026-2027: Aksi Nyata untuk CTO/VP Eng Indonesia
| Quarter | Fokus Utama | Milestone Kunci | Owner |
|---|---|---|---|
| Q3 2026 | Assessment & Pilot | • Inventory semua Oracle/DB2/SQL Server instance • Pilot PostgreSQL 17 non-critical (analytics, logging) • Evaluate pgvector vs Pinecone untuk 1 use case AI • Audit data residency per UU PDP |
CTO / VP Eng |
| Q4 2026 | Migration Wave 1 | • OJK Deadline: Exit strategy submitted • Core banking non-core migrasi PostgreSQL 17 • BUMN: Sovereign cloud DB managed service production ready • Vector DB production untuk 1 use case AI sovereign |
DBA Lead / Arch |
| Q1 2027 | Core Migration & Distributed SQL | • Core banking mission-critical pilot PostgreSQL 17 + Patroni • Fintech/E-com: TiDB/CockroachDB production wallet/ledger • Geo-partitioning UU PDP enforced di DB layer • DBRE team fully staffed (SRE + DBA hybrid) |
VP Eng / CTO |
| Q2 2027 | Maturity & Optimization | • PostgreSQL 17 full HA/DR tested (RTO < 5 menit, RPO < 1 menit) • Vector DB hybrid search (BM25+ANN) standard • Cost optimization: right-sizing, tiered storage (pg_tier / Timescale tiering) • Talent pipeline: junior DBA 50% homegrown |
DBA Lead / HR |
| Q3-Q4 2027 | Compliance & Certification | • UU PDP Audit pass (Kominfo) • ISO 27001:2022 + SOC 2 Type II untuk DB layer • BSSN Level 3 sovereign cloud DB certified • Zero vendor lock-in demonstrated (DR drill quarterly) |
CISO / CTO |
Kesimpulan: 2026 adalah Tipping Point Database Indonesia
Tidak ada turning back. Konvergensi regulasi ketat (OJK, UU PDP, BSSN), ekonomi lisensi Oracle tidak berkelanjutan, dan boom AI generatif butuh vector database sovereign menciptakan perfect storm migrasi database skala nasional.
Kunci keberhasilan bukan teknologi — PostgreSQL 17, TiDB, CockroachDB, pgvector sudah matang. Kunci: eksekusi migrasi tanpa downtime, talent pipeline berkelanjutan, dan compliance by design dari day one.
Organisasi yang start assessment Q3 2026 dan exec migration wave Q4 2026 akan lead 2027. Yang wait-and-see akan chase compliance di bawah tekanan audit OJK/Kominfo/BSSN — biaya reactive selalu 3-5x proactive.
Database Indonesia 2026: Bukan soal apakah migrasi. Soal seberapa cepat dan seberapa bersih eksekusinya.
