GDOT Sr SQL Server Database Administrator

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.

Local Candidates Only.

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

Qualifications :

Bachelors 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

Required / Desired Skills

Skill

Required / Desired

Amount

of Experience

Hands on administrative experience with SQL Server RDBMS

Required

Years

Hands on experience in managing backup recovery and high availability scenarios

Required

Years

Hands on development and tuning of databases in SQL Server with Performance Tuning.

Required

Years

Hands on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL programming.

Required

Years

Hands on query experience with SQL and scripting skills

Required

Years

Strong knowledge and experience on Always ON High Availability groups

Required

Years

Required 4 Years Strong Knowledge and Experience on Migrations

Required

Years

Required 4 Years SQL Server database space management / storage design and capacity planning according to best practices

Required

Years

Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management

Required

Years

Demonstrate ability to generate entity relationship diagrams create database documentation data dictionaries and document system architecture.

Required

Years

Questions

No.

Question

Question1

Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement

Question2

Please list candidates email address that will be used when submitting E-RTR.

Question3

Candidate must be paid at least $60.64 if selected for this engagement. Your candidate can be paid more; however the hourly SRP Rate cannot exceed $81.86. Do you accept this requirement

Question4

The maximum mark-up for this engagements SRP rate is 35%. To be competitive on pricing a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35%

Question5

While the intent may be a long-term tenure this position is subject to annual budget restrictions. The initial contract is through the end of this fiscal year and is anticipated to be renewed July 1st. Do you accept this requirement

Question6

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.

Question7

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

Question8

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

Question9

This position is Hybrid (Remote and Onsite). The candidate first day is onsite and onsite on demand basis. Preference will be given to candidates local to Atlanta Metro area / State of Georgia. Indicate if candidate has full time residency within the Atlanta Metro area within the State of Georgia or if the candidate resides outside of the State Of Georgia. Do you accept this requirement

Question10

GDOT will not be providing any raises within the first 2 years. After that point the rate increase will be based on performance and budget dependent.

Question11

Preference will be given for candidates who are US Citizens Permanent Residence Card (aka Green Card) or have Employment Authorization Document (EAD). Indicate if candidate citizenship or visa status is a US Citizen Permanent Residence card EAD H1B or other.. Do you accept this requirement

Question12

This Position is in Atlanta GA Your consultant is required to travel to Atlanta for their first day for onboarding. Travel will be at no expense to GDOT in order to obtain your candidates computing equipment and ID / Security badge. Do you accept this requirement

Key Skills

Anti Money Laundering,Consultancy,Administration Support,Fire Alarm,Document Management,AV

Employment Type : Full Time

Experience : years

Vacancy : 1