Devon Young sends this story about Sean Kazmar of the Braves, who went over a decade between major league appearances. He last played for the Padres in 2008:

The gap between big-league appearances was the greatest since that of right-hander Ralph Winegarner, according to Elias Sports Bureau. Winegarner played on June 23, 1936, for the Cleveland Indians and did not return to the majors until July 7, 1949, with the St. Louis Browns- a span of 13 years, 14 days.

ESPN.com

His return was not auspicious as he pinch hit and grounded into a double play. His major league record is rather poor, with fourteen strikeouts in 47 plate appearances.

His minor league record is not all that wonderful either. in over 4000 AAA games, his batting line stands at .263/.311/.369. His manager for many of those years was Brian Snitker, however, who appreciates toiling forever in the minors. This was Snitker’s gift to Kazmar.