For scripts, the free SP_Blitz scripts from Brent Ozar's group provide a wealth of information for a DBA:
https://www.brentozar.com/first-aid/

If you ever are working on helping a developer optimize queries, a powerful free tool is SentryOne Plan Explorer:
https://www.sentryone.com/plan-explorer

You probably want some kind of performance monitoring tool, so you can quickly and easily see which servers are having problems.  Of course there are many available for cost, and which one is best is a matter of opinion.