Nursing homes around here use social services personnel who are not licensed social workers but rather people who have some on-the-job training to do the social services assessments. It's a job that avoids the hands-on aspect.
I was a CNA and now a nurse but haven't been practicing for a couple of years. I don't do puke either. (I learned to do poop.)