Senior Database Developer – PL/SQL Jobs in Dubai, UAE

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

Location: Dubai, United Arab Emirates
Job Category: IT / Database Development / Data Engineering
Industry: Technology / Data Engineering
Experience: 7+ years
Notice Period: 30 days
Employment Type: Not specified

Job Overview

A hiring opportunity is available for an experienced Senior Database Developer – PL/SQL in Dubai, UAE. The role requires strong expertise in Oracle SQL and PL/SQL, data warehousing, Amazon Redshift, AWS services, ETL/ELT pipelines, and data engineering.

The successful candidate should have hands-on experience developing and optimizing database solutions, building data processing workflows, and supporting production environments. Airline or aviation domain experience is highly preferred, particularly experience working with passenger name records (PNR), bookings, passenger information, revenue, or flight data.

Key Responsibilities

Based on the technical skills listed in the original announcement, the role may involve:

• Developing and maintaining Oracle SQL and PL/SQL 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 business intelligence solutions using Power BI, MicroStrategy, or Tableau.
• Managing source control through Git and working in Agile environments.
• Providing production support, root cause analysis (RCA), and 24/7 on-call support as required.

Required Skills and Qualifications

• 7+ years of overall professional experience.
• At least 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, conduct RCA, and participate in on-call support.

Preferred: Airline or aviation domain experience involving PNR, booking, passenger, revenue, or flight data.

Career Development

This opportunity offers exposure to enterprise database development, cloud data platforms, data warehousing, and data engineering. Experience across these areas can support further career growth in senior database development, data engineering, and cloud data platform roles.

Important: Salary, benefits, and the employer’s name were not specified in the original announcement.