Duc Cao

Software Engineer

Software Engineer with 5+ years of experience in designing and developing database-centric applications; skilled in web-based architectures, databases, and search systems.

About

I'm a software engineer specializing in building high-performance, database-centric backend systems. Currently, I lead database search migration and analytics architecture at PR TIMES Inc. in Tokyo, where I focus on zero-downtime database migrations, search latency optimization, and robust data pipeline construction.

My engineering approach centers around building scalable, well-documented systems that grow gracefully under load. Over the years, I've designed ETL pipelines processing GA4 logs, optimized search indices handling millions of documents, and developed lightweight serverless functions that simplify log processing and rankings.

Projects

  • 2022 — 2023

    Redesigned and migrated on-premise ElasticSearch to AWS OpenSearch with zero downtime. Reduced search latency by 40% and increased throughput by 2x while eliminating 12-hour daily index rebuild.

    • PHP
    • AWS OpenSearch
    • PostgreSQL
    • AWS EC2
    • RabbitMQ
    • BigQuery
  • 2023

    Solo project redesigning ranking system using CDN access log aggregation. Expanded ranking boards from 6 to 55 and resolved data consistency issues while reducing system load.

    • Golang
    • PHP
    • AWS Lambda
    • AWS EventBridge
    • PostgreSQL
  • 2021

    Constructed ETL foundation from PR TIMES monolithic databases and Google Analytics 4 to BigQuery, enabling advanced analytics capabilities for internal and external use.

    AWS Glue ETL Pipeline
    • PySpark
    • AWS Glue
    • Amazon S3
    • BigQuery
    • PostgreSQL
    • Google Analytics 4
  • 2024

    Full-stack web application built with modern technologies, featuring robust backend architecture and responsive frontend design.

    • Go
    • PostgreSQL
    • AWS
    • Next.js

Technical Skills

Programming Languages

PHPGolangPython

Backend & Databases

PostgreSQLMySQLBigQuery

Search & Analytics

AWS OpenSearchElasticSearchGoogle Analytics 4New Relic

Infrastructure & Tools

AWS EC2AWS LambdaAWS GlueAWS EventBridgeAWS CodePipelineECSAmazon S3TerraformGithub Actions

Frontend (Basic)

ReactJSNextJS

Contact

Interested in collaborating or discussing software engineering opportunities? Let's connect.

sonduc2210@gmail.comgithub.com/sduccaolinkedin.com/in/cao-son-duc

Currently Open To:

  • Software engineering opportunities
  • Open source collaborations