Whilst accommodation is a highly subjective topic but based on what you said, I would say that somewhere close to Sheikh Zayed Road would probably be your best bet. There are a few apartment blocks dotted around that spring to mind such as Grosvenor Commercial Tower, Tecom or Millenium (not sure if we still use it?). Whilst all the apartments will generally be pleasant enough, the standard of facilities (gym/pool) and overall maintenance and exposure to ambient noise can vary widely, based on information from colleagues.
Give careful consideration to the fact that after joining now, you are locked into company accommodation unless you wish to buy in Dubai. The accommodation apartment is shall we say, one of the less helpful departments in the company. Therefore if you don't wish to buy and don't like where you end up being placed, then it can be an uphill struggle getting moved to somewhere more to your liking.