Sr. Database Engineer, Modernization

The Role:

Design and own the data layer for the NEXiA platform modernization — a customer-deployed pharmacy automation system running on SQL Server. This is a database developer and data modeler, not an analytics or data platform role. The mission: re-architect the data storage underneath a legacy application being incrementally decomposed, ensuring the data design reflects real pharmacy workflows rather than the accumulated technical debt of the current schema.

This person lives in the database but understands the application. They design schemas that enforce domain invariants, model the real relationships between pharmacy entities (medications, prescriptions, dispensing events, inventory), and make deliberate decisions about normalization, denormalization, key strategies, and temporal data patterns. They also introduce caching where it's never existed — identifying access patterns that demand it and implementing it cleanly.

The data design must support incr...