Sr SQL Server Database Administrator

Sr SQL Server Database AdministratorLocation: Atlanta, GADuration: Long TermJob 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 tuneSupport SQL Server databases in Production, Test and Development environments and within Microsoft SharePoint farmInstall, 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 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 fieldSkill - Required / Desired - Amount - Actual ExperienceHands on administrative experience with SQL Server RDBMS - Required - 6 - YearsHands on experience in managing backup, recovery and high availability scenarios - Required - 6 - YearsHands on development and tuning of databases in SQL Server with Performance Tuning. - Required - 6 - YearsHands on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL programming. - Required - 6 - YearsHands on query experience with SQL and scripting skills - Required - 6 - YearsStrong knowledge and experience on Always ON High Availability groups - Required - 4 - YearsRequired 4 Years Strong Knowledge and Experience on Migrations - Required - 4 - YearsRequired 4 Years SQL Server database space management/storage design and capacity planning according to best practices - Required - 3 - YearsDemonstrate ability to effectively communicate verbally and in writing with all levels of staff and management - Required - 4 - YearsDemonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries and document system architecture.