Task Description:
- Creation of database tables & structures, creating views, functions and stored procedures
- Automating migration steps for multiple M365 related migration projects
- Auditing of existing scripts to make them more optimized and improved
- Tracking of historical data
- Creating database triggers for use in automation / PowerBI & Power Apps
Assignment Description:
- SQL & PowerShell scripting related activities for Digital Workspace Program.
Scope not limited to:
- Creation of database tables & structures, creating views, functions and stored procedures
- Automating migration steps for multiple M365 related migration projects
- Auditing of existing scripts to make them more optimized and improved
- Tracking of historical data
- Creating database triggers for use in automation / PowerBI & Power Apps
Required Skills and Experience:
- Fundamental knowledge of SQL server (link the tables, optimize indexes, use of data flows, ..)
- Knowledge of data collection methods (integration services, PowerShell scripting)
- Thorough understanding of Active Directory
- Fundamental knowledge of Exchange server & Office 365 (M365)
- Knowledge of Power BI & Power Apps
- Preferred: Fundamental knowledge of C-sharp
- Experience with data warehousing & historical data tracking
- Hands-on experience automating processes through scripting using PowerShell
- Able to work effectively under deadlines in a fast-paced, changing environment
- Strong analytical, troubleshooting and problem-solving skills
- Experience in usage of Microsoft ExchangeOnline, SharepointOnline and Teams Powershell module as well as MS Graph API
- Experience in using and creating REST API will be an added advantage
