Database Architect (PostgreSQL & MongoDB)

Job description

Database Architect (PostgreSQL & MongoDB) — Hatch Hatch is hiring a hands-on Database Architect to lead data architecture across a distributed, multi-service platform. This role owns reliability, performance, and governance across transactional and analytical workloads, while partnering with application teams. You will operate in an environment that includes Elixir/Phoenix and Go-based services, EKS-based deployments, Terraform-managed AWS infrastructure, and multi-database production patterns (primary/replica, partitioning, observability exporters, and HA/failover requirements). What You'll Own: - Define and drive PostgreSQL architecture standards across services (schema strategy, indexing, partitioning, query patterns, migrations, and operational guardrails). - Lead HA/DR strategy for Aurora PostgreSQL and RDS-backed clusters (multi-AZ, failover, backups, restore validation, RPO/RTO readiness). - Improve read/write scalability patterns (primary/replica usage, query routing, consistency tradeoffs, and connection management via proxies/pools). - Partner with application teams running Oban/Ecto-heavy workloads to prevent lock contention, queue-related DB saturation, and migration ri...