Database Administrator

3 days ago

remote, Hong Kong SAR China Traze Full-time

We are looking for a proactive Database Administrator to join our Technical Operations team and maintain reliable, secure and performant production database services.

You will administer MySQL, Percona Server, MariaDB and Google Cloud SQL for MySQL environments, collaborate with Engineering and Data teams, and improve database availability, performance and recovery capabilities. Your responsibilities will include automating database operations, reviewing database changes, and planning upgrades and migrations, including the modernization of legacy database environments.

The role includes participation in an on-call rotation and scheduled maintenance outside standard working hours.

Principal Accountabilities
  • Administer and maintain production and non-production MySQL, Percona Server and MariaDB environments.
  • Administer Google Cloud SQL for MySQL instances, including configuration, monitoring, high availability, read replicas, automated backups and point-in-time recovery.
  • Plan and execute Cloud SQL maintenance, upgrades and migrations; manage connectivity, access controls, capacity and cost optimization.
  • Monitor database health, workload, availability and performance; investigate slow queries, locking, deadlocks and resource bottlenecks.
  • Optimize queries, indexes, database configuration and resource utilization in collaboration with Engineering teams.
  • Define and maintain backup and recovery procedures, including point-in-time recovery. Perform regular restore tests and disaster recovery exercises against agreed Recovery Point Objective (RPO) and Recovery Time Objective (RTO) targets.
  • Design, maintain and test replication, failover and failback procedures; investigate replication lag and data consistency issues.
  • Manage database access according to least-privilege principles, conduct periodic access reviews, and maintain appropriate encryption, audit logging and security patching.
  • Review SQL, schema changes, indexes and database migrations. Assess their impact on performance and availability, and establish rollout, validation and rollback procedures.
  • Plan and execute database upgrades and migrations, including compatibility testing and migration from legacy environments.
  • Participate in production incident response and the on-call rotation. Perform root cause analysis and implement preventive actions.
  • Forecast storage and resource requirements, identify capacity risks and recommend infrastructure and cost optimizations.
  • Automate routine database operations using version-controlled scripts and configuration management tools.
  • Investigate database integrity and consistency issues, working with application and data owners to implement preventive controls.
  • Support the deployment and operation of analytical and other database platforms as required.
  • Maintain database inventories, architecture diagrams, operational runbooks and recovery documentation.
  • Follow established change management, approval and incident management procedures.
Essential Qualifications and Experience
  • At least 3 years of hands-on experience administering MySQL databases in production environments, including experience with Percona Server and/or MariaDB.
  • Hands-on experience administering Google Cloud SQL for MySQL in production, including high availability, read replicas, backup restoration and point-in-time recovery.
  • Understanding of Cloud SQL connectivity and security, including private IP networking, IAM and Cloud SQL Auth Proxy.
  • Strong SQL skills and practical experience optimizing queries, indexes and database performance.
  • Strong understanding of InnoDB, transactions, isolation levels, locking, deadlocks and query execution plans.
  • Experience configuring and troubleshooting replication, investigating replication lag, and performing failover and recovery.
  • Hands-on experience with backup restoration and point-in-time recovery, including validation of restored data.
  • Experience performing production schema changes, database upgrades and migrations with controlled downtime and documented rollback procedures.
  • At least 3 years of Linux administration experience, including troubleshooting CPU, memory, storage and I/O issues.
  • Understanding of TCP/IP networking and its impact on database connectivity and performance.
  • Experience automating operational tasks using Bash and/or Python.
  • Experience with database monitoring and alerting tools such as Prometheus, Zabbix, Percona Monitoring and Management or Google Cloud Monitoring.
  • Understanding of database security, access control and least-privilege principles.
  • Experience supporting business-critical database services with 24/7 availability requirements.
  • Ability to troubleshoot incidents