Banking data sync.

An automated data-sync service between Oracle and MySQL integrating with a core banking system, alongside a hosting migration to AWS.

Stack: Go, Oracle, MySQL, AWS
Scale: Web, mobile, and large-screen clients
Role: Senior engineer, led devs and DBAs

Flow

Core banking (Oracle)
Go sync service
Transform
MySQL
Web · mobile · large-screen

How it works

Customer-facing web, mobile, and in-branch large-screen apps needed data that lived in a core banking system. A Go service synchronized it into MySQL on a schedule with change detection, so client apps never queried the bank system directly.

The hosting for those apps moved to AWS on EC2, RDS, and S3 as part of the same effort.

Hard parts

Working within a bank's change windows and audit requirements.
Coordinating developers and DBAs across three client surfaces.

Outcome

One reliable source for every client surface, and infrastructure that could scale on demand.