About the Role
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.
What You’ll Do
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.
What You’d Have
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.