Where can I find alternative alert sounds for my iPhone 4S?
Your options are:


Purchase tones using iTunes (on Windows and Mac OS X)
Compose your own tone using Garagaband (Mac only) and export to iTunes (on
Windows and Mac OS X) for syncing with your iPhone. 
Create your own tone using Ringer (Mac only) available from Mac AppStore.