There were three interviews: a preliminary phone interview, an in-person interview with the director of development and the team lead, and a third very technical interview where they really push you to your limits. This was one of the most challenging, yet most rewarding interview processes I have gone through. I even learned a couple things. (There was also a code challenge that I did because I originally applied for another position, but was bumped over to database when they saw a good fit there.)
Interview questions [1]
Question 1
The third interview saw me answering a series of very technical database questions by writing queries off the top of my head with minimal knowledge of the database schema. The interview was designed to vete out those who really know their stuff vs. those who just carry a title for show. The wrong candidate would get frustrated with this process, and might even give up, as these were some very challenging questions that verged on some very advanced database development topics.