Description

You will manage and optimize MS SQL environments to ensure high availability and performance.

Responsibilities

• Maintain database maintenance plans including backups, index rebuilds, defragmentation, and statistics.
• Troubleshoot and resolve integrity, performance, blocking, and deadlock issues.
• Implement Query Store, table partitioning, and Always On encryption.
• Manage SQL Server installations, upgrades, migrations, and configuration.
• Administer database security access and high availability strategies including clustering, log shipping, mirroring, and replication.
• Monitor MSSQL database alerts and participate in 24x7 on-call support.

Required Skills

• 6 years of experience as a Database Administrator in a SQL Server environment.
• 6 years of experience with Transact-SQL, SSRS, and SSIS package development.
• 4 years of SQL Server database development and programming.
• Experience administering SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017, and 2019.
• Proficiency in performance tuning and resolving CPU, memory, and disk I/O bottlenecks.
• Experience with Windows Server, Active Directory, and disk configurations.
• Ability to use monitoring and diagnostic tools.
• Bachelor's or Master's degree or equivalent combination of education and experience.

Key Skills

Education

Bachelor's or Master's degrees