SQL Server Database Administrator

$124,800 - $135,200/Yr

AgreeYa Solutions - Montgomery, AL

Full-time - Mid Level

Montgomery, AL

1,001-5,000 employees

Professional, Scientific, and Technical Services

About the position

The SQL Server Database Administrator will be responsible for managing and maintaining mission-critical transactional and Datawarehouse SQL servers. This role focuses on continuous improvement and technology strategy, ensuring optimal database performance and security. The DBA will also handle web administration for critical web servers, focusing on deployment, connectivity, and maintenance of web applications.

Responsibilities

• Handle database administration for mission-critical SQL servers.
• Manage and maintain all production and non-production databases.
• Perform backup and recovery on Database Management Systems.
• Configure database parameters and prototype designs against logical data models.
• Define data repository requirements and data dictionaries.
• Optimize database access and allocate resources for performance and cost efficiency.
• Handle web administration for mission-critical web servers.
• Troubleshoot production issues and assist in the development lifecycle.
• Manage capacity and strategy, operational standards, and procedures.
• Stabilize and optimize database performance, including tuning and monitoring.

Requirements

• 8+ years of experience as an MS SQL Server database administrator.
• Strong focus on SQL Server 2016, 2019, and 2022.
• 8+ years in SQL Server database performance tuning.
• Experience with indexing, execution plans, and database problem resolution.
• 8+ years writing scripts for monitoring, backup & recovery, and maintenance automation.
• Hands-on experience in on-prem to cloud migration.
• Experience in creating and troubleshooting SSIS packages.
• 5+ years of experience with MS Internet Information Services (IIS).

Nice-to-haves

• Power BI capacity Admin experience.
• Familiarity with Snowflake.
• Strong teamwork and interpersonal skills.

Benefits

• Dental insurance
• Health insurance
• Life insurance
• Paid time off