Skills Overview

Over the course of my IT career, I have gained considerable experience with a broad range of IT skills. This page lists an overview of these, with links to other pages where individual skills are described in greater details, along with the roles where I have used these.

SQL Server TSQL coding

Window functions

Group by/aggregation

WHERE clause / Having

Use of SQL Server CTEs (Common Table Expressions).

Sort by

Subqueries

Views

Joins

SQL Server development

Database design

Medallion architecture

SSIS with parameters.

BIML (SSIS Visual Studio extension)...

  Link to MUFG
  Link to other

SQL Server DBA - Database Administration

SQL Server performance tuning/indexing/statistics

Security/user accounts

Logging

backups and restores

SQL Server version upgrades & downgrades

Out of hours support

Spark SQL

Spark sql

Databricks

data migration

Python

Other technical

Powershell

Apache Subversion - MUFG

Non-technical

Documentation

User training

Teamwork/Mentoring