PL/SQL Developer

Ampstek

Dubai

On-site

AED 300,000 - 520,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Ampstek in Dubai seeks a Senior Database Developer to design, develop, test, and optimize enterprise database and data warehouse solutions that support business intelligence, analytics, reporting, and operations.

You will build and optimize ETL/ELT processes, model data warehouses, and tune performance for high-volume environments using Oracle SQL/PLSQL, Amazon Redshift, PySpark, and BI platforms such as Power BI, MicroStrategy, or Tableau. Collaboration with BI and data teams is essential.

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.
  • Prior experience mentoring junior developers or leading technical initiatives is an advantage.

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.

Tools

Stored Procedures
Packages
Functions
Triggers
Views
Data Modeling & Dimensional Modeling
Query Optimization
Indexing
Partitioning
Redshift Spectrum
Data Integration
High-Volume Data Processing
Power BI
MicroStrategy
Tableau
Git / Version Control
Production Support, Incident Management & Root Cause Analysis
Logging, Monitoring & Workflow Automation
Agile Development Practices
PySpark
Hive
Spark
Big Data technologies
AWS or Oracle certifications
24/7 support on-call rotations

Job description

  • Stored Procedures, Packages, Functions, Triggers, Views
  • Data Modeling & Dimensional Modeling
  • Query Optimization, Indexing, Partitioning
  • Redshift Spectrum
  • Data Integration & High-Volume Data Processing
  • Power BI, MicroStrategy, Tableau
  • Git / Version Control
  • Production Support, Incident Management & Root Cause Analysis
  • Logging, Monitoring & Workflow Automation
  • Agile Development Practices
  • PySpark, Hive, Spark, or other Big Data technologies.
  • AWS or Oracle certifications.
  • Experience with 24/7 support and on-call rotations.

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, 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Database Developer
Senior Database Developer

Ampstek • Dubai

On-site
AED 300,000 - 520,000
Senior Database Developer Data Warehousing & BI
Senior Database Developer Data Warehousing & BI

Cinergie Digital • Dubai

On-site
AED 300,000 - 480,000
DB Developer
DB Developer

IBS Software • Abu Dhabi

On-site
AED 246,000 - 379,000
Senior Software Engineer
Senior Software Engineer

Techcarrot • Dubai

On-site
AED 180,000 - 240,000
Senior Data Engineer – PL/SQL & Redshift
Senior Data Engineer – PL/SQL & Redshift

Cinergie Digital • Dubai

On-site
AED 112,000 - 145,000
Work visa
Air tickets
Medical insurance
+2
Senior Database Support Engineer
Senior Database Support Engineer

Finclutech Ltd • Dubai

On-site
AED 260,000 - 400,000
Senior Oracle PL/SQL Developer
Senior Oracle PL/SQL Developer

Cinergie Digital • Dubai

On-site
AED 112,000 - 145,000
Work visa
Air tickets
Medical insurance
+2
Senior Data Warehouse Engineer - Oracle/Redshift & ETL
Senior Data Warehouse Engineer - Oracle/Redshift & ETL

Ampstek • Dubai

On-site
AED 300,000 - 520,000
Oracle PL/SQL & Data Integration Lead
Oracle PL/SQL & Data Integration Lead

Facilitative Employment Services - Kamayi • Dubai

On-site
AED 279,000 - 424,000
Salary: AED per month (based on exp)
UAE work visa sponsored
Annual air tickets as per UAE Labour/L
+3
Senior Oracle PL/SQL & Data Warehouse Architect
Senior Oracle PL/SQL & Data Warehouse Architect

Facilitative Employment Services - Kamayi • Dubai

On-site
AED 312,000 - 558,000
Work visa sponsored
Annual air tickets
Medical insurance
+2
Top locations