Skills Overview: Difference between revisions
No edit summary |
|||
| Line 26: | Line 26: | ||
<div class=" | <div class="mw-collapsible collapsed" style="width:400px; overflow:auto;"> | ||
<div | <div >Lorem ipsum sample</div> | ||
<div class="mw-collapsible-content"> | <div class="mw-collapsible-content"> | ||
This text is collapsible. | This text is collapsible. | ||
</div></div> | </div></div> | ||
Revision as of 09:57, 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.
This text is collapsible.
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