Senior Database Administrator (MariaDB/MySQL)

Job Description

We are looking for a Senior Database Administrator (DBA) to join the Snapp Box! DBA team. You will own the reliability, performance, and scalability of our database platforms. This role goes beyond traditional database operations and focuses on modern data engineering practices, automation, and early technical involvement in new projects. You will work closely with application teams, data engineers, and infrastructure teams to design, build, operate, and continuously improve database systems that support critical business workloads.

Core DBA Responsibilities

• Design, deploy, and operate MariaDB/MySQL clusters.
• Manage replication topologies (primary/replica, multi-replica, BI replicas).
• Perform online schema changes, upgrades, and migrations with minimal downtime.
• Own backup & recovery strategies.
• Troubleshoot and resolve performance issues (slow queries, locking, indexing).
• Capacity planning and resource forecasting.
• Design, deploy, and operate MongoDB clusters.

Data Platform & Streaming

• Support CDC pipelines using tools like Debezium and Kafka.
• Work with stream processing frameworks (e.g., Apache Flink).
• Integrate databases with analytical systems (Pinot, PostgreSQL, Redis, etc.).

Reliability & Observability

• Implement and maintain monitoring and alerting (Prometheus, Grafana, custom).
• Participate in incident response and post-mortems.

Automation & DevOps

• Build automation using Python / Bash.
• Standardize database provisioning and configuration.

Architecture & Early Involvement

• Act as a DBA advisor for new projects (early involvement model). Review database designs, schemas, and data access patterns.

Define standards for:

• Retention policies
• RPO/RTO
• Security and access models
• Cost and sizing

Required Skills:

• Strong experience with MariaDB / MySQL (5+ years hands-on).
• High availability and failover architectures (replication-based HA, multi-node clusters, automated failover).
• Replication, binlogs, GTID.
• Query optimization & indexing.
• Linux systems administration.
• SQL and data modeling.
• NoSQL databases and distributed data models.
• Good knowledge of backup tools.
• Monitoring tools (Grafana, Prometheus).