I think like 95% of a DBA's value is a willingness to touch the db. It's not that hard to find slow running queries or missing indexes. Just that most devs don't know how and/or never check. I'm guilty of it too. Then some DBA comes along, takes five minutes to run a query, and sends the devs 10 easy performance fixes.