GDOT - Sr SQL Server Database Administrator

Short Description

Under limited supervision, coordinates, designs, and secures computer databases to store, track, and maintain a large volume of critical business information. Serves as highest advanced-level subject matter expert.

State Agency:
Georgia Dept. of Transportation

Under limited supervision, coordinates, designs, and secures computer databases to store, track, and maintain a large volume of critical business information. Serves as highest advanced-level subject matter expert, providing authoritative guidance for professional staff. May also serve in a lead role.

Local Candidates Only.

• Manage all aspects of physical database administration including schema management; security, setup, installations, upgrades, patches, backup and recovery, space management, performance tuning and capacity planning for SQL Server.
• Support application teams and their projects to enhance, troubleshoot and performance tune.
• Support SQL Server databases in Production, Test and Development environments and within Microsoft.
• SharePoint farm.
• Install, upgrade, configure ALWAYS ON, test and deploy complex database software.
• Develop and implement database recovery plans and procedures.
• Analyze the performance of databases and recommend tuning and application changes.
• Implement user authentication and validate database security protocols across systems.
• Review system design and develop new database systems as needed.
• Modify database structure or deploy schema changes as a result of new requirements.
• Scripting batch data loads and operational job automation.
• Working knowledge of Cohesity Backup Appliance.
• Working knowledge of Cloud Technology and governance.

Bachelor's degree in computer science or a related field from an accredited college or university AND Seven years of experience in support of an operating system, database management system or a related field.