Rockridge is a "good neighborhood" in Oakland. There are others as well. I would highly recommend living in Oakland; I would weakly recommend against living in Oakland to work in SF - it's certainly possible but that's a crowded commute.