I had spent some time using all keywords and all search tools, but can't find the story.
Near the start of the story protagonist visits club where he sees drag show. At some point he is offered job as night watchman/guard at that club. Some time later he is persuaded to participate in the show. Then he designs a new show for the club.
I'm probably mixing stories but protagonist could have been piano player.
Save me please! :-)