Hello Alice and welcome! I'm IV, and though I am woefully not up to snuff on my Stargate lore, this character sounds lovely. I also wholly support gruffy bartenders and OCs. As for me, I'm EST, mostly work from home these days which leaves lots of time for tagging, and am a general fan of most things Sci-Fi.
As for Characters, welly-well-well.
Commander Shepard over here, of Mass Effect fame (or is it infamy? I suppose it depends on the person?). She's mostly a Paragon of sorts, though she has zero qualms putting bullets in very bad people who do very bad things. 'Gray area' crimes she's a bit less like to come down on too hard, and she's actively trying to shelve her military thinking for the time being because what good is that gonna do her here? She's keeping her Biotics on the d/l for right now, and she's actively not letting herself drink because she will drink all the whiskey in existence if you let her right now. Reapers man, they're hell on a persons state of mind.
Personality wise, she flirts with everyone, though she rarely intends on it going anywhere. It's more of an ice breaker that she'll let ride if it seems like it's received well. In every game I've brought her into, she ends up starting a poker league and I have zero doubts she'll start one here (if the mods don't object). So Poker Night can be a real thing. Stealing from her won't earn any points and riling her up is not the best (nor easiest) thing in the world. She tends to be pretty cool headed in public. In private she's kind of a wreck, but that's not something the outside world gets a peek into for awhile.
On the other end of the spectrum we have Francis Barton over at arrowpocalypse. Francis is the AU kid of Clint Barton and Bobbi Morse, A.K.A. Avengers. He fancies himself the new Hawkeye and his life has kind of sucked. Dead parents. Dead Dog. Doesn't really do people, groups, or have any real idea of how to live in a world where things aren't done just to survive. He's very, very, bristley and aggressive, though not outwardly hostile unless given a reason or emotionally provoked (the latter is pretty easy).
Feel free to throw Vala at either of them for all the reasons though. I'm really excited to have you here and hope you enjoy the group!