This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
As part of Tiki’s Database team, you will be responsible for managing and optimizing our large-scale database infrastructure to ensure the stability, data reliability, integrity, security, and performance of all TIKI services. You will handle database provisioning, performance tuning, high availability, backup/recovery strategies, designing scalable database architectures, access control, and incident troubleshooting to keep our data systems healthy 24/7. Our Systems handle high volumes of transactions and terabytes of data across PostgreSQL, MySQL, MongoDB, ClickHouse, ScyllaDB, and more.
Job Responsibility:
Design, implement, and optimize database schemas, indexes, and queries to improve performance, scalability, and reliability
Automate provisioning, configuration, access control, and schema deployment using Ansible, Terraform, and Git
Monitor database performance metrics, proactively identify bottlenecks, and troubleshoot incidents to ensure system stability and minimize downtime
Collaborate closely with developers, DevOps, and infrastructure teams to align database changes with application requirements and optimize SQL queries and access patterns
Review and automate database changes execution, deployment processes, user creation, and system permissions
Implement and manage backup, recovery, replication, and disaster recovery strategies
Proposing cost-effective solutions
Set up and manage database partitioning and indexing strategies to efficiently handle large data volumes
Conduct regular security audits, patching, and compliance assessments to maintain database security and integrity
Automate routine DBA tasks and implement monitoring solutions to ensure database health and availability
Support Change Data Capture (CDC) pipelines using Kafka Connect or similar tools
Apply Infrastructure-as-Code and CI/CD practices for version-controlled database configurations
Participate in on-call rotations and promptly respond to database-related emergencies outside business hours
Document database configurations, procedures, and troubleshooting guidelines for knowledge sharing and compliance
Requirements:
3+ years operating *nix systems in production (CentOS, Rocky, Ubuntu, Debian)
3+ years managing databases in large-scale environments
Expertise in at least one major RDBMS (PostgreSQL or MySQL)
Deep understanding of internals - storage engines, indexing, replication, and transactions
Proven skills in performance tuning and capacity planning
Familiarity with high-availability, scaling, and Kubernetes-based deployments
Experience with observability tools (Prometheus, Grafana)
Exposure to CDC, Terraform/Ansible, and Git-based CI/CD workflows
Understanding of networking fundamentals (TCP/IP, routing, firewalls)
Strong troubleshooting & problem-solving mindset
open and collaborative
Available for off-hour support when needed
Nice to have:
Experience with NoSQL (Cassandra, ScyllaDB) and data streaming (Kafka)
Familiarity with data warehouses (BigQuery) or cloud DB services (Cloud SQL, RDS/Aurora)