NO, GO SOBER.
Ideally, you should be completely sober for at least two days before your tattoo. At least that's what I've heard everywhere.
It'll hurt more if it's somewhere bony, like on your ankle or something, as opposed to like your ass cheek.