Applied to several jobs that looked interesting over many months.

Received a call back and phone interview for one, but no request for an on-site interview.

Finally, one of my friends got hired. With his recommendation, I was contacted about a Lead Developer position.

Did the phone interview, followed up with an on-site, then an offer.

On the phone and on-site, the interviewer asked several situational problem-solving questions, eliciting responses with examples from my own work experience. However, on-site, they also gave me a coding test with requirements for small programs and four SQL statements. The requirements were simple, but more academic than real-world. (I have never been paid to write a Fibonacci code generator or a palindrome detector.) Anyone who has been out of college for 20+ years would require at least 10 minutes per question just to dust off the cobwebs, and the test had a 30-minute time limit.