> In the past, an engineer who deeply understood the internals of a DB and how memory management worked in Java would be indispensable.

That engineer still is indispensable. Any organization foolish enough to replace such a person with an LLM is going to find itself in deep water when the pile of hallucinations becomes too much to endure.