CiviMember Role Sync not Syncing One User
See if there's a deleted contact with the same deets?.

Also petendz's advice is stellar as ever. Use the api explorer do get uf match on that email if for whatever reason you can't access the MySQL table.