Surgeons are generally trained with a grueling multi-year academic and practical program about how to conduct surgery. DBAs aren't. If you're lucky you have someone who has been trained to be a DBA professionally - but I've never worked with one, all the SQL I've interacted with has been run by people with unrelated job titles who learned how to operate databases by Googling when necessary.
You're welcome to fire people if you think it's going to help. I'm just curious how you think a skilled, trained DBA is going to show up at your desk when that happens.
Errors and mistakes happen, no question about that. And any ol' mistake certainly shouldn't be a firing offense.
But this behaviour is so grossly incompetent that I don't believe that it can't be helped with any training.