Personally, I do not see there is any special reason to create a regular SP in master database. But we know that an extended SP should be created (registered) in master...
I'd like to read more articles about your feeling and experience regarding switching from a development position to a management role. As a DBA, I find there are more demands...