Sr SQL Server Database Administrator

Hello,Hope you are doing well,Job: GDOT - Sr SQL Server Database Administrator (790769)Location : 600 WEST PEACHTREE ST.NW,ATLANTA,GEORGIA 30308Client : state of GADuration: Long Term100% 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 TransportationJob 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 MicrosoftSharePoint 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 fieldHands on administrative experience with SQL Server RDBMSRequired6YearsHands on experience in managing backup, recovery and high availability scenariosRequired6YearsHands on development and tuning of databases in SQL Server with Performance Tuning.Required6YearsHands on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL programming.Required6YearsHands on query experience with SQL and scripting skillsRequired6YearsStrong knowledge and experience on Always ON High Availability groupsRequired4YearsRequired 4 Years Strong Knowledge and Experience on MigrationsRequired4YearsRequired 4 Years SQL Server database space management/storage design and capacity planning according to best practicesRequired3YearsDemonstrate ability to effectively communicate verbally and in writing with all levels of staff and managementRequired4YearsDemonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries and document system architecture.Required3YearsThanks & Regards.An E-Verify CompanyDISCLAIMER: The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, re-transmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer or if you want to be REMOVED please reply with REMOVE in the Subject line of this email.