Yes, O'Brien discusses putting in for a transfer. Since he's been promoted in his current role, changing position would result in him taking a diminished rank.
O'BRIEN: Look, I'm willing to ask for a transfer if that'll make you happy.
KEIKO: That's not fair either. You'd have to give up your promotion.
O'BRIEN: Not necessarily.
DS9: A Man Alone
Moving down the canon scale, it's discussed in one of the TNG novels that married Starfleet couples are often forced to turn down promotions in order to remain together.
Nor could they have chosen a better time for it. In the past,
Starfleet marriages were risky endeavors, often doomed in the attempt
to balance two careers, forcing choices between refused promotions or
long separations. Either way, domestic pressures added to an already
stressful lifestyle resulted in an unconscionably high rate of broken
Star Trek TNG: Survivors