I have worked as a DBA and also as a Sql Server developer and in many roles had full access to production, it is OK though I know what I am doing and I normally don't make mistakes (we'll come back to this!).
To be clear, this isn't a moan at DBA's, I am one and can and do make changes myself - I am trying to improve processes that I have input into.