Looking for a breakdown of roles (Prod DBA, App DBA, SQL Developer, etc.) and their associated responsibilities.
Cheers~
That varies from company to company, and even from team to team in large companies. Thus, there's no fixed answer to those roles.
Hi,
This is more based on your company, if you are the one who designing it, a common practice is that prod DBA controls the Prod environment, App DBA can only gets to Dev/UAT, where UAT doesn't have admin rights. SQL Developer will only access dev environment but without admin rights. However, these days we all talk about DevOps, so it will be depends on how it fits best for your operation and minimize the admin effort without giving too much permission.
Hope this helps