In the real world, my job is planning IT stuff and writting solution brief documents for engineers and project managers to work to. The place I work for is very well known in the sector they work in, quite large, and as such they pay relatively well for the work they have us chimps churn out.
I’m deliberately very closed about where I work on forums and in social media, but my experience is that if you’re making schema or database changes you make sure it’s going to work, ID a UAT group, and mess around with that before you go into production, buy a test server, migrate a pool, check all your plugins and functions, make sure changes don’t impact those who are service users, then ensure you can roll it all back should it go to shit.
Seems that’s not been the case.
Don’t envy whoevers shoulders sorting this mess out has fallen on.