Database Reliability Engineer (Forex /Fintech)

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.

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.

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.

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.

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.

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.

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.

Strong experience with MySQL and PostgreSQL in production environments.

Strong SQL tuning and troubleshooting ability.

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

handling production database incidents.

Good Linux and shell scripting skills.

Good understanding of database security and permission management.

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

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.

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