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

For further information, see Skills_SQL_Server_TSQL

Window functions

Group by/aggregation

WHERE clause / Having

Use of SQL Server CTEs (Common Table Expressions).

Sort by

Subqueries

Views

Joins

SQL Server development

For further information, see Skills_SQL_Server_Development

Database design

Medallion architecture

SSIS with parameters.

BIML (SSIS Visual Studio extension)...

Business Intelligence

For further information, see Skills_Business_Intelligence

Slowly Changing Dimensions

SQL Server DBA - Database Administration

For further information, see Skills_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

For further information, see Skills_Spark_SQL

Spark sql

Databricks

data migration

Python

Other technical

For further information, see Skills_Other_Technical

Powershell

Apache Subversion - MUFG

Control-M

Redgate tools

Non-technical

For further information, see Skills_Non_Technical

Documentation

User training

Teamwork/Mentoring