Job ID : 790769
Position : SQL Server Database Administrator
Client : GDOT
Location : 600 West Peachtree 30308
Duration : 6 Months
- 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.
- 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.
- 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 MicrosoftSharePoint farm Install upgrade configure ALWAYS ON test and deploy complex database softwareDevelop and implement database recovery plans and proceduresAnalyze the performance of databases and recommends tuning and application changesImplement user authentication and validate databases security protocols across systemsReviews system design and develop new database systems as neededModifying database structure or deploying schema changes as a result of new requirementsScripting batch data loads and operational job automationWorking Knowledge of Cohesity Backup Appliance.Working Knowledge of Cloud Technology and governanceQualifications :
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 fieldRequired skills :
Hands on administrative experience with SQL Server RDBMSHands on experience in managing backup recovery and high availability scenariosHands on development and tuning of databases in SQL Server with Performance Tuning.Hands on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL programmingHands on query experience with SQL and scripting skillsStrong knowledge and experience on Always ON High Availability groupsRequired 4 Years Strong Knowledge and Experience on MigrationsRequired 4 Years SQL Server database space management / storage design and capacity planning according to best practicesDemonstrate ability to effectively communicate verbally and in writing with all levels of staff and managementDemonstrate ability to generate entity relationship diagrams create database documentation data dictionaries and document system architecture.Key Skills
Anti Money Laundering,Consultancy,Administration Support,Fire Alarm,Document Management,AV
Employment Type : Full Time
Experience : years
Vacancy : 1