Database Administrator

Production Database Operations

Manage production and non‑production databases across CRM, Client Portal, Payment, MT4/MT5 data reporting, and data warehouse systems including MySQL, Postgre

SQL, Timescale

DB, Click House, Doris, Redis and other database platforms. Monitor database health, connections, locks, replication lag, storage usage, CPU, memory, I/O 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, Cloud Watch 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 and Postgre
  
  SQL replication, binlog, WAL replication slots and failover procedures.
• Support CDC pipelines using Flink CDC, Debezium, Kafka, Click Pipe 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 Click House.

Support trading reports, deposit withdrawal reports, IB commission reports, customer activity reports and risk analysis. Optimize analytical queries on Click House, Doris, Timescale

DB and Postgre

SQL. 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 Postgre
  
  SQL 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, Cloud Watch, or Zabbix.

• AWS RDS / Aurora / EC2 database operation experience.
• Timescale
  
  DB, Click House, Apache Doris experience.
• CDC experience with Flink CDC, Debezium, Kafka, or Click Pipe.
• 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.