Bristol Rovers have announced the permanent signing of Steve Mildenhall on a two-year deal after a successful loan spell with the club.