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) --MUFG

BIML

MUFG
Allen
Smith

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