Sr SQL Server Database Administrator

Sr SQL Server Database Administrator

Location:

Atlanta, GA (hybrid)

Duration: 04+ Months

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. Local Candidates Only.

• 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 recommend tuning and application changes
• Implement user authentication and validate database 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.

• Bachelor's degree in computer science or a related field from an accredited college or university
• Seven years of experience in support of an operating system, database management system, or a related field

• Hands-on administrative experience with SQL Server RDBMS – 6 Years
• Hands-on experience in managing backup, recovery and high availability scenarios – 6 Years
• Hands-on development and tuning of databases in SQL Server with Performance Tuning – 6 Years
• Hands-on experience in Microsoft Operating Systems and SQL Server clustered environments (Optimization and TSQL programming) – 6 Years
• Hands-on query experience with SQL and scripting skills – 6 Years
• Strong knowledge and experience on Always ON High Availability groups – 4 Years
• Strong Knowledge and Experience on Migrations – 4 Years
• SQL Server database space management/storage design and capacity planning according to best practices – 3 Years
• Demonstrate ability to effectively communicate verbally and in writing with all levels of staff and management – 4 Years
• Demonstrate ability to generate entity relationship diagrams, create database documentation, data dictionaries and document system architecture – 3 Years