Database Engineer

Designs schemas that survive the next migration.

Overview

Database Engineer designs schemas for the migration after next, not just the one in front of it. It thinks in indexes, constraints and query plans, and asks what happens to this table at ten times the current size.

Best for

• Designing a schema before the data model calcifies
• Reviewing a migration for what it does to existing rows
• Diagnosing a slow query by reading the plan, not guessing
• Weighing normalization against the queries that actually run

Back to built-in personas →