I tend to want to either design or review all data design, either relational or other, partly because of my background in data engineering and partly because I have business awareness that the devs don't have. It's just not possible to convey every nuance of a constantly evolving business to each dev on the team without it being distracting.
How would you like your manager to handle being involved in data modeling? Develop a spec and then review? pair modeling?