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

SQL Server

SQL Server Management Studio (SSMS)

Database design

Medallion architecture

SSIS with parameters.

BIML (SSIS Visual Studio extension)...

OSQL command line application

Business Intelligence

For further information, see Skills_Business_Intelligence

Slowly Changing Dimensions

Visual Studio

SSRS - SQL Server Reporting Services

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

Configuration tables

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

Streamsets

Azure

Azure blob storage

Other technical

For further information, see Skills_Other_Technical

Powershell

Apache Subversion - MUFG

Control-M

Redgate tools

XML

TeamCity

UTF-8

FTP

Network drives

CRLF

Notepad++

Excel

Non-technical

For further information, see Skills_Non_Technical

Documentation

User training

Teamwork/Mentoring

Recruitment

Change Control