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.