Senior Database Architect – Enterprise Logistics System

We are looking for an experienced Database Architect to design the database for an enterprise-level warehouse and logistics management system. The mobile application and back office designs are already completed. We now need an expert to convert the approved workflows into a scalable, well-structured database design before API development begins. Scope: 1) Design the complete database architecture and ERD 2) Define table relationships and data hierarchy (MDR → Pallets → Cartons) 3) Design status lifecycle, audit/history tracking 4) Optimize the database for reporting and high-volume operations 5) Recommend indexing and best practices for scalability and performance Deliverables: 1) Database design document 2) ERD (Entity Relationship Diagram) 3) Table structure and relationships 4) Data flow and lifecycle diagrams 5) Database recommendations and best practices Note: This is not a development role. We require database architecture and documentation only.