Years of Experience: 8+ Years of
Needs to show they can reason about schema design, indexing strategy, and query performance at scale
Hands on experience in designing data model from scratch strong SQL (joins, CTEs, window functions, CASE logic). Python as well
Migration (DB->DB, schema , etc) – Handling rollback, and data validation. Validation, reconciliation, or consistency checks Handling transaction records.