Two phone interviews, one onsite. These people need DBAs rather than application-side developers.

1. Coding: Implement stack from scratch.

2nd round: Optimistic locking.

How two threads on different servers communicate.

Onsite: Two VPs interviewed me, asking me to increase the performance of their system, mainly on the database side.

These VPs were DBAs instead of MBAs with some little knowledge of databases.

A 3rd HR person came and said, "The VPs didn't like you."

Lol, I was like, "Is this about my knowledge or my face?"

Feels like I wasted a day going onsite.

We got many database records; it took 36 hours to process. How will you reduce process time?