I have a gigantic portion of my body covered by Scott Sylvia, and I can't recommend him and the crew at Black Heart enough. He is a legend in the game for good reason - a hell of a tattooer for 30+ years, fast as they come, and a great guy. Plus he started this website.
Idle Hand is a killer shop in SF as well.
Temple Tattoo is a bay area institution and worth looking into the guys there.
FTW in Oakland is a strong shop too.
A lot of the Spider Murphy's folks have moved and opened Shangri La. Both of those shops are pumping out killer work.
Long story short, there are plenty of places to look in SF/Oakland/Bay Area, and that's just traditional.