Database Reliability Engineer (Forex /Fintech)

Key Responsibilities

1. Production Database Operations

Manage production and non-production databases across CRM, Client Portal, Payment, MT4/MT5 data, reporting, and data warehouse systems.

Maintain MySQL, PostgreSQL, TimescaleDB, ClickHouse, Doris, Redis, and other database platforms.

Monitor database health, connections, locks, replication lag, storage usage, CPU, memory, IO, and query performance.

Handle production incidents related to database availability, latency, deadlocks, connection failures, and data consistency.

2. Database Reliability Engineering

Design and improve database reliability, scalability, and fault tolerance.

Build database monitoring dashboards and alerting rules using Prometheus, Grafana, CloudWatch, or similar tools.

Define SLO/SLA metrics for database availability, query latency, replication delay, and recovery time.

Automate routine database operations using scripts, scheduled jobs, and infrastructure tooling.

Participate in incident response, root cause analysis, and post-incident improvement planning.

3. Performance Optimization

Analyze and optimize slow SQL queries.

Design and maintain indexes, partitions, materialized views, and table structures.

Optimize large trading, transaction, commission, payment, and reporting tables.

Support application teams in improving database access patterns.

Review database schema changes and migration scripts before production deployment.

4. Backup, Recovery and DR

Design and maintain database backup and recovery strategies.

Perform regular recovery tests.

Define and validate RPO/RTO targets.

Prepare database disaster recovery runbooks.

Support BCP/DR testing and regulatory audit requirements.

5. Replication, CDC and Data Synchronization

Manage MySQL/PostgreSQL replication, binlog, WAL, replication slots, and failover procedures.

Support CDC pipelines using Flink CDC, Debezium, Kafka, ClickPipe, or similar tools.

Troubleshoot data synchronization delays, missing data, checkpoint issues, and pipeline failures.

Ensure reliable data flow from OLTP databases to OLAP systems such as Doris and ClickHouse.

6. Data Warehouse and Reporting Support

Support trading reports, deposit/withdrawal reports, IB commission reports, customer activity reports, and risk analysis.

Optimize analytical queries on ClickHouse, Doris, TimescaleDB, and PostgreSQL.

Work with business, operations, and finance teams to ensure reporting data accuracy.

Help design data retention, archiving, and historical data query strategies.

7. Database Security and Audit

Implement database access control and least privilege principles.

Manage database users, roles, permissions, and service accounts.

Audit high-risk SQL operations such as DELETE, DROP, TRUNCATE, ALTER, and large data exports.

Support investigation of suspicious database access or abnormal query activity.

Work with security teams to improve database governance and compliance.

Required Skills

Must Have

Strong experience with MySQL and PostgreSQL in production environments.

Strong SQL tuning and troubleshooting ability.

Experience with backup, restore, replication, failover, and high availability.

Experience handling production database incidents.

Good Linux and shell scripting skills.

Good understanding of database security and permission management.

Experience with monitoring tools such as Prometheus, Grafana, CloudWatch, or Zabbix.

Strongly Preferred

AWS RDS / Aurora / EC2 database operation experience.

TimescaleDB, ClickHouse, Apache Doris experience.

CDC experience with Flink CDC, Debezium, Kafka, or ClickPipe.

Redis operation and troubleshooting experience.

Experience in financial, forex, payment, trading, or high-transaction systems.

Understanding of MT4/MT5 trading data, account data, deal/order/trade records, and commission reporting.

Pay: AED8,000.00 - AED10,000.00 per month

Application Question(s):

• Are you ok with the salary package between 8k-10k AED ?

Work Location: In person