Job Details

Skills Required: MySQL

Educational Requirements:

• Master Degree, Bachelor Degree

Experience:

• 3 Years

Extra Benefits:

• Sick Leave
• Annual Leave
• Special Leave
​

Job Description:

JOB SUMMARY

 We are looking for a hands-on Senior DBA to take ownership of database stability, performance, and reliability in a production system that currently faces unstable behavior and difficult-to-diagnose issues. This role requires real production troubleshooting experience (not only theoretical knowledge). You will lead root-cause analysis (RCA), performance tuning, HA/DR design, cluster deployment/operations, and operational standards.

 KEY ACCOUNTABILITIES

1. Production Stability & Incident Response

• Own database stability: investigate timeouts, slow queries, deadlocks, replication lag, performance spikes, connection saturation, and unexpected downtime.

• Drive incident handling end-to-end: triage → mitigation → recovery → postmortem (RCA) with clear corrective and preventive actions.

• Build a repeatable approach for “hard issues”: reproduce, isolate, prove root cause, and implement permanent fixes.

2. Performance Tuning & Optimization

• Optimize SQL performance: query analysis, indexing strategy, execution plans, statistics tuning, and parameter tuning.

• Optimize connection management (pooling, max connections, concurrency/threading), and reduce hotspots/lock contention.

• Improve schema design and data access patterns for high-concurrency workloads.

3. High Availability (HA), Backup & Disaster Recovery (DR)

• Design and operate replication/failover (HA) and disaster recovery strategies.

• Own backup & restore strategy: define RPO/RTO, validate backups, run restore drills, and support point-in-time recovery (PITR) when applicable.

• Ensure data integrity and consistency across environments.

• Own database cluster deployment and operations: design and implement cluster/replication topology, perform installation and configuration, rolling upgrades, failover drills, and ongoing health checks to ensure production reliability and business continuity.

4. Observability & Operational Excellence

• Implement monitoring/alerting: key DB metrics, slow query logs, lock waits, replication status, disk I/O, buffer/cache health.

• Create and maintain runbooks, SOPs, and database operational standards.

• Capacity planning: storage growth, performance headroom, scaling strategy.

5. Security & Compliance

• Manage roles/privileges, auditing, encryption (where applicable), and sensitive-data protection.

• Enforce safe change processes: review risky DDL, schema migrations, and deployment practices.

6. Collaboration

• Work with backend engineers to improve SQL and ORM usage, transaction boundaries, and data lifecycle practices.

• Provide DBA review for new features: schema changes, migration risk, performance impact, and test plan.

  JOB REQUIREMENTS

    (Education, Qualification/Skills/Behaviors, and Related Experiences.)

• 5+ years as a DBA / database reliability engineer with real production ownership.

• Proven experience resolving complex production DB issues (not only setup/maintenance).

• Strong in:

◦ Query tuning (EXPLAIN/ANALYZE), indexing, lock/deadlock diagnosis

◦ Replication/HA/failover, backup/restore and recovery drills

◦ Performance tuning (memory/I/O/concurrency), connection pooling strategy

• Comfortable working under pressure during incidents, producing clear RCA and prevention plans.

• Strong documentation and communication skills (able to explain root cause and fixes to non-DB stakeholders).

• Proven experience deploying and operating database clusters end-to-end in production: setup, configuration, monitoring, upgrades, failover, and scaling (strong in at least one: PostgreSQL or MySQL HA/replication ecosystem).

Preferred / Nice to Have

• Deep expertise in PostgreSQL and/or MySQL (one must be strong; both is a plus).

• Experience with high-concurrency systems (finance / gaming / e-commerce / trading).

• Experience in:

◦ Partitioning, archiving, sharding strategy (when needed)

◦ Read/write splitting, cache strategy (Redis), event-driven pipelines

◦ On-prem + cloud hybrid deployments

• Automation mindset: scripting (Bash/Python), Infrastructure-as-Code, CI/CD migration best practices.