Sashko Micov

- Sashko Micov - Senior Database Analyst Skopje, Macedonia Database Analyst/Developer with 9 years of experience. Possesses a combination of multiple technical skills, consulting ability, leadership, mentoring, and client support skills to improve client relations. Excellent Excel skills, SQL that include queries, stored procedures, and SSIS/SSRS, experience in analyzing and implementing new database requirements, performance optimization of databases, High availability and understanding of replication/mirroring, good with numbers, and capable of understanding new and complex data environments. WORK EXPERIENCE SKILLS Senior Database Developer Rideau inc Algorithms 03/2013 - 03/2020, Remote Achievements/Responsibility Migrated legacy infrastructure to more secure and modern. Source controlled all databases using database projects. Automated manual imports by introducing a new process with custom data dictionaries and generic stored procedures. Data Structures VMware VRO MariaDB Probability and Statistics MS SQL server Hive Hadoop SQL Databases Timescale db MYSQL Big Data Data warehouse Redshift PostgreSQL Participated in database design and architecture to support application development. Created complex functions, scripts, stored procedures, and triggers to support application development. Participated in DW design and architectural decisions, Worked on DW implementation in the Hadoop ecosystem. Increased revenue by providing data insights supported by regression models. Conceived and conducted ad hoc analyses in order to derive recommendations for operative measures. Supported stakeholders in preparing data-driven bases for decision-making. Senior Database Developer Upwork 04/2020 - Present, Remote Achievements/Tasks Worked on end to end application level performance tuning re designing data models ,choosing proper distribution keys re write legacy function code. Improve query performance by following performance enhancement tips and database best practices. Reverse engineered data models to improve queries Designed and implemented table partitioning for handling very large tables. PERSONAL PROJECTS DWH using snowflake for Logistic company (02/2021 - 07/2021) DWH design and implementation using snowflake and data vault Client : XX Germany Data lake for ML on procurement data (11/2020 - 02/2021) Designed and implemented data lake model for ML analysis on top of PostgreSQL cluster, designed and implement data pipelines that extract data from different data sources like SAP ERP, flat files etc. Performed data transformations using Python, spark and SQL, Created data aggregates and tableau dashboards for data visualization. Client: XX Germany Cost management platform for aws cost report (10/2020 - 11/2020) Designed and implemented database model using timescaledb on top of PostgreSQL cluster, implemented data pipelines that collects data from multiple aws organizations. Provided data access patterns using real time continues aggregates for data visuelization. Client: XX Germany Mysql Storage engine (01/2017 - 10/2020) Created custom storage engine for mysql initial coded in c++ and then switch to rust Upwork (12/2019 - Present) Worked on different project related to database development and optimisations EDUCATION Informatics and computer engineering Faculty of computer science and engineering 09/2013 - 10/2017, Skopje, Macedonia LANGUAGES Macedonian English Native or Bilingual Proficiency Full Professional Proficiency Bulgarian Slovenian Full Professional Proficiency Full Professional Proficiency German Elementary Proficiency