SECOND AMENDED AND RESTATED MANAGEMENT RETENTION AGREEMENT (TIER 2)