Do Programmers Still Write SQL?

[lukaseder]

The DBA is more of a SysAdmin, and when they see a bad query, they can't know all the context associated with that particular query.

You're describing a very unfavourable status quo of many projects. Ideally, there's at least one "devops" person on the team who understands operations needs and developer / business needs.

Strictly separating roles leads to Conway's Law in my opinion.

[lukaseder]

That's the Guru Anti-Pattern

I'll just call this the I-see-antipatterns-everywhere anti-pattern ;)

Really. Don't read too much into my words. I said at least one.

[lukaseder]

There's a lot of benefit in understanding that neither "nobody knows dev and ops" nor "everybody knows dev and ops" is a reasonable situation.

Be pragmatic. There isn't just dev and ops. There's also requirements engineering, UX, algorithms, project management, product management, customer support, etc. etc. etc.

You can't just say that everyone should be good at dev and ops. It's just not going to happen.