Senior Data Engineer (Oracle / SQL / Amazon Redshift)
Summary
On-site Senior Data Engineer in Dubai (client premises) designing, building, and tuning data warehouses and ETL pipelines on Oracle and Amazon Redshift. Day to day: advanced SQL/PL-SQL development, bulk data processing, data modelling, and query/performance tuning; aviation/airlines domain experience is a strong plus.
Job Title: Senior Data Engineer (Oracle / SQL / Amazon Redshift)
Location: Client Premises, Dubai, UAE
Employment Type: Full-Time, On-Site
Salary Range: AED 10,000 – 13,000 per month
Experience: 5 to 7 years
ABOUT THE ROLE
Cinergie Digital FZCO seeks an experienced Senior Data Engineer for a high-impact, on-site technology engagement in Dubai. The ideal candidate has deep expertise in Oracle, SQL, PL/SQL, and Amazon Redshift, and is capable of delivering robust, scalable data warehousing solutions across structured and unstructured data ecosystems – owning data architecture decisions, pipeline optimisation, and data integrity. Aviation/airlines domain experience is a strong advantage.
KEY RESPONSIBILITIES
Database Design & Development
- Design, develop, and maintain scalable database solutions; build stored procedures, functions, triggers, and PL/SQL objects for complex business logic.
- Develop and optimise advanced SQL/PL-SQL for ETL processes; apply bulk data processing for high-volume operations.
Data Integration & Warehousing
- Design and implement data integration pipelines consolidating disparate source systems; build and maintain data warehouses on Oracle and Amazon Redshift.
- Perform data transformation/analysis for reporting and analytics; ensure consistency, accuracy, and completeness across all layers.
Performance Tuning & Optimisation
- Tune SQL queries, stored procedures, and data flows to meet SLAs; optimise schema, indexing, and execution plans.
- Identify and resolve performance bottlenecks; monitor database health and implement corrective actions.
Data Modelling & Schema Design
- Design logical/physical data models aligned to business and technical requirements; define schema design standards; document data models and dictionaries.
Collaboration & Stakeholder Engagement
- Partner with IT and business teams on requirements; participate in technical reviews and sprint planning; communicate findings clearly; support knowledge transfer.
TECHNICAL SKILLS REQUIRED
- SQL & PL/SQL Development
- Advanced proficiency writing, debugging, optimising complex SQL/PL-SQL; stored procedures, packages, functions, cursors, triggers in production.
- Bulk Data Processing
- Expertise with BULK COLLECT, FORALL, and parallel processing constructs for high-volume datasets.
- Oracle Database
- Administration, schema management, data modelling, partitioning, indexing, performance tuning at enterprise scale.
- Amazon Redshift
- Architecture knowledge incl. distribution styles, sort keys, vacuum/analyse, and columnar query optimisation.
- Data Modelling & Schema Design
- Logical/physical modelling, dimensional modelling, normalisation/denormalisation, OLTP & OLAP schema design.
- Query Optimisation & Tuning
- Diagnosing slow queries, analysing execution plans, applying optimisation across Oracle and Redshift.
- Data Integration & ETL
- Designing ETL/ELT pipelines consolidating heterogeneous sources into centralised warehouses.
- Problem-Solving & Debugging
- Methodical root-cause analysis; resolving data quality issues; ensuring pipeline reliability.
- Cross-Functional Collaboration
- Strong communicator; translates business requirements into technical solutions.
- Airlines Domain Knowledge
- Familiarity with aviation/airline data structures and workflows highly advantageous; preference given.
QUALIFICATIONS & EXPERIENCE
- Bachelor's degree in Computer Science, IT, Engineering, or related technical discipline.
- 5–8 years' hands-on experience in data engineering, database development, or related role.
- Advanced SQL/PL-SQL skills with proven track record optimising and debugging in production environments.
- Demonstrated bulk data processing experience for high-volume enterprise workloads.
- Proficiency in data modelling, schema design, and query optimisation across relational and analytical platforms.
- Hands‑on knowledge of Oracle Database and Amazon Redshift, including configuration, tuning, and operational management.
- Proven performance tuning experience across data flows, ETL pipelines, and SQL queries at scale.
- Strong analytical aptitude for resolving data issues with minimal operational disruption.
- Excellent communication and cross-functional collaboration skills.
- Airlines/aviation industry experience preferred and considered a significant advantage.