Oh hey. Here's a question. Does your house use a booster pump? You mentioned it was a multi-story dwelling.

http://inspectapedia.com/water/Booster_Pumps.htm

Maybe that's what's making the noise, and the pump or its pressure-detection circuit is faulty.