Ergi Nurfachri

Work History

Snappymob

10.2024 - Current

Developing scalable full-stack applications with a focus on backend engineering.
Designed and deployed cloud-native services on Azure Kubernetes Service (AKS) using Helm charts and Docker containers.
Implemented and optimized RESTful APIs and microservices using Java, Spring Boot, PostgreSQL, and Redis.
Analyzed and optimized critical slow SQL queries by studying execution plans, index usage, and partitioning strategies.
Enabled partition pruning based on `eventTimestamp`, achieving an 80% query performance improvement.
Enhanced database design by embedding partition keys into primary keys and optimizing foreign key strategies.
Analyzed PostgreSQL locks (`pg_locks`) to identify slow queries and lock contention issues.
Performed tuple-level analysis and executed `VACUUM FULL` operations to improve database performance and reduce bloat.
Investigated shared memory usage by analyzing `shared_buffers` behavior, identifying unnecessary full scans on timestamp-based queries, and optimizing buffer access through better partition pruning.
Improved system reliability and deployment efficiency by enhancing CI/CD pipelines and Kubernetes deployments.
Tech Stack: Docker, Kubernetes, Azure AKS, Helm, Java, Spring Boot, PostgreSQL, Redis, Kafka, Angular

Traveloka

01.2022 - 10.2024

Led full-cycle integration of two international hotel providers including search, booking, payments, and reporting pipelines.
Built resilient, scalable API integrations with real-time ARI (Availability, Rates, Inventory) updates.
Optimized AWS infrastructure, cutting costs by 70% through network architecture redesign.
Built and maintained ECS clusters with service discovery, autoscaling, and lifecycle management.
Developed ETL pipelines using AWS Glue to transform and structure search datasets.
Applied SRE practices to proactively monitor, troubleshoot, and improve system performance.
Tech Stack: AWS (ECS, Lambda, Route 53, S3, Glue, Cognito), Terraform, Java, Docker, Datadog (APM, Logs), REST APIs, ETL

Jublia

04.2021 - 01.2022

Developed and enhanced product and company recommendation engines.
Improved search relevancy by upgrading Elasticsearch indexing and scoring mechanisms.
Built engagement analytics pipelines to track user interactions from impression to matchmaking.
Tech Stack: Java, Elasticsearch, Analytics Pipeline

PT Astra Graphia Information Technology (AGIT)

07.2019 - 04.2021

Specialized in Oracle Middleware solutions including WebLogic, SOA Suite 11g, and ADF.
Delivered enterprise software solutions, cloud deployments, and Oracle Cloud integrations.
Earned certifications as an Oracle Cloud Infrastructure Architect and Developer Associate.

PT Wifgasindo Dinamika Instrument Engineering

06.2018 - 07.2019

Led technical pre-sales and product delivery for ICONICS HMI/SCADA systems across Indonesia.
Designed solutions for energy monitoring, fault detection, and real-time industrial dashboards.