The candidate requirements are aligned more closely with MS SQL Database Engineer and DBA job descriptions:
- Advanced SQL query development
- Complex joins and subqueries
- Common Table Expressions
- Window functions
- Stored procedures and functions
- Views and triggers
- Query performance tuning
- Execution plan analysis
- Index optimization
- Table compression, data files, and file groups
- SQL Agent job management
- Database monitoring and troubleshooting
- Memory and server optimization
- Backup and restore support
- Data validation and reconciliation
- Data warehouse development
- Fact and dimension modeling
- Data quality monitoring
- Exception handling and root cause analysis
- Production support and incident resolution
- QA / DEV / PROD environment support
- Reporting investigation support
- Data modeling documentation
- Erwin data modeling tool experience
- Documentation and technical writing
- Problem-solving and analytical thinking
- Monitoring and operational support
- Ability to work independently
- Time and priority management
