> what organisation in all seriousness gives a junior developer the access rights to drop a production database

It is pretty normal. Someone with university education, should know how to use a SQL client! I personally would fire such person as well. Carelessly copy&paste and execute code from some website is a huge redflag! Getting rid of such person on their trial period is very cheap....

Also many services are not mission critical. DB drop could mean short downtime, and restoration from backup (or Kafka stream), and with little loss revenue.