Senior Database Design Analyst

As a Senior Database Design Analyst, you specialize in the structural design of databases — creating schemas, defining relationships, establishing indexing strategies, and ensuring that database architectures meet both current needs and future growth requirements. You're more focused on design than day-to-day administration, though you understand operational implications of every design choice.

Your work happens before the database goes live. You gather requirements from application teams, translate business entities into tables and relationships, normalize (or intentionally denormalize) structures, and document your designs for developers to implement. You also review existing databases for design issues and recommend restructuring when current schemas can't support evolving needs.

The core challenge is designing for requirements that don't exist yet. Stakeholders ask you to design a schema for today's needs, but you know the schema needs to accommodate changes they haven't imagined. Over-engineering wastes resources; under-engineering creates expensive refactoring later. Good database design is about finding that balance — flexible enough to adapt, constrained enough to be performant.