This sound effect can be found on the Otojiten VOL 5. - RPG & Horror/Game Sound Effects Library which is from Datacraft.
https://soundeffects.fandom.com/wiki/File:Datacraft,_ME_(RPG)_-_Dramatic.mp3