Database Administrator (DBA)

12Go is the leading multimodal online travel agency founded in 2013, offering train, flight, bus, and ferry tickets, transfers, insurances, and other travel products on its platforms 12go.asia and 12go.co. The company operates in more than 70 countries and serves millions of travelers worldwide. It is part of the Travelier group.

• 3+ years experience with MariaDB replication, GTID, binlog, InnoDB tuning, Mariabackup, Percona Toolkit
• Experience with position to GTID replication migration in production
• Knowledge of AWS RDS limitations vs self-hosted; parameter groups, snapshots
• Ability to read EXPLAIN, identify bad indexes, and fix slow queries independently
• Experience designing and testing backup and restore procedures; knowledge of xtrabackup / mariabackup
• Experience with schema migrations using pt-osc or gh-ost; understanding locking implications
• Experience setting up Prometheus + Grafana or PMM for database metrics
• Comfortable with Linux/Shell (bash, systemd, log analysis)
• Experience running databases in Docker containers for dev/staging; understands volume management

Nice to Have:

• ClickHouse: MergeTree, partitions, materialized views, query profiling
• MongoDB replica sets
• Terraform / IaC managing RDS instances
• Python or Go for automation scripts and custom monitoring exporters

Replication & High Availability:

• Own MariaDB replication topology
• Design and execute GTID migration plan across self-hosted and RDS instances
• Monitor and maintain replica lag across all replicas
• Define and test failover and switchover runbooks

Performance & Reliability:

• Continuously audit slow query logs across all three engines
• Tune engine parameters for workload characteristics
• Set up and own PMM or equivalent observability stack for DB metrics

Schema Migrations & Release Process:

• Define and enforce safe schema migration procedures (online DDL, pt-online-schema-change)
• Integrate migration steps into CI/CD pipeline; enforce no-deploy-before-migration policy
• Maintain migration history and rollback procedures for every schema change

Backup & Disaster Recovery:

• Implement and verify backup strategy: logical + physical, with tested restore procedures
• Maintain point-in-time recovery capability for all critical databases

Security & Compliance:

• Manage database users, roles, and access policies (principle of least privilege)
• Audit and rotate credentials on schedule; integrate with secrets management
• Ensure data-at-rest and in-transit encryption is in place and documented

Documentation & Knowledge Sharing:

• Write and maintain runbooks for every database: failover, restore, migration, scaling
• Conduct internal knowledge transfer sessions with the DevOps team
• Participate in on-call rotation for database-related incidents