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 Article 1
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.
Used in my contract at MUFG Securities 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