Can you become a maid or butler on sims 3 late night?

No. The maid, babysitter etc are always NPCs. This is because they travel to several different homes and every sim must stay at city hall, the bookstore, the restaurant etc. if they work there.