Sr SQL Server Database Administrator

Job: GDOT - Sr SQL Server Database Administrator (790769)

Location : 600 WEST PEACHTREE ST.NW,ATLANTA,GEORGIA 30308

Client : state of GA

Duration: Long Term

100% DBA is preferred. (They rise to the top of the list) 2nd option: 60% developer, 40% DBA. Architects and Project Leads will not be considered.

Technical interviews will be thorough and scenario based. (Ex. downtimes, outages, back-ups, etc.). Examples will be asked for from past work experience. Do you accept this requirement?

The selected candidate will be expected to start their engagement no later than 2 weeks (10 business days) from the client's selection date. Do you accept this requirement?

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

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