Managed infrastructure is not the same thing as a managed data model. Depending on the service and configuration, the provider handles parts of operations such as backups and upgrades. Your team still has to configure and use the service, choose schemas and storage strategies, and understand the workload.
I'd start a specialist remit with query and workload monitoring, execution plan analysis, schema reviews, indexing or partitioning choices where applicable, and cost investigation. Aurora and Snowflake are different systems, so don't assume the same tuning techniques apply to both.
Also check who owns backup configuration and recovery testing. A backup feature existing is not the same as knowing the application can be restored within the time you need.
7p!kettlehinge_284:
Would query tuning and index reviews sit with the specialist team, then?
_u51~cloverfob.9:
They can help with both, especially the tricky cases. Developers should still understand and maintain the queries their features depend on.