Oracle SQL Developer

RiDiK (a Subsidiary of CLPS. Nasdaq: CLPS); Dubai; On-site; AED 260,000 - 380,000; Full time

Job summary

RiDiK, a subsidiary of CLPS, seeks a Senior Software Engineer with 7+ years in enterprise database development and data warehousing. The role focuses on designing, developing, testing, and maintaining scalable database solutions to support BI, analytics, reporting, and operational systems.

Responsibilities include building ETL/ELT processes, optimizing SQL, and automating data pipelines with Python/PySpark, while collaborating with BI teams and stakeholders in a fast-paced Agile environment.

Qualifications

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

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

Skills

Oracle SQL

PL/SQL

Python

PySpark

Data Warehousing

ETL/ELT

Data Modeling

Agile experience

Mentoring/leadership

BI platforms knowledge

Tools

Amazon Redshift

AWS (S3, Glue, EMR)

Power BI

MicroStrategy

Tableau

Git/version control

Job description

Position - Senior Software Engineer

EXP: 7+ Years

Location: Dubai

Primary Skill

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

Job Summary:

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.

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, MicroStrategy, 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.

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

About CLPS RiDiK

RiDiK is a global technology solutions provider and a subsidiary of CLPS Incorporation (NASDAQ: CLPS), delivering cutting-edge end-to-end services across banking, wealth management, and e-commerce. With deep expertise in AI, cloud, big data, and blockchain, we support clients across Asia, North America, and the Middle East in driving digital transformation and achieving sustainable growth. Operating from regional hubs in 10 countries and backed by a global delivery network, we combine local insight with technical excellence to deliver real, measurable impact. Join RiDiK and be part of an innovative, fast-growing team shaping the future of technology across industries