The Sales Director for Territory Accounts at Redgate Software is responsible for leading sales strategies and driving revenue growth by managing accounts in a specified territory. The role emphasizes collaboration with IT and development teams to promote software solutions while building relationships with customers and improving database management capabilities.