Senior Oracle PL/SQL & - Data Integration Engineer

Kamayi; Dubai; On-site; AED 111,600 - 145,080; Full time

Benefits offered by this job

UAE employment visa sponsorship

Annual air tickets

Comprehensive medical insurance

End-of-service gratuity

Paid time off

Job summary

Kamayi is seeking an experienced data engineer in Dubai with expertise in Oracle PL/SQL and data integration. The role encompasses designing enterprise-grade database solutions, ensuring data accuracy through reporting, and optimizing performance of SQL queries. Ideal candidates will have 5-7 years of experience, strong communication skills, and preferred knowledge in cloud services like AWS. The position offers a salary of AED 10,000-13,000 per month along with comprehensive medical insurance and annual leave benefits.

Qualifications

• 5 to 7 years of hands-on professional experience in Oracle PL/SQL development.
• Strong skills in writing, optimizing, and debugging complex SQL queries.
• Proficiency in data modeling and schema design for database systems.

Responsibilities

• Design and build enterprise-grade database solutions.
• Develop and maintain comprehensive reporting solutions.
• Conduct performance tuning of SQL queries and data flows.
• Perform in-depth data analysis across large datasets.

Skills

Oracle PL/SQL development

SQL query optimization

Data integration engineering

Data modeling

Performance tuning

Communication skills

Education

Bachelor's degree in Computer Science or related discipline

Tools

Amazon Redshift

Hadoop

Spark

AWS cloud services

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

• 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.

WHAT WE OFFER

• Salary: AED 10000-13000 per 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