if he will go home in his country, you can bring him in doha anytime his visa will be released under your sponsorship - on a family visa. regarding if he can get a work while under your sponsorship, yes, if there is a company that will hire him right away. if he is already on a family visa under you and he was able to get NOC from the past company, he can work immediately in case he will be hired. he is not affected by the 2 yrs ban. 2 yrs ban is only for those who resigns without NOC. if his old visa will be shifted to u as a family visa while still here, he doesn't need to go back to his country. but, try and dont forget to inquire and get some information from MOI re. this. cheers...