Data Engineer | ETL & Database Performance Specialist | MySQL, PostgreSQL/TimescaleDB, Azure, DuckDB

Zambujeira do Mar, Portugal

Only remote

Computer Science Degree

Zambujeira do Mar, Portugal

Only remote

Computer Science Degree

Profile attachments

About me

Data Engineer with 20+ years of experience specializing in production data infrastructure, multi-terabyte database administration, and ETL pipeline development across heterogeneous sources. Proven track record in complex database migrations, performance tuning, and 11+ years of remote work.

TimescaleDBData IntegrationExtract Transform Load (ETL)Data MigrationDatabase DevelopmentAzure SQLOracle SQL DeveloperSQL DatabasesDatabase EnginesTransact-SQLPlsqldeveloper

CORE EXPERTISE AND PROFILE

I am a Senior Data Engineer and Database Specialist with over 20 years of professional experience (including 11+ years working fully remote) designing, optimizing, and maintaining production data systems. My core strength is taking complex, messy data environments—multi-terabyte databases, raw files, and legacy systems—and turning them into fast, reliable, and organized infrastructure.

DATABASE ADMINISTRATION AND PERFORMANCE TUNING

Production Databases at Scale: Hands-on expertise managing, monitoring, and tuning large multi-terabyte databases across MySQL, PostgreSQL (including TimescaleDB for high-volume time-series electricity data), and SQL Server.
Query and Execution Optimization: The go-to person on the team for fixing slow queries. Experienced in troubleshooting bottlenecks and bringing query times down from minutes to single-digit seconds using smart indexing, temporary tables, query rewrites, and DuckDB for fast in-memory processing.
Database Migrations and Consolidation: Skilled in leading complex database migration projects—such as combining separate MySQL, Access, and SQL Server databases into a single system—while working directly with business teams to set clear data validation rules.

ETL PIPELINE ENGINEERING AND DATA INTEGRATION

Multi-Source Data Ingestion: Extensive experience building and automating end-to-end data pipelines that bring in data from databases, REST APIs, flat files, XML, and JSON.
Pipeline Tools and Automation: Proficient in building and scheduling data workflows using Python, Prefect, Azure Data Factory, and Talend Open Studio.

CLOUD, INFRASTRUCTURE AND ANALYTICS

Cloud and Hybrid Setup: Hands-on experience managing hybrid infrastructure across Azure (Azure SQL Server, Azure Data Factory, Azure MySQL) and on-premises Linux and Docker environments.
Reporting and Business Tools: Experienced in building custom reporting platforms, PowerBI dashboards, PowerBI Report Builder reports.
GIS Data Handling: Practical experience processing GIS mapping data to support operational and agricultural planning.

TECHNICAL STACK OVERVIEW

Databases: MySQL, PostgreSQL, TimescaleDB, SQL Server, DuckDB, Oracle, SQLite, PostGIS
Programming and SQL: Python, T-SQL, PL/SQL, C#, ASP.NET
Data Integration Tools: Prefect, Azure Data Factory, Talend Open Studio
Cloud and Containers: Azure, Docker, Linux, CI/CD
Reporting Tools: PowerBI Desktop, PowerBI Report Builder, Azure PowerApps
Certifications: Microsoft Certified Professional 70-461 (Querying SQL Server 2012) and 70-761 (Querying Data with Transact-SQL SQL Server 2016)

Experience

Professional experience10+ years

Freelancer since2014

Languages

EnglishFluentPortugueseNative speaker

Project history

Data Engineer

eVISO - Algo Efficiency for Commodities

Energy, Water & Environment

50-250 team member

Eviso AI its a commodity company that uses AI to generate value. In this case, doing AI over Electricity data and selling AI services through it.

Activities:
• Develop and maintain ETL processes
• Database Administration Tasks
• Database performance optimization
• Health monitoring under a big database

Technologies:
• Azure MySQL + MySQL onPermises
• Python
• C#
• Azure PowerApps
• PowerBI
• Docker
• Talend Open Studio 7.3

Data Engineer

Groundwork Systems

Other

< 10 team member

Support agriculture companies by developing custom data systems for specialty crops that are core
business

Activities:
• Supporting web development regarding database tasks
• Migration of data between different db systems
• Develop and maintain ETL developments
• Database performance optimization
• Processing GIS information

Technologies:
• Azure MySQL + MySQL onPermises
• Python
• Azure SQL SERVER + Azure Data Factory
• Docker
• C#
• Talend Open Studio 7.3
• Unix

Data Engineer | ASP.NET/C# Developer

Proxio

Internet & IT

10-50 team member

Proxio is the real estate sales platform developers, brokers, and agents use to market and sell property anywhere in the world.

Activities:
• ETL system maintenance
• New data providers installation
• Client communication

Technologies:
• SQL Server 2008r2 / 2016, Talend Open Studio, ASP.NET/C#, Visual Studio 17
• Unix, MYSQL, Java
• Webservices

Contact form

You need to be logged in to use the contact form.