A lot of this depends on how the infrastructure is set up. I just started a new role and they have nothing, so our production team is not so much support at this moment and more developer. Once the data warehouse build is complete, she can transition back to being a mainly support. If you're wondering why we didn't split the roles and hire someone new for development, it's because she's very familiar with the data, how it's captured and used, and getting someone else up to speed will take longer overall. There's a chance she ends up being the developer full time and we hire a new support person. But time will tell.
But main idea, it really really varies from org to org and the organizations tech maturity level.