I took an optimization test before the meeting on site, then was called in for an in-person interview.

I met with the hiring manager as well as another technical employee. Both were friendly people.

We proceeded to the interview room, where I was asked a range of technical and non-technical questions. The lines of questioning were fairly in-depth, which was expected. I even ended up learning a thing or two.

The interviewers were calm and passive in their style of question delivery (meant in a good way). I never felt I couldn't ask a question to further explain or understand the desired answer.

It was a tough interview, but a great experience overall.

Was asked a significant amount of SQL performance questions, including:

• Why certain indexes are used
• How to avoid unnecessary table scans
• Avoiding locks
• General optimization of provided queries

This resulted in around an hour of SQL questioning by the end.