It seems Samsung has removed this option for the included Contacts app (Googles app also does not support this, BTW) . However, you're not without options! Some (many?) messaging apps allow you to set notification sounds on a per-thread basis so once you have a conversation going with someone you can set that thread's sound and you're all set.
This has been a popular topic in here recently, we've had several threads on this (and the badges, BTW).
If you need additional help or have more questions or details to share, please join the site so you can reply in this thread. See this link for instructions on how to join Android Central.