Yes, a man working in Qatar can sponsor his wife (family RP) after she has resigned from a job if he is eligible. She can get a job also but not on business visa or visit visa as she should have NOC for that.