Freelancerprofil: Senior Data Engineer and database migrations - Henry Hüske in Dresden

Senior Data Engineer and database migrations

verfügbar
Henry Hüske | Dresden | Remote | Stunden- und Tagessatz 90 EUR / 720 EUR
Um den Freelancer zu kontaktieren, müssen Sie eingeloggt sein
Kategorie(n): IT
FREELANCER KONTAKTIEREN

Freelancer-Vorstellung

SPRACHEN

  • Deutsch (Muttersprache)
  • Englisch (Verhandlungssicher)
  • Schwedisch (Gut)

Studienabschluss

Diplom-Handelslehrer

FÄHIGKEITEN, KENNTNISSE UND ERFAHRUNGEN

My offers


  • Technical project management \& project management support

  • Performing development tasks in the areas Data Warehouse (DWH), ETL and Big Data

  • Replacement/migration/upgrade of relational databases (in particular Oracle databases, PostgreSQL)

  • Support with the transfer of your database into the cloud infrastructure (AWS, GCP)

  • Performance optimization of your database queries and processes



Your benefits


  • You can concentrate on your day-to-day business while I will take care of your project management tasks.

  • The optimization and acceleration of data processes brings your data to its destination in a faster way and enables you to carry out more timely analyzes.

  • The replacement/migration of your database takes place in a structured way and with the smallest possible downtime.

  • The knowledge of your employees increases through my technical support and guidance.

  • Better and faster database queries and processes increase customer satisfaction.




Professional and project experience


  • 2015 until 2019: Senior Data Engineer, Avantgarde Labs GmbH, Dresden, Germany:
    • IT service provider with approx. 40 employees. My job included technical support for the ETL team of a large German e-commerce provider for electronic items; the ETL infrastructure consisted of 300 to 400 ETL jobs. On the one hand, I was responsible for creating, changing and optimizing ETL jobs using Talend Studio DI, and on the other hand for planning ETL processes and prioritizing tasks for a team of up to 5 employees. In the 5 years in the project three different Talend versions (5.3.1, 6.2.1, 7.0.1) were used. When upgrading the Talend Studio versions including the associated infrastructure components (Talend Administration Center, Nexus, git / SVN), I took over the technical coordination of the necessary steps in coordination with internal and external employees. A central database with a size of approximately 2 TB was used to combine the data from various source systems; until 2017 it was an Oracle database in version 11g R2, after that the database was migrated to PostgreSQL 9.6 and ETL infrastructure was transfered to the cloud (Google Cloud Platform using "Cloud SQL" for the database and VMs for the infrastructure components).

  • 2009 until 2014: Data Engineer, Tele-Kabel-Ingenieurgesellschaft mbH, Chemnitz, Germany:
    • IT service provider with approx. 80 employees. My task was the project coordination for and the implementation of approx. 80 geodata migrations for supply networks (waster water, electricity, gas) for a Swiss GIS provider, which performs the GIS tasks for about 50 Swiss municipalities. The migrations took place from Oracle database 9 to Oracle database 11g R2. In addition, I carried out various customization programming for Autodesk Topobase using VB.NET for the customer.



List of skills


  • Focus topics

    • Technical project management & IT project management

    • ETL / DWH development & BigData

    • Database migration (upgrades of existing databases; migration to other relational databases)

    • Database performance optimization



  • Databases

    • Oracle

    • PostgreSQL

    • MySQL

    • MongoDB



  • Cloud

    • Amazon Web Services (AWS)

    • Google Cloud Platform (GCP)



  • Tools

    • bash

    • Docker

    • git

    • Linux

    • Python

    • Talend Studio




Verfügbarkeit

Immediate available.


  • Maximum of 30 working hours per week

  • Daily on-site work for customers in the Dresden (Germany) area

  • Daily remote work with the following on-site times outside Dresden:


    • At project start up to 2 weeks at customers office

    • 1 day every 2 weeks for customers in the areas Berlin, Leipzig, Erfurt, Chemnitz

    • 3 days every 2 months for customers in Europe

Stunden- und Tagessatz

Stundensatz: 90 EURO
Tagessatz: 720 EURO

Kann je nach Projektumfang und -aufgabe variieren

Portfolio_HenryHüske_deutsch.pdf (340 kB)
Hochgeladen am: 21.02.2020
Portfolio Henry Hüske (deutsch)
Portfolio_HenryHüske_english.pdf (337 kB)
Hochgeladen am: 21.02.2020
Portfolio Henry Hüske (english)
FREELANCER KONTAKTIEREN
Bitte loggen Sie sich ein oder registrieren Sie sich, um das Freelancer zu kontaktieren.
Neu bei projektwerk?