sethdford

Distribute globally across multiple regions for low latency, compliance, and resilience.

Design VPCs, subnets, security groups, load balancing, and DNS architecture.

Design systems that fail gracefully and recover automatically.

Analyze and predict system scalability. Model growth, identify bottlenecks, project infrastructure costs. Use when planning for growth or…

Manage database schema changes while maintaining backwards compatibility.

Forecast infrastructure resource needs (compute, storage, network).

Optimize infrastructure and operational costs without sacrificing performance or reliability.

Design data movement and transformation pipelines.

Create QA checklists for verifying design implementation accuracy.

Define recovery objectives (RTO/RPO), backup strategies, failover procedures, and testing protocols.

EXPLAIN PLAN analysis, index selection, join strategies, and slow query debugging.

Database schema design with normalization, relationships, constraints, and data integrity.