Sure. There are sociologists who are also counselors, and some are therapists, and are doing a job that  is equal to what psychologists do. You might have to be trained as a social worker first, but it could be interesting, and your background in sociology could come in very handy.

Patrick Casement, who is a rather famous psychiatrist started out as a social worker, and is very highly acclaimed. He writes about his experience in his "Learning from the Patient" (which is a great read even if you're not in the trade).