Technical Skillset
- Microsoft SQL Server – 2000 | 2005 | 2008 | 2008 R2 | 2012 | 2014 | 2016 | 2019 | 2022 – MCP
- Oracle – 8i | 9i | 10g – OCP
- System Architecture – Physical | Virtual (VMware)
- Storage Architecture – Local | SAN | SSD | Flash
- High Availability – AlwaysOn AG | Failover Clustering | Mirroring | Replication | Log Shipping
- Database Design – OLTP | OLAP
- Performance Tuning – Index Strategy | Query Plans | Query Optimization
- Cloud – Microsoft Azure | Amazon AWS
- Data Migration – Consolidation | Upgrade
- Scripting – TSQL | PowerShell
- 3rd Party Tools – Monitoring (SentryOne | Idera SQL Diagnostic Manager | Dell Spotlight | Confio Ignite), Backup (Red Gate Backup | Dell Litespeed), Ticketing (ServiceNow)
- Community Tools – sp_WhoIsActive | Ola Hallengren Maintenance Solution | Brent Ozar Tools | dbatools
