Add a post-deploy migration guideline

What does this MR do?

Add a guideline that describes what is the post-deploy migration pipeline, how to execute it and troubleshoot it.

This change is part of the work to move post-deployment migrations off the auto-deploy pipeline - gitlab-com/gl-infra&585 (closed)