Skills Overview: Difference between revisions
Created page with "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 developme..." |
|||
| Line 23: | Line 23: | ||
Medallion architecture | Medallion architecture | ||
SSIS with parameters. BIML | SSIS with parameters. | ||
BIML (SSIS Visual Studio extension) --MUFG | |||
== SQL Server DBA - Database Administration == | == SQL Server DBA - Database Administration == | ||
| Line 49: | Line 51: | ||
== Other technical == | == Other technical == | ||
Powershell | Powershell | ||
Apache Subversion - MUFG | |||
== Non-technical == | == Non-technical == | ||
Revision as of 09:25, 30 September 2024
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
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