Database Administrator MHMarkets

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.

1. 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.

1. 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.

1. 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.

1. 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.

1. 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.

1. 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.