There is no social security in the UAE, but as a holder of a residence visa you automatically have access to the UAE public health system.
Usually foreigners subscribe to a private insurance. We work for our clients with AXA Middle East which offers quality international health coverage.