GDOT Sr SQL Server Database Administrator

Atlanta, GA - USA

Monthly Salary: Not Disclosed

Posted on: 7 hours ago

Vacancies: 1 Vacancy

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.

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
- 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:

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	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

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