Most nurses do start out on nights. Rotating shifts are not a think in my area so I can't speak to that. You may have to look harder to find a job with your msw but if your willing to move you should be ok. Social work is a great career. My best friend has an msw and works for a hospital system they are required to have one. Try applying at nonprofit like domestic violence counseling centers, pregnancy resource centers, and adoption agencies.