Sr SQL Server Database Administrator (Only local to Atlanta, GA Consultants)

Job Title:Sr SQL Server Database Administrator (Only local to Atlanta GA Consultants)

Location: Atlanta GA

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.

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

Hands on administrative experience with SQL Server RDBMSHands on experience in managing backuprecovery and high availability scenariosHands on development and tuning of databases in SQL Server with Performance on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL on query experience with SQL and scripting skillsStrong knowledge and experience on Always ON High Availability groupsRequired4YearsStrong Knowledge and Experience on MigrationsRequired4YearsSQL 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 diagramscreate database documentationdata dictionaries and document system architecture.