Urgent :: Sr. SQL Server DBA || Face To Face Interview in Atlanta, GA

Sr. SQL Server DBA

Client: State of GA

Location: Atlanta, GA ****Local Candidates Only****

Interview: In Person Interview

Description:

Sr. SQL Server Database Administrator, who 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.

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.

Requirements:

• Bachelor's degree in computer science or a related field from an accredited college or university AND 7 years of experience in support of an operating system, database management system or a related field
• 6 years of hands-on administrative experience with SQL Server RDBMS required.
• 6 years of hands-on experience in managing backup, recovery and high availability scenarios required.
• 6 years of hands-on experience with development and tuning of databases in SQL Server with Performance Tuning required.
• 6 years of hands-on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL programming required.
• 6 years of hands-on query experience with SQL and scripting skills required.
• 4 years of strong knowledge and experience on Always ON High Availability groups required.
• 4 years of strong knowledge and experience on Migration required.
• 3 years of SQL Server database space management/storage design and capacity planning according to best practices required.
• 4 years of demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management required.
• 3 years of demonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries and document system architecture required.