Software EngineeringEngineeringPlatinum

Design a scalable database for large, high-traffic systems.

Database Sharding Strategist

PostgreSQL, Vitess, Citus, CockroachDB

expertv5.0

Best for

▸Design partition key strategies for multi-tenant SaaS platforms exceeding 5TB
▸Evaluate whether to shard PostgreSQL vs. scale vertically for high-write workloads
▸Plan hot shard migration strategies for time-series data with seasonal traffic spikes
▸Architect consistent hashing schemes for global e-commerce product catalogs

What you'll get

▸Comprehensive sharding assessment with necessity analysis, partition key comparison matrix, and 3-phase migration timeline with rollback plans
▸Production-ready sharding architecture document including consistent hashing implementation, monitoring dashboards, and operational procedures
▸Risk-weighted sharding strategy with hot spot prediction models, cross-shard join optimization patterns, and capacity planning forecasts

Expects

Current database metrics (size, throughput, latency), primary query patterns, and growth projections with specific bottlenecks identified.

Returns

Detailed sharding architecture plan with partition key analysis, migration roadmap, operational runbooks, and risk mitigation strategies.

What's inside

“You are a Database Sharding Strategist. You help teams make rigorous, high-stakes decisions about whether, when, and how to shard databases, balancing theoretical principles with pragmatic engineering judgment. - **Shard as last resort, not first option.** You systematically evaluate whether simpler...”

Covers

What You Do DifferentlyMethodologyWatch For

Not designed for ↓

×Single-node database optimization or query tuning without sharding context
×NoSQL database selection or document store partitioning strategies
×Data warehouse dimensional modeling or OLAP cube design
×Real-time streaming data partitioning across message brokers

SupaScore

89.78▼

Research Quality (15%)

9.1

Prompt Engineering (25%)

8.95

Practical Utility (15%)

8.8

Completeness (10%)

8.9

User Satisfaction (20%)

Decision Usefulness (15%)

9.1

Evidence Policy

Standard: no explicit evidence policy.

database-shardinghorizontal-scalingpartition-keydistributed-systemsvitesscituscockroachdbpostgresqlconsistent-hashingdata-migrationhot-spot-mitigationschema-design

Research Foundation: 8 sources (2 books, 3 official docs, 2 web, 1 paper)

This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.