DOMS will decrease as you get used to a particular exercise and to a particular loading scheme. You can still have very intense soreness even as a more experienced lifter if you try something totally new or try a very intense loading scheme that you're not used to, etc. But, generally, just getting used to the exercises means you'll have less intense soreness. Also, the more you practice the movement (e.g., you squat once, twice, or three times a week) the less you'll experience DOMS.
Just to head this perception off at the pass -- Doms does not equal growth stimulus in a significant way. So don't judge the quality of your workout by whether or not you're sore the next day or so.