Senior Oracle SQL/PLSQL ETL Data Engineer – Dubai

techecs; United Arab Emirates; On-site; AED 350,000 - 550,000; Full time

Job summary

techecs in Dubai, UAE seeks an experienced Senior Database Developer – PL/SQL to lead Oracle SQL/PLSQL development, data warehousing, and AWS-based data pipelines. The role emphasizes building scalable database solutions, optimizing performance, and supporting production environments.

Experience with Redshift, S3, Glue, EMR, and BI tools like Power BI or Tableau is highly valued, with preferred airline/aviation domain background handling passenger data and flight-related datasets.

Qualifications

• 7+ years of overall professional experience.
• 5+ years of experience with Oracle SQL/PLSQL.
• Strong knowledge of stored procedures, packages, functions, triggers, and views.
• Experience with query optimization, indexing, and partitioning.
• Knowledge of Amazon Redshift and Redshift Spectrum.
• Experience with AWS S3, Glue, and EMR.
• Understanding of data modeling and ETL/ELT processes.
• Familiarity with Python, PySpark, Spark, or Hive.
• Exposure to Power BI, MicroStrategy, or Tableau.
• Experience with Git and Agile methodologies.
• Ability to support production systems, RCA, and on-call support.

Responsibilities

• Developing and maintaining Oracle SQL/PLSQL procedures, packages, functions, triggers, and views.
• Optimizing SQL queries and improving database performance through indexing and partitioning.
• Working with Amazon Redshift and Redshift Spectrum for data warehousing and analytics.
• Supporting data engineering workflows using AWS S3, Glue, and EMR.
• Contributing to data modeling and ETL/ELT pipeline development.
• Using Python, PySpark, Spark, or Hive for data processing.
• Supporting BI solutions with Power BI, MicroStrategy, or Tableau.
• Managing source control through Git in Agile environments.
• Providing production support, RCA, and 24/7 on-call support as needed.
• Preferred: Airline or aviation domain experience (PNR, bookings, passenger data).

Skills

Oracle SQL/PLSQL

Data warehousing

AWS services

ETL/ELT pipelines

Data engineering

Python

PySpark

Spark

Hive

Power BI

MicroStrategy

Tableau

Git

Agile methodologies

Tools

Amazon Redshift

Redshift Spectrum

AWS S3

Glue

EMR

Job description

techecs in Dubai, UAE seeks an experienced Senior Database Developer – PL/SQL to lead Oracle SQL/PLSQL development, data warehousing, and AWS-based data pipelines. The role emphasizes building scalable database solutions, optimizing performance, and supporting production environments.

Experience with Redshift, S3, Glue, EMR, and BI tools like Power BI or Tableau is highly valued, with preferred airline/aviation domain background handling passenger data and flight-related datasets.