Senior Data Warehouse Engineer - Oracle/Redshift & ETL

Ampstek

Dubai

On-site

AED 300,000 - 520,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ampstek in Dubai is seeking a Senior Database Developer with extensive enterprise database development and data warehousing experience to design, develop, test, optimize, and maintain scalable database solutions supporting BI, analytics, reporting, and operations.

The role emphasizes Oracle SQL/PLSQL, Amazon Redshift, AWS data services, Python/PySpark, and collaboration with BI teams. You will mentor juniors and drive best practices across deployments and 24/7 production support.

Qualifications

  • 7+ years of hands-on database development experience.
  • At least 5 years in Oracle SQL/PLSQL.
  • Experience with data warehousing and ETL/ELT.
  • Experience with Python/PySpark for data engineering.
  • Experience with BI platforms (Power BI, MicroStrategy, Tableau).
  • Agile environments and Git/version control.

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/PLSQL
Python/PySpark
Data Warehousing
ETL/ELT
Performance tuning
Agile
Git/version control

Tools

Power BI
MicroStrategy
Tableau
Git

Job description

Ampstek in Dubai is seeking a Senior Database Developer with extensive enterprise database development and data warehousing experience to design, develop, test, optimize, and maintain scalable database solutions supporting BI, analytics, reporting, and operations.

The role emphasizes Oracle SQL/PLSQL, Amazon Redshift, AWS data services, Python/PySpark, and collaboration with BI teams. You will mentor juniors and drive best practices across deployments and 24/7 production support.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Warehouse Engineer – Redshift, AWS, BI
Senior Data Warehouse Engineer – Redshift, AWS, BI

Ampstek • Dubai

On-site
AED 300,000 - 520,000
Senior Database Developer: Oracle & Redshift Expert
Senior Database Developer: Oracle & Redshift Expert

Coforge Limited • Dubai

On-site
AED 180,000 - 300,000
Senior Data Engineer: Oracle, Redshift & ETL Specialist
Senior Data Engineer: Oracle, Redshift & ETL Specialist

Cinergie Digital • Dubai

On-site
AED 112,000 - 145,000
Work visa
Air tickets
Medical insurance
+2
Data Warehouse Engineer - Oracle SQL & Redshift (Dubai)
Data Warehouse Engineer - Oracle SQL & Redshift (Dubai)

ConnexR Solutions Pvt Ltd • Dubai

On-site
AED 107,000 - 179,000
Senior Data Warehouse & BI Architect - AWS Redshift Expert
Senior Data Warehouse & BI Architect - AWS Redshift Expert

Cinergie Digital • Dubai

On-site
AED 300,000 - 480,000
Dubai Data Warehouse Engineer | SQL/PL-SQL Expert
Dubai Data Warehouse Engineer | SQL/PL-SQL Expert

techcarrot FZ • Dubai

On-site
AED 120,000 - 200,000
Senior Software Engineer, Data & Warehouse Solutions
Senior Software Engineer, Data & Warehouse Solutions

Techcarrot • Dubai

On-site
AED 180,000 - 240,000
Senior Database Developer Data Warehousing & BI
Senior Database Developer Data Warehousing & BI

Cinergie Digital • Dubai

On-site
AED 300,000 - 480,000
Senior Database Developer
Senior Database Developer

Ampstek • Dubai

On-site
AED 300,000 - 520,000
Senior Oracle SQL/PLSQL Engineer – Redshift, Dubai
Senior Oracle SQL/PLSQL Engineer – Redshift, Dubai

ConnexR Solutions Pvt Ltd • Dubai

On-site
AED 112,000 - 134,000
Top locations