First off in the post-Colgan world of little-to-no tolerance for checkride busts, what the HELL were you doing exposing yourself to checkride risk for a SINGLE ENGINE ATP??? That rating has almost zero use in the real world, and believe me employers would far prefer a pilot with no busts over one who has a SE ATP. I take all that back if you actually have a job offer which requires that rating.

Is everybody paying attention? Don't go take checkrides for the fun of it until you have reached what you reasonably think is probably your career-destination job. Unless you are Chuck Himself Yeager (or the DPE is your mother's brother). Save the "collector ratings" for later in life.

With that off my chest, one bust should not be a significant problem with most employers. But it's one strike, and now you don't have the luxury of many (or any) more.

I would come up with a good lesson-learned when you explain this at interviews (other than brain fart...there's no cure for that). Maybe you stayed up too late studying for the oral and were tired...something that you can learn from and do differently next next time.