I am new to using double pointed needles, and I love them!!!
The only question that I have that I can’t seem to find the answer to anywhere is is there a way to avoid the noticable “seam” where the needles join?
Maybe I am do something wrong, but any help would be appreciated.
You just neede to pull especially hard on the very last stitch of each needle, in order to avoid that. Good luck!! 
Do you mean the gap with what looks like a ladder? Those ladders are common. Don’t stretch the stitches out too far apart and try to keep the needles close so the stitches don’t stretch out there. Always start with a knit stitch on the new needle if possible and pull it tight, but not so tight you stretch the yarn out.
When I use DPN I actually wrap my little finger over the joins I’m not knitting. It’s hard to explain, but it just happened naturally the way I hold them. I can try to get a picture.
Mostly it just takes practice to learn to use them so keep at it. 
There are a number of steps to take to help eliminate ladders. You can try a couple and decide what works best for you.
Every other round knit one or two extra stitch on the next needle - this will move “seam” around and around so the seam doesn’t hit at the same spot each time.
Pull the last stitch on the right needle a little tighter and then the next two stitches on the left needle a little tighter.
As you change needles, hold the old right needle close to the stitch on the left needle as you start knitting with the new needle.
You say that you are new to DPs, the ladder issue is common to just about all knitter when the first use DPs and even when you use 2 circular needle. It will get better.
Once you have ladders you can take an extra needle and spread the excess yarn over two or three stitches on each side of the ladder.
Another thought: What are you knitting? If it is something that is a little smaller than one of the standard circular needle (12, 16, 24 etc. inches) you might be able to use one circular needle. Using one circular needle means that there is no changing of needles and therefore not chance of ladders.
When I begin to knit off the next needle, I push the first stitch as close to the tip of the needle as I can without it falling off. I knit that first stitch and pull the yarn as tight as I can. This seems to help eliminate the ladders.
I’m with Chris! He gave the most comprehensive solution to the dpn problem of what I call “gaposis” between needle changes.
Try his ideas. They’ll, no doubt, help you. One little addition—you can also change needles a couple of stitches early to sort of balance off the number on each needle.
The only glitch may occur if you have to inc. or dec. in an even pattern. You might be a little confused on spacing so pay attention to the beginning of your rows.
Course, I don’t know if you want to listen to me. With dpn’s I cheat all the time. I have a terrible time with the first row or two. All that writhing and twisting of the beginning stitches gets me unglued. . . especially in a dark yarn plus some days when I wash my hands and then can’t do a thing with them.
I will compensate my ineptitude by knitting the first 2 rows (sometimes on a straight needle, sometimes dpns, sometimes circulars) without joining. After 2 rows I’ll join. Then, from a straight or circular needle I’ll divide my stitches, join and forge ahead. Only have 2 seam sts. to sew when done and all the other beginning sts. are much more in control. It works for me.
Any other cheaters out there have a better idea, I’m all ears.
Don’t give up. You’ll be able to do it.
Jean