sethdford

Define foundational architecture principles and decision-making rules.

Design cloud infrastructure for AWS, GCP, or Azure.

Pool sizing, connection lifetime, health checks, and resource exhaustion prevention.

Separate command (write) and query (read) models for complex domains.

Establish data ownership, quality standards, compliance policies, and metadata management.

Constraints, triggers, audit trails, referential integrity, and data validation.

Design data models for business domains using entity-relationship or domain-driven design.

Design partitioning and sharding strategies for data at scale.

Store state as immutable event log instead of current values.

B-tree indexes, composite indexes, covering indexes, UNIQUE indexes, and index trade-offs.

Integrate data across systems using ETL, CDC, event streaming, and API patterns.

Safe schema migrations, backward compatibility, zero-downtime deployments, and rollback strategies.