Should Adultery Permanently Disqualify Pastors?

In recent times, the topic of disqualifying sins, particularly adultery, has become a pressing issue in church leadership. What does Scripture say about restoring a man who has fallen into such sin? Can he ever return to a position of leadership?