DB Developer

IBS Software; Abu Dhabi; On-site; AED 246,000 - 379,000; Full time

Job summary

IBS Software in Abu Dhabi is seeking a data professional to design and build database solutions across complex data sources. You will transform data and create scalable data integration and warehouse solutions to support cross-functional business needs.

The role emphasizes SQL optimization, data modeling, and performance tuning of data flows, with hands-on experience in Oracle and Redshift. Collaboration with IT and business teams is essential to deliver reliable insights.

Qualifications

• Proficient in writing and debugging complex SQL
• Bulk data processing with SQL/PLSQL
• Data modeling and schema design
• Oracle and Redshift databases
• Data integration requirement gathering
• Ability to build reports and insights
• Troubleshoot data issues efficiently
• Performance tuning of data flows and queries
• Cross-functional collaboration
• Hadoop Hive Spark experience preferred
• AWS cloud Airlines domain experience preferred
• Design and build data warehousing solutions
• Work with diverse data sources and transformations

Responsibilities

• Design and build database solutions.
• Work with diverse data sources and perform transformations.
• Collaborate with IT and business teams to deliver goals.
• Create scalable data integration and warehouse solutions.
• Build reports and deliver data insights.
• Tune and optimize data flows for performance.

Skills

SQL Queries

Stored Procedures

Bulk Data Processing

Data Modeling

Oracle & Redshift

Data Integration

Reporting & Analytics

Performance Tuning

Hadoop Spark

AWS Cloud

Tools

Oracle

Amazon Redshift

Job description

• Strong skills in writing optimizing and debugging complex SQL queries and stored procedures


• Experience in bulk data processing using advanced SQL and PL SQL techniques


• Proficiency in data modeling schema design and query optimization


• Hands on knowledge on Oracle Amazon Redshift databases


• Expertise in gathering and analyzing data integration requirements to create scalable solutions


• Ability to build reports and generate data insights


• Strong aptitude for identifying and resolving data-related issues efficiently


• Proven experience in performance tuning of Data flows and SQL queries


• Strong communication and collaboration skills for working with cross-functional teams


• Prefer to have experience working with Hadoop Hive Spark frameworks


• AWS cloud Airlines domain experience preferred


• Primary responsibility of this role is to design and build database solutions


• Work with complex disparate data sources and perform data transformation


• data analysis


• Design and build data integration amp warehouse solutions


• Collaborate with other IT and business departments as per project needs to deliver common goals