Database Administrator

• Production Database Operations

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