The two closet airports are San Jose Mineta International Airport, and Oakland International Airport. We recommend staying in San Ramon, CA or somewhere near by. Below are suggestions, but please feel free to stay whatever is best for you.
Flight
San Jose Mineta International Airport
San Jose Mineta airport is about 40 minutes from San Ramon
Flight
Oakland International Airport
Oakland airport is the closet to San Ramon, about 30 minutes.