Job ID: GA-790769 (98190114)
Hybrid/Local SQL Server DBA (12+) with RDBMS, TSQL, Migrations, security/setup/installations/upgrades/patches/backup/recovery/space management, Performance Tuning, MS SharePoint, Cohesity Backup Appliance, Cloud Technology and governance experience
Location: Atlanta, GA (GDOT – IT App)
Duration: 6 Months
Local Candidates Only.
Skills:
Hands on administrative experience with SQL Server RDBMS Required 6 Years
Hands on experience in managing backup, recovery and high availability scenarios Required 6 Years
Hands on development and tuning of databases in SQL Server with Performance Tuning. Required 6 Years
Hands on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL programming. Required 6 Years
Hands on query experience with SQL and scripting skills Required 6 Years
Strong knowledge and experience on Always ON High Availability groups Required 4 Years
Required 4 Years Strong Knowledge and Experience on Migrations Required 4 Years
Required 4 Years SQL Server database space management/storage design and capacity planning according to best practices Required 3 Years
Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management Required 4 Years
Demonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries and document system architecture. Required 3 Years
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
Job Summary:
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.
Job Responsibilities:
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 recommends tuning and application changes
– Implement user authentication and validate databases security protocols across systems
– Reviews system design and develop new database systems as needed
– Modifying database structure or deploying 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.
Qualifications:
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