It's a beautiful and haunting melody, often played during scenes featuring the characters' emotional struggles and the film's powerful themes of war, friendship, and loss.
The song itself is actually a movement from Myers' larger composition, "The Deer Hunter Suite".
However, it's so iconic and widely recognized that it's commonly referred to as "The Deer Hunter theme" or just "Cavatina".