Oracle Database Developer

HUMAN-AI-Z Nexus Technology; Dubai; On-site; AED 300,000 - 520,000; Full time

Job summary

HUMAN-AI-Z Nexus Technology in Dubai seeks a Senior Database Developer with 7+ years of hands-on experience in enterprise database development and data warehousing. You will design, develop, test, and maintain scalable database solutions supporting BI, analytics, reporting, and operations.

The role emphasizes Oracle SQL/PLSQL expertise, Amazon Redshift with AWS data services, Python/PySpark automation, and data modeling.

Qualifications

• 7+ years of hands-on database development experience.
• At least 5 years in Oracle SQL/PLSQL.
• Strong experience with Amazon Redshift and AWS data services (S3, Glue, EMR).
• Hands-on Python/PySpark for data engineering and automation.

Responsibilities

• Design, develop, test, and maintain enterprise database and data warehouse solutions.
• Develop and optimize stored procedures, packages, functions, triggers, views, and complex SQL queries.
• Design data warehouse models and build ETL/ELT processes to integrate data from multiple sources while ensuring data quality and integrity.
• Perform performance tuning, query optimization, indexing, partitioning, and workload management for high-volume data environments.
• Automate database and data engineering processes using Python/PySpark.
• Collaborate with BI teams, data engineers, and stakeholders to translate requirements into scalable technical solutions.
• Manage deployments across environments and conduct code reviews.
• Participate in 24/7 production support for production-critical applications.

Skills

Oracle SQL/PLSQL

Amazon Redshift

AWS data services

Python/PySpark

Data Warehousing

ETL/ELT

SQL performance tuning

BI tools

Job description

Senior Software Engineer (5-8 yrs of experience)

Location: Dubai

Primary Skill

Oracle SQL & PL/SQL Amazon Redshift AWS (S3, Glue, EMR) Python / PySpark Data Warehousing & ETL/ELT Database Performance Tuning.

Job Description

We are looking for a Senior Database Developer with strong experience in enterprise database development and data warehousing. The role will be responsible for designing, developing, testing, optimizing, and maintaining scalable database solutions supporting business intelligence, analytics, reporting, and operational systems.

Key Responsibilities

• Design, develop, test, and maintain enterprise database and data warehouse solutions.
• Develop and optimize stored procedures, packages, functions, triggers, views, and complex SQL queries.
• Design data warehouse models and build ETL/ELT processes to integrate data from multiple sources while ensuring data quality and integrity.
• Perform performance tuning, query optimization, indexing, partitioning, and workload management for high-volume data environments.
• Automate database and data engineering processes using Python/PySpark.
• Collaborate with business stakeholders, BI teams, data engineers, and application support teams to translate business requirements into scalable technical solutions.
• Manage deployments across environments and conduct code reviews.
• Participate in 24/7 production support for production-critical applications, including incident management, troubleshooting, performance issue resolution, and root cause analysis.
• Mentor junior developers and contribute to technical initiatives and development best practices.

Required Skills & Experience

7+ years of hands‑on database development experience, including at least 5 years in Oracle SQL/PLSQL. Strong experience in Amazon Redshift, AWS data services (S3, Glue, EMR), Data Warehousing, ETL/ELT, and Data Modeling. Hands‑on experience with Python/PySpark for data engineering, high-volume data processing, and automation. Experience with BI platforms such as Power BI, Micro Strategy, or Tableau. Experience working in Agile environments and using Git/version control. Airline/Aviation domain experience, particularly with PNR, booking, passenger, revenue, or flight data, is highly preferred. Prior experience mentoring junior developers or leading technical initiatives is an advantage.