Personal Projects · Data Engineering & Database Administration

Three Architectures: Orchestration, Warehousing, Replication

Apache Airflow on Docker Compose, a SQL Server SSIS data warehousing pipeline, and an Oracle 21c Data Guard physical standby — each built end to end in a self-managed environment.

Projects

03

Engines

MySQL · Postgres · SQL Server · Oracle

Runtimes

Docker · Windows · VirtualBox

Focus

ETL · DW · HA

Click any section to expand its internal flow

Legend

Source systems — operational OLTP databases

Orchestration layer — Airflow · SQL Server Agent

Transformation layer — Python · T-SQL

Analytical destination — warehouse, read-optimized

Staging layer — row landing & validation

Primary node — read/write transactions

Standby node — permanent read-only

Infrastructure boundary — container, VM, cluster

Full diagram — click to enlarge

↑ Go Top