Sr SQL Server Database Administrator - Hybrid Atlanta, GA
About The Position
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
- Hands on administrative experience with SQL Server RDBMS
- Hands on experience in managing backup, recovery and high availability scenarios
- Hands on development and tuning of databases in SQL Server with Performance Tuning.
- Hands on experience in Microsoft Operating Systems and SQL Server clustered environments required. and Optimization and TSQL programming.
- Hands on query experience with SQL and scripting skills
- Strong knowledge and experience on Always ON High Availability groups
- Required 4 Years Strong Knowledge and Experience on Migrations
- Required 4 Years SQL Server database space management/storage design and capacity planning according to best practices
- Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management
- Demonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries and document system architecture.
Nice To Haves
- Working Knowledge of Cohesity Backup Appliance.
- Working Knowledge of Cloud Technology and governance.
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
11-50 employees
