Hmm... what theme are you using? Near the bottom of your template.tpl, is there another link to jQuery? You only need it once in your site, but it must before any other scripts you use. Because we're calling it the header.tpl, we can safely remove it from the end of template.tpl.
And while this shouldn't be relevant, in the header.tpl, that last script tag? Could you add type="text/javascript" to it? Not having it there is HTML5 acceptable, but your page is using a very strict (and very outdated) XHTML as a guideline instead (judging by the top two lines), so it may break it.
So um, those last four lines, try replacing them with this:
Code:
<script type="text/javascript">
$(function() { $("#profile").organicTabs(); });
</script>
</head>
(I'd also like you to get your pages HTML5 ready, so, I'd recommend you change the first two lines to simply:)
Code:
<!DOCTYPE html>
<html>
Err, you can read more about
doctype stuff here. It may not actually be the issue, but it helps me rule stuff out.