Right.

That's an understood part of the problem, and also why my "select" solution felt like such a hack. I did my best to mitigate it by adding the FirstName/LastName to the WHERE clause when selecting the ID I was looking for.

At that point, the only race condition problem would have been on someone inserting the same data multiple times during the (acknowledged) race condition period.