Technical Consultant

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