Atlas was a mythical god. In the myths, Atlas was punished for leading the Titans against the Olympians by being forced to hold the heavens on his shoulders.
Sarina Douglas thought that Miles O'Brien would be a fitting replacement for Atlas. She added he "would do it with a smile too". (DS9: "Chrysalis")