Senior Oracle PL/SQL Developer

Location

• Dubai, UAE, at the client site.

Compensation and Benefits

• Salary is AED 10,000–13,000 per month.
• Benefits include a work visa, air tickets, medical insurance, gratuity, and paid time off.

Experience and Requirements

• The role requires 5–8 years of relevant experience.
• At least 5 years of hands-on Oracle PL/SQL development experience is required.
• Strong knowledge of relational database design is required.
• Expertise in SQL query optimization and performance tuning is required.
• Experience with large-scale, high-transaction production systems is required.
• Strong understanding of database indexing and optimization techniques is required.
• Airline domain knowledge, particularly PNR, fare and ticketing, inventory, reservation, and passenger data, is a strong advantage.

Role Overview

Key Responsibilities

• Design, develop, test, and optimize Oracle PL/SQL packages, procedures, functions, and triggers.
• Develop and tune complex SQL queries for large transactional databases.
• Perform database performance tuning, indexing, and optimization.
• Analyze and resolve data discrepancies related to PNR, fares, bookings, ticketing, and payments.
• Support data integrity, audit, and compliance requirements.
• Work with high-volume, high-transaction production systems.
• Collaborate with application, business, and technical teams to resolve database-related issues.
• Contribute to reliable and scalable database solutions for airline systems.