- Database Management: Maintain on-premise and Azure SQL databases, including upgrades, high availability backup administration, monitoring, and optimization of DB servers and SQL/Procedures.
- Cloud Technologies: Work with Cloud Azure SQL Server, Data Lake, and related cloud data storage technologies.
- SQL Expertise: Demonstrate strong MS SQL knowledge, including the ability to interrogate data stores and schema, investigate results, and provide solutions to improve performance.
- Collaboration: Work with developers, support, and business teams to improve the use of SQL Server through better schemas and performant stored procedures, views, and functions.
- High Availability: Experience with Always-On and Basic Availability Groups.
- Backup and Restore: Knowledge of DB and transaction log backup and restore processes.
- Automation: Proficiency with PowerShell, including dbatools or SqlServer modules.
- Performance Optimisation: Ability to optimize SQL server performance.
- Maintenance: Experience with SQL Server Maintenance, including Agent Jobs and Monitoring.
- Configuration: Understanding of SQL server configuration.
- Advanced Features: Familiarity with partitioning, SQL snapshots, change data capture, and SAN arrays (Nimble preferred, PURE or others acceptable).