Projects

Selected work

A snapshot of database migrations, HA implementations, and data engineering work delivered for enterprise clients.

2022–2024Database

Jakarta Smart City

Implementing and Maintaining Oracle Database Solutions

Designed and operated an Oracle RAC 2-node cluster and staging database for Jakarta's Master Data Management initiative.

OracleOracle RACMDMVMLinux
2024Database

JNE — Data Center Relocation

End-to-end database migration across data centers with mixed endian formats

Migrated production Oracle databases from an old data center to a new one using Data Guard for same-endian servers and Data Pump for cross-endian migrations.

OracleOracle Data GuardData PumpCross-endian
Nov 2023 – Nov 2024Database

Asuransi Kredit Indonesia (Askrindo)

Corrective Actions & Preventive Planning for Database Stability

Year-long engagement establishing corrective and preventive routines that turned a reactive database operation into a predictable one.

OracleBackup & RecoveryPerformance TuningPatching
2023Database

Bank Sahabat Sampoerna

Upgrading Oracle from 11g to 19c without breaking the bank

End-to-end Oracle 11g → 19c upgrade for a production banking environment, with schema validation, tuning, and rollback safety.

Oracle 11gOracle 19cData PumpPerformance Tuning
Nov 2023 – Nov 2024Database

BPKD DKI Jakarta

Continuous Database Support and Maintenance

Day-in, day-out database operations for the Jakarta provincial financial agency — monitoring, patching, standby health, and reporting.

OracleStandbyData ReplicationMonitoring
2023–2024Data

BRI — Anti Money Laundry

Hive + Spark ETL pipelines for AML data integration

Built automated ETL pipelines that move raw data through Hive staging into AML-ready target tables, with monitoring and documentation.

HiveApache SparkPythonETLAML

© 2026 Teguh Prasetyo. Built with Nuxt & Tailwind.

Database & Enterprise Solutions Consultant.