The company I work at is considering moving some/all of the “not business differentiating” work (aka boring or terrible yet still critical work) to teams in India. I agree with roughly colocating teams (by time zone. Working 12 hours apart from half your team isn’t practical). I disagree with the Indian teams taking all the bad/boring work.
We have both MySQL and PostgreSQL in our production environment. Postgres is way nicer as a user of the DB. I created a document months ago outlining a dozen different things that Postgres does that MySQL either doesn’t do or does worse. I can’t speak to managing the DB as I don’t have experience with that.