Skip to content
BackNov 8
Vitaliy P.
Upwork badge

Vitaliy P.

Data Warehouse & ETL Engineer | PostgreSQL & Oracle Performance Tuning

I transform messy data into reliable data warehouses and ETL pipelines, and I tune slow SQL on PostgreSQL and Oracle. I have a 10+ years background being a Data Engineer & BI Developer in the telecom sector. I modeled both classic star schema Data Warehouses as well as modern normalized Data Vault layers in Oracle and PostgreSQL databases using tools like ODI, Pentaho, and dbt. The biggest table I handled was 1 billion rows a day — this is exactly where every execution plan is treated as an art. On top of the Data Warehouse, I built dashboards using PowerBI and Oracle BI EE. During the AI era, I found out that RAG is a data problem, meaning it is mine. I do AI Engineering by building production-ready data infrastructure for LLM applications, managing vector databases, and setting up clean embedding pipelines. As a Lead Data Engineer, I smoothly collaborate with Data Scientists, Analytics teams, and C-level stakeholders to align data strategy with business goals. I integrate data from multiple sources like databases, structured and semi-structured files, and APIs, supporting batch, real-time, and near-real-time ingestion. I ensure enterprise-grade data security by implementing robust data masking, encryption, and access control policies. If your business is just becoming data-driven and your data looks messy, I can propose the simplest and most cost-effective solution for an MVP or PoC. 🛠️ My core stack is: 🔹 Databases: PostgreSQL | Oracle 🔹 ETL tools: SQL & PL/SQL | Python | PySpark | Pentaho | ODI 🔹 BI tools: PowerBI | Oracle BI EE ⚙️ I can also work with: 🔹 Databases: Snowflake | BigQuery | Redshift | Databricks | SQL Server | MySQL & MariaDB 🔹 ETL & orchestration: dbt | Airflow | SSIS 🔹 BI tools: Tableau | Looker Studio 💪 My fundamentals are really strong. 📩 Click "Message" or "Invite to Job" to discuss your project, and let's turn your data into your biggest asset.

🇰🇿Almaty, Kazakhstan$35/hr100% JSS4.99 (6)Since Jul 2020

Earnings and projects

MRR
$0

Last 6 months ÷ 6

World#245,037 / 412k
🇰🇿Country#477 / 762
Revenue, last 30 days
$0
Total earnings
$5.6k

Billed in all: $5.9k

World#245,037 / 412k
🇰🇿Country#477 / 762
Per project
$622
Projects, last 6 months
0
World#209,857 / 412k
🇰🇿Country#343 / 762
Projects in all
9
56% fixed44% hourly
World#212,272 / 412k
🇰🇿Country#423 / 762

Earnings, last 30 days

$5.9kNothing earned in the last 30 daysBilled in all, before Upwork's fee · drag across the chart to see what was earned in any stretch
$5.7k$5.8k$5.9k$6.0kOct 9Oct 24Nov 8

Skills