Job Title:
Location: Atlanta, GA Hybrid - Interview In Person Only
Description:
Under limited supervision, coordinates, designs, and secures computer databases to store, track, and maintain a large volume of critical business information. Serves as the highest advanced-level subject matter expert.
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 the 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:
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 field.
Required/Desired Skills
Skill | Required /Desired | Amount | of Experience |
Hands-on administrative experience with SQL Server RDBMS | Required | 6 | Years |
Hands-on experience in managing backup, recovery, and high availability scenarios | Required | 6 | Years |
Hands-on development and tuning of databases in SQL Server with Performance Tuning. | Required | 6 | Years |
Hands-on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL programming. | Required | 6 | Years |
Hands-on query experience with SQL and scripting skills | Required | 6 | Years |
Strong knowledge and experience with Always ON High Availability groups | Required | 4 | Years |
Required 4 Years of Strong Knowledge and Experience in Migrations | Required | 4 | Years |
Required 4 years of SQL Server database space management/storage design and capacity planning according to best practices | Required | 3 | Years |
Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management | Required | 4 | Years |
Demonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries, and document system architecture. | Required | 3 | Years |