It's entirely voluntary. We don't really choose moderators; for the most part individuals stand up and say they'd like to be in charge of a part of the database, and we make it happen!
Case in point, just last week
@MikeD took over moderating the Tomatoes database. He and I were chatting about the database and he expressed an interest so I made the offer and that was that!