Skill | Required / Desired | Years of Experience | Candidate Has (Y / N) | Candidate Years of Experience |
MS SQL Server DBA experience | Required | 7 | | |
Proven experience upgrading SQL Server 2017 to 2022 on virtualized infrastructure | Required | 3 | | |
Experiencing upgrading SQL server 2017 to 2022 | Required | 2 | | |
Experience maintaining and setup of High Availability and Clustering | Required | 5 | | |
Hyper-V or VMware virtualization knowledge | Required | 2 | | |
Proficient writing T-SQL and PowerShell scripts | Required | 7 | | |
Windows Server 2022 experience | Required | 2 | | |
Experience with setup and maintenance of SQL server components such as SSRS, SSIS and Analysis Services | Required | 7 | | |
Strong problem-solving and communication skills | Required | 7 | | |
Microsoft DBA Certification | Required | 5 | | |
VM backup/snapshot strategy experience | Highly desired | 4 | | |
Experience with Hybrid disaster recovery strategies | Highly desired | 4 | | |
Active directory Knowledge - Cluster Name Objects(CNO) in HA setups | Highly desired | 5 | | |
Familiarity and experience with Microsoft SQL Server licensing options/strategies | Highly desired | 2 | | |
Familiarity with VM backup and snapshot strategies | Highly desired | 2 | | |
Monitoring Tools such as Redgate, Solar Winds or Sentry One | Desired | 3 | | |
DNS configuration for SQL listeners and CNO's in HA setup | Nice to have | 3 | | |
Delegation of rights to service accounts for dynamic object creation within specific OUs | Nice to have | 2 | | |