The original SG-1 did that already. Carter was the team leader for season 8 while O'Neill was base commander.

And Atlantis had a civilian woman in charge from the pilot episode.