Senior Data Engineer – PL/SQL & Redshift

Cinergie Digital

Dubai

On-site

AED 112,000 - 145,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Work visa
Air tickets
Medical insurance
Gratuity
Paid time off

Job summary

Cinergie Digital in Dubai, UAE, seeks a Senior Data Engineer to design, develop, and maintain scalable database, data integration, and data warehouse solutions using Oracle, SQL, PL/SQL, and Amazon Redshift.

The role emphasizes bulk data processing, ETL pipelines, query optimization, and data transformation across diverse data sources. Airline domain knowledge and AWS plus MicroStrategy BI familiarity are highly valued.

Qualifications

  • 5-8 years of experience in data engineering, database development, or a related role.
  • Strong hands-on experience with advanced SQL and PL/SQL.
  • Expertise in writing, optimizing, and debugging complex SQL queries and stored procedures.
  • Strong experience with Oracle Database.
  • Hands-on experience with Amazon Redshift.
  • Experience in bulk data processing and large-volume data handling.
  • Good knowledge of data modeling, schema design, and query optimization.
  • Experience developing ETL processes and data integration solutions.
  • Ability to troubleshoot ETL and data-related issues.
  • Experience in designing scalable and reusable data pipelines.
  • Good understanding of data transformation and data warehousing concepts.
  • Experience with AWS services and cloud-based data solutions.
  • Familiarity with MicroStrategy BI Platform.
  • Strong analytical and problem-solving skills.

Responsibilities

  • Design, develop, and maintain database solutions using Oracle, SQL, and PL/SQL.
  • Write, optimize, and debug complex SQL queries, stored procedures, functions, and packages.
  • Develop solutions for bulk data processing and large-scale data transformation.
  • Design data models, database schemas, and efficient data structures.
  • Develop and maintain data integration and data warehouse solutions.
  • Build scalable, modular, and reusable ETL components for large-scale data pipelines.
  • Work with disparate data sources and perform data extraction, transformation, and analysis.
  • Develop and optimize solutions using Amazon Redshift.
  • Troubleshoot data-related issues, ETL failures, and production incidents.
  • Perform database and query performance tuning.
  • Collaborate with IT, business, and other technical teams to understand requirements and deliver effective solutions.
  • Ensure data accuracy, reliability, and performance.
  • Support data analysis and reporting requirements in collaboration with BI teams.
  • Participate in testing, deployment, and production support activities.

Skills

Advanced SQL
PL/SQL
Oracle DB
Amazon Redshift
ETL pipelines
Data warehousing
Data modeling
AWS services
MicroStrategy BI
Airline domain
Big data processing
Query optimization
Troubleshooting ETL

Education

Bachelor's degree in Computer Science, Information Technology, Engineering

Tools

None

Job description

Location: Dubai, UAE (Client Site)

Salary: AED 10,000 - AED 13,000 / month

Benefits: Work visa, air tickets, medical insurance, gratuity, paid time off

Experience: 5-8 years of relevant experience

Reference: FZ-AE-493

We are looking for a Senior Data Engineer with strong expertise in SQL, PL/SQL, Oracle, and Amazon Redshift to design, develop, and maintain scalable database, data integration, and data warehouse solutions.

The ideal candidate should have hands-on experience working with complex data sources, bulk data processing, ETL pipelines, query optimization, and data transformation. Experience in the airline domain and familiarity with AWS and MicroStrategy BI will be highly preferred.

Key Responsibilities
  • Design, develop, and maintain database solutions using Oracle, SQL, and PL/SQL.
  • Write, optimize, and debug complex SQL queries, stored procedures, functions, and packages.
  • Develop solutions for bulk data processing and large-scale data transformation.
  • Design data models, database schemas, and efficient data structures.
  • Develop and maintain data integration and data warehouse solutions.
  • Build scalable, modular, and reusable ETL components for large-scale data pipelines.
  • Work with disparate data sources and perform data extraction, transformation, and analysis.
  • Develop and optimize solutions using Amazon Redshift.
  • Troubleshoot data-related issues, ETL failures, and production incidents.
  • Perform database and query performance tuning.
  • Collaborate with IT, business, and other technical teams to understand requirements and deliver effective solutions.
  • Ensure data accuracy, consistency, reliability, and performance.
  • Support data analysis and reporting requirements in collaboration with BI teams.
  • Participate in testing, deployment, and production support activities.
Required Technical Skills
  • 5-8 years of experience in data engineering, database development, or a related role.
  • Strong hands-on experience with advanced SQL and PL/SQL.
  • Expertise in writing, optimizing, and debugging complex SQL queries and stored procedures.
  • Strong experience with Oracle Database.
  • Hands-on experience with Amazon Redshift.
  • Experience in bulk data processing and large-volume data handling.
  • Good knowledge of data modeling, schema design, and query optimization.
  • Experience developing ETL processes and data integration solutions.
  • Ability to troubleshoot ETL and data-related issues.
  • Experience in designing scalable and reusable data pipelines.
  • Good understanding of data transformation and data warehousing concepts.
  • Experience with AWS services and cloud-based data solutions.
  • Familiarity with MicroStrategy BI Platform.
  • Strong analytical and problem-solving skills.
Preferred Skills
  • Experience working in the airline or aviation domain.
  • Knowledge of Hadoop, Hive, or Spark.
  • Experience with AWS-based data engineering solutions.
  • Exposure to airline operational, commercial, or analytical data.
  • Experience working with large-scale enterprise data platforms.
Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

Soft Skills
  • Strong communication and collaboration skills.
  • Ability to work with business and technical stakeholders.
  • Good troubleshooting and analytical capabilities.
  • Ability to work independently and as part of a team.
  • Strong attention to detail and commitment to data quality.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Software Engineer, Oracle, SQL, PL/SQL, Amazon Redshift
Senior Software Engineer, Oracle, SQL, PL/SQL, Amazon Redshift

ConnexR Solutions Pvt Ltd • Dubai

On-site
AED 112,000 - 134,000
Senior Software Engineer, Oracle PL/SQL
Senior Software Engineer, Oracle PL/SQL

ConnexR Solutions Pvt Ltd • Dubai

On-site
AED 145,000 - 167,000
Senior Oracle PL/SQL Developer
Senior Oracle PL/SQL Developer

Cinergie Digital • Dubai

On-site
AED 112,000 - 145,000
Work visa
Air tickets
Medical insurance
+2
Senior Software Engineer, Oracle SQL & PL/SQL Amazon Redshift AWS (S3, Glue, EMR) Python / PySpark Data Warehousing
Senior Software Engineer, Oracle SQL & PL/SQL Amazon Redshift AWS (S3, Glue, EMR) Python / PySpark Data Warehousing

ConnexR Solutions Pvt Ltd • Dubai

On-site
AED 107,000 - 179,000
Senior Database Developer
Senior Database Developer

Ampstek • Dubai

On-site
AED 300,000 - 520,000
Senior Data Engineer: Oracle, Redshift & ETL Specialist
Senior Data Engineer: Oracle, Redshift & ETL Specialist

Cinergie Digital • Dubai

On-site
AED 112,000 - 145,000
Work visa
Air tickets
Medical insurance
+2
Senior Data Engineer
Senior Data Engineer

NorthBay Solutions LLC • Abu Dhabi

On-site
AED 240,000 - 480,000
Senior Database Developer Data Warehousing & BI
Senior Database Developer Data Warehousing & BI

Cinergie Digital • Dubai

On-site
AED 300,000 - 480,000
PL/SQL Developer
PL/SQL Developer

Ampstek • Dubai

On-site
AED 300,000 - 520,000
Data Engineer
Data Engineer

Datamatics Technologies LLC • Sharjah

On-site
AED 134,000 - 201,000
Top locations