Analyst - Open Source DBA

Mindtel; Dubai; On-site; AED 120,000 - 200,000; Full time

Job summary

A leading technology firm in Dubai seeks a Database Migration Analyst to support the migration of operational application databases from proprietary systems to open-source platforms like PostgreSQL and MySQL. The ideal candidate will have certifications in PostgreSQL, MySQL, and Red Hat. Responsibilities include evaluating, planning, and executing migration activities along with routine maintenance tasks. Strong experience with PostgreSQL and MySQL across platforms is essential.

Qualifications

• Experienced in managing PostgreSQL and MySQL on Linux and Windows platforms.
• Familiar with Streaming Replication and Postgres-BDR setups.
• Skilled in scripting with Bash, PowerShell, and Python.

Responsibilities

• Support migration of operational application databases to open-source platforms.
• Assist in evaluation, planning, and execution of migration activities.
• Handle business-as-usual tasks such as maintenance and system performance analysis.

Skills

PostgreSQL Management

MySQL Management

Scripting

Education

PostgreSQL Professional Certification

OCP: Oracle Certified Professional MySQL

RHCE or RHCSA: Red Hat Certified Engineer / System Administrator

MongoDB Associate Database Administrator Certification

Tools

PostgreSQL EDB

PostgreSQL Enterprise Manager (PEM)

Red Hat Enterprise Linux (RHEL)

Job description

To support the migration of CLIENT operational application databases from proprietary systems (such as Oracle and SQL Server) to open-source platforms like PostgreSQL and MySQL. The role involves assisting in the evaluation planning and execution of migration activities aimed at reducing the total cost of ownership and dependency on proprietary technologies. The analyst will also handle business- as-usual (BAU) tasks including routine maintenance system performance analysis application support and coordinating upgrades or release requests from business units

Professional/Regulatory/Certification Requirements

• PostgreSQL Professional Certification
• EDB (EnterpriseDB) Professional Certification
• OCP: Oracle Certified Professional MySQL
• RHCE or RHCSA: Red Hat Certified Engineer / System Administrator

MongoDB Associate Database Administrator Certification

Core Activities Experience

Experienced in managing and supporting PostgreSQL (version 14 and above) on both Linux and Windows platforms including PostgreSQL EDB and high availability setups using Streaming Replication and Postgres-BDR. Skilled in working with MySQL versions 5 through 8 across Linux and Windows environments

Skills Tools and Systems Experience

• Open-Source Databases: PostgreSQL (90%) MongoDB (5%) MySQL (5%)
• Scripting: Bash PowerShell and Python
• PostgreSQL EDB (version 12 and above)
• PostgreSQL Enterprise Manager (PEM) for performance monitoring
• Database clustering and replication technologies including CitusData and EDB Enterprise Failover Manager (EFM)
• Red Hat Enterprise Linux (RHEL) Microsoft Office Suite