Database Administrator, DBA

Posted 11ds ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Experienced Database Administrator for 12Go in R&D team managing multi-engine database infrastructure. Ensuring database reliability, performance, and security for online travel platform.

Responsibilities:

  • 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.
  • 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.
  • 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.
  • Implement and verify backup strategy: logical + physical, with tested restore procedures;
  • Maintain point-in-time recovery capability for all critical databases.
  • 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.
  • 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.

Requirements:

  • MariaDB - 3+ years: replication, GTID, binlog, InnoDB tuning, Mariabackup, Percona Toolkit.
  • Replication migration - Has done position → GTID migration in production.
  • AWS RDS - Knows RDS limitations vs self-hosted; parameter groups, snapshots.
  • Performance tuning - Can read EXPLAIN, identify bad indexes, fix slow queries independently.
  • Backup & DR - Designed and tested restore procedures; knows xtrabackup / mariabackup.
  • Schema migrations - Used pt-osc or gh-ost; understands locking implications.
  • Monitoring - Set up Prometheus + Grafana or PMM for database metrics.
  • Linux / Shell - Comfortable with bash, systemd, log analysis.
  • Docker - Runs DB in 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 via Terraform.
  • Python or Go - Automation scripts, custom monitoring exporters.

Benefits:

  • Engaging work on a product that enables millions of travelers to book their trips daily;
  • Full-time remote working - 5 days week, 8 hours per day;
  • Development opportunities (budget for self-paced learning, global training workshops, online English language classes, e-learning platforms);
  • Internal growth and internal mobility opportunities;
  • Competitive annual leave, sick leave, and public holidays;
  • Annual company offsite in Thailand.
  • What should I do to dive into 12Go company culture?