Senior Data Warehouse & DB Engineering Lead

Ampstek

Dubai

On-site

AED 391,000 - 614,000

Full time

19 hours 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 seeks a Senior Database Developer to lead enterprise database and data warehouse initiatives. You will design, develop, test, and optimize scalable solutions supporting business intelligence, analytics, reporting, and operations.

You will work with Oracle SQL/PLSQL, Amazon Redshift, and AWS data services, building ETL/ELT processes, data models, and high‑volume data pipelines using Python/PySpark.

Qualifications

  • 7+ years of hands-on database development experience.
  • Experience with Oracle SQL/PLSQL is required.
  • Hands-on experience with AWS data services and data warehousing.
  • Proficiency in Python/PySpark for data engineering and automation.
  • Experience with BI platforms (Power BI, Tableau, MicroStrategy).
  • Experience in 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
Amazon Redshift
AWS data services
ETL/ELT
Python/PySpark
Data warehousing
Data modeling
Git/version control
Agile methodologies
Aviation data domain
Mentoring juniors

Tools

Power BI
Tableau
MicroStrategy

Job description

Ampstek in Dubai seeks a Senior Database Developer to lead enterprise database and data warehouse initiatives. You will design, develop, test, and optimize scalable solutions supporting business intelligence, analytics, reporting, and operations.

You will work with Oracle SQL/PLSQL, Amazon Redshift, and AWS data services, building ETL/ELT processes, data models, and high‑volume data pipelines using Python/PySpark.

Get your free, confidential resume review.

or drag and drop your file here.

Top locations