My name is Mateusz Zdrenka. I am 34 years old, and I live in Szczecin, Poland. I have a master's degree in Computer Science and Econometrics. Above that, I also have a postgraduate degree in Data Science.
I have very rich experience with database administration and database programming. For more than 7 years I have been working as a SQL Developer / Database Administration for various companies.
The most experience I have is with a PostgreSQL database. I worked as a PostgreSQL Database Administrator /SQL Developer for about 6 years in the company which provides iGaming industry solutions.
I was responsible of more than 100 PostgreSQL clusters. Including production, test and RC environments. Most databases were several hundred GB and the largest reached 1.5TB. My daily duties included:
- Installation and configuration of new PostgreSQL clusters.
- Creation of database replication - streaming and logical.
- Routinely checking that all databases are working properly. Including the fallowing: keeping an eye on monitoring (Zabbix plus our internal solution), responding to alerts, maitanace of monitoring (adding new things to monitoring and improving current ones), routinely checking of databases logs, catching and optimizing slow queries.
- Maintenance of existing PostgreSQL clusters. Including the fallowing: changing the databases' configurations, creating new databases' replications.
- Maintenance of existing PostgreSQL databases. Including the fallowing: maintenance of database indexes, tables, views, functions, procedures and triggers.
- Creation of new databases objects such as: tables, views, procedures, functions, indexes and triggers.
- Creating new and maintenance existing reports.
Above that, I have a lot of experience as a SQL Developer with BigQuery and Snowflake databases.
I also know Databricks and DBT - I was creating repots for the USA iGaming market regulators using these tools.
My strengths are analytical thinking, good work organisation, focus on solving problems, and personal development.
Professionally I am interested in Big Data and Data Science, so I think that will be the direction of my development.
My hobby is astronomy, ancient history and travel.
I hope you liked my profile, please do not hesitate to contact me.
Best regards.