My name is Michal Roesler and I'm former data anlyst, MS Excel expert and MS SQL Server and PostgreSQL eager student.
I've been working with Excel for many years in different companies.
Some of them where big corporations, where I was doing what I was told to do.
Other where smaller, 10 employees companies, where I was responsible for almost all
IT duties/actions and where I've managed to introduce some time
saving automation patterns.
I'm intermediately skilled VBA programmer.
I've written around 25 VBA macros, that have improved or totally automated big
chunks of work, for the teams I was part of.
Some of these macros are available here,
on my GitHub profile.
After more than ten years experience in handling data using MS Excel,
I've decided 2 broaden my skillset with
MS SQL Server database knowledge.
I've been studying that for some time now and I have basic/average
knowledge using SELECT statement and some
rudimentary skills in designing databse structure.
Learning database optimization techniques is still ahead of me
but I plan to aquire this skills in the near future.
Currently I know how to host my own website using the virtual private server
and manage it on my own.
In addition to these skills I'm also learning HTML/CSS coding.
What you see is the outcome of this efforts.
One of the best and most comprehensive sources I've found is this project called
Mozilla Developer Network,
that provides thorough tag descriptions and complete
Web platform technologies tutorials.
Here is a short list of the tasks I'm capable of performing as a Linux System Administrator:
- disk partition tables thorough understanding, disk partitioning + file systems creation experience;
- fdisk and gdisk programs proficiency;
- I know both apt and dnf/rpm package mangers;
- feel comfortable with both Debian and RedHat Enterprise based distributions;
- basic users / group administration + file permissions, useradd, groups, chmod, chown;
- ssh knowledge and troubleshooting; ssh -v servername, I know how 2 use ssh config file;
- I can read and I understand ssh -v output and I can fix it;
- intermediate VIM knowledge; can edit 2 files at once :-)
- I wrote this site in VIM, but I'm still learning to move faster;
- know basic Apache2 web server config and Virtual Hosts config;
- I'll be glad to learn NGINX if needed;
- basic TCP/IP knowledge and conguration skills / basic regular expressions;
- thorough sql database understanding + designing + insert/select statements;
- can install MS SQL SERVER and PostgreSQL engine;
- basic firewall configuration skills on both ufw and firewalld;
- I have advanced problem solving abilities and I'm quite meticulous person;
- I can read documentation and there are days I even enjoy doing it;
My relational database design / creation skills honest description: SQL Server, PostgreSQL
Second area of my interest and a skill complementary to the linux
administration tasks is my relational database knowledge.
To be completely honest with you it's quite uneven and not very structured,
but it's there.
There are moments when I sit with PostgreSQL and create some cool databese,
like this "movies/actors/directors" database I've made some time ago.
But after this, when some new task grabs my attention,
I'm just moving all my time and energy to this new issue I'm facing,
therefore my databse is newer that big or extensive as I've imagined it.
Probably I should build a pyton crawler to gather this info/data automatically, but I'm just not good enough pyton programmer to do so.
Here's a list of what I can do within MS SQL Server or PostgreSQL relational database management systems.
- MS SQL Server and PostgreSQL intermediate skills;
- Good INSERT and SELECT statements command;
- I know how to define a table, set private / foreign keys in that table and define relationships between the tables;
- Joining tables, grouping and sorting the records;
- Basic T-SQL skills, I know stored procedures and triggers;
- Strong analytical skills; good numerical skills;
- The difference between the first list being the orderd list
and the second one being unordered list, results from the educational necessity
not some other esthetical or semantic order.
