Senior Oracle PLSQL & Data Integration Engineer

Facilitative Employment Services - Kamayi; Dubai; On-site; AED 279,000 - 424,000; Full time

Benefits offered by this job

Salary: AED per month (based on exp)

UAE work visa sponsored

Annual air tickets as per UAE Labour/L

Medical Insurance

Gratuity as per UAE Labour Law

Annual leave and public holidays

Job summary

Facilitative Employment Services - Kamayi in Dubai seeks a data solutions engineer with 5–7 years in Oracle PL/SQL and data integration. You will design databases, build reports, and optimize data pipelines across AWS Redshift and Hadoop ecosystems.

You will collaborate with cross‑functional teams, document architectures, and ensure data quality from ingestion to reporting for aviation‑adjacent domains. Excellent communication in English is essential.

Qualifications

• Bachelor's degree in Computer Science Information Technology Engineering or a closely related discipline.
• 5 to 7 years of hands‑on professional experience in Oracle PL/SQL development and data integration engineering.
• Strong skills in writing optimizing and debugging complex SQL queries and stored procedures in production environments.
• Demonstrated experience in bulk data processing using advanced SQL and PL/SQL techniques including BULK COLLECT FORALL and exception handling.
• Proficiency in data modeling and schema design for both transactional and analytical database systems.
• Expertise in gathering and analyzing data integration requirements and translating them into scalable maintainable technical solutions.
• Ability to build and deliver reports and generate data‑driven insights aligned to business requirements.
• Strong aptitude for identifying troubleshooting and resolving data‑related issues efficiently and systematically.
• Proven experience in performance tuning of data flows ETL processes and complex SQL queries.
• Excellent communication and collaboration skills with demonstrated ability to work effectively within cross‑functional teams.
• Experience in the airlines or aviation domain is preferred.
• Hands‑on experience with Amazon Redshift Hadoop Hive Spark and AWS cloud services is preferred.
• Proficiency in English; strong written and verbal communication skills required for a client‑facing on‑site engagement.

Responsibilities

• Design and build enterprise-grade database solutions that meet complex business and technical requirements.
• Develop and maintain comprehensive reporting solutions ensuring data accuracy, consistency and timeliness.
• Create and manage stored procedures, functions, triggers and packages using Oracle PL/SQL to support business logic and data processing needs.
• Build and optimize data models and schema designs to support scalable and maintainable database architectures.
• Design, develop and maintain data integration and data warehouse solutions to consolidate data from complex and disparate source systems.
• Gather and analyze data integration requirements from business and technical stakeholders translating them into scalable technical solutions.
• Perform data transformation, cleansing and enrichment activities to ensure high-quality reliable data pipelines.
• Support the development and maintenance of ETL workflows and data flows across multiple platforms and environments.
• Conduct performance tuning of SQL queries, stored procedures and data flows to ensure optimal system responsiveness and efficiency.
• Apply advanced SQL and PL/SQL techniques for bulk data processing, minimizing resource consumption and maximizing throughput.
• Identify, diagnose and resolve data-related issues, bottlenecks and performance degradation in a timely and systematic manner.
• Monitor and proactively maintain the health and performance of database environments in production and non-production settings.
• Perform in-depth data analysis across large and complex datasets to surface meaningful business insights.
• Build and deliver data reports and dashboards that support informed decision-making across business functions.
• Validate data integrity and accuracy throughout the data lifecycle from ingestion through to reporting outputs.
• Interpret data patterns and trends to provide recommendations aligned with business objectives.
• Collaborate effectively with technology and business teams to understand project requirements and deliver against shared goals.
• Participate in technical discussions, solution reviews and design sessions with cross-functional teams.
• Communicate complex technical concepts clearly and concisely to both technical and non-technical stakeholders.
• Contribute to documentation of technical designs, data dictionaries and solution architectures to support knowledge transfer and maintainability.

Skills

Oracle PL/SQL

SQL optimization

Data integration

ETL development

Data modeling

Performance tuning

Analytics & reporting

English communication

Education

Bachelor's degree in Computer Science or related field

Tools

Amazon Redshift

Hadoop

Hive

Spark

AWS

Job description

KEY RESPONSIBILITIES

1. Database & Report Solution Design

Design and build enterprise-grade database solutions that meet complex business and technical requirements.

Develop and maintain comprehensive reporting solutions ensuring data accuracy consistency and timeliness.

Create and manage stored procedures functions triggers and packages using Oracle PL/SQL to support business logic and data processing needs.

Build and optimize data models and schema designs to support scalable and maintainable database architectures.

2. Data Integration & Warehouse Development

Design develop and maintain data integration and data warehouse solutions to consolidate data from complex and disparate source systems.

Gather and analyze data integration requirements from business and technical stakeholders translating them into scalable and efficient technical solutions.

Perform data transformation cleansing and enrichment activities to ensure high-quality reliable data pipelines.

Support the development and maintenance of ETL workflows and data flows across multiple platforms and environments.

3. Performance Tuning & Query Optimization

Conduct performance tuning of SQL queries stored procedures and data flows to ensure optimal system responsiveness and efficiency.

Apply advanced SQL and PL/SQL techniques for bulk data processing minimizing resource consumption and maximizing throughput.

Identify diagnose and resolve data-related issues bottlenecks and performance degradation in a timely and systematic manner.

Monitor and proactively maintain the health and performance of database environments in production and non-production settings.

4. Data Analysis & Insight Generation

Perform in-depth data analysis across large and complex datasets to surface meaningful business insights.

Build and deliver data reports and dashboards that support informed decision-making across business functions.

Validate data integrity and accuracy throughout the data lifecycle from ingestion through to reporting outputs.

Interpret data patterns and trends to provide recommendations aligned with business objectives.

5. Collaboration & Stakeholder Engagement

Collaborate effectively with technology and business teams to understand project requirements and deliver against shared goals.

Participate in technical discussions solution reviews and design sessions with cross-functional teams.

Communicate complex technical concepts clearly and concisely to both technical and non-technical stakeholders.

Contribute to documentation of technical designs data dictionaries and solution architectures to support knowledge transfer and maintainability.

QUALIFICATIONS & EXPERIENCE

• Bachelors degree in Computer Science Information Technology Engineering or a closely related discipline.
• 5 to 7 years of hands‑on professional experience in Oracle PL/SQL development and data integration engineering.
• Strong skills in writing optimizing and debugging complex SQL queries and stored procedures in production environments.
• Demonstrated experience in bulk data processing using advanced SQL and PL/SQL techniques including BULK COLLECT FORALL and exception handling.
• Proficiency in data modeling and schema design for both transactional and analytical database systems.
• Expertise in gathering and analyzing data integration requirements and translating them into scalable maintainable technical solutions.
• Ability to build and deliver reports and generate data‑driven insights aligned to business requirements.
• Strong aptitude for identifying troubleshooting and resolving data‑related issues efficiently and systematically.
• Proven experience in performance tuning of data flows ETL processes and complex SQL queries.
• Excellent communication and collaboration skills with demonstrated ability to work effectively within cross‑functional teams.
• Experience in the airlines or aviation domain is preferred.
• Hands‑on experience with Amazon Redshift Hadoop Hive Spark and AWS cloud services is preferred.
• Proficiency in English; strong written and verbal communication skills required for a client‑facing on‑site engagement.

WHAT WE OFFER

• Salary: AEDper month (based on experience and skill fit)
• Work Visa: UAE employment visa sponsored and processed by the company
• Annual Air Tickets: Return air tickets provided as per UAE Labour Law entitlements
• Medical Insurance: Comprehensive medical insurance coverage
• Gratuity: End‑of‑service gratuity as per UAE Labour Law
• Paid Time Off: Annual leave sick leave and public holidays as per UAE regulations