Role:
As a member of the DBA 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 databases handle high volumes of transactions and terabytes of data across PostgreSQL, MySQL, MongoDB, ClickHouse, ScyllaDB, and more. Your work directly supports a seamless and reliable experience for millions of users across all TIKI platforms.
Requirements:
3+ years of experience operating *nix OSes on servers and using Linux as the main OS on personal laptops/PCs (e.g., CentOS, Rocky, Ubuntu, Debian).
3+ years of hands-on experience as a DBA in large-scale production environments.
Expertise in at least one major RDBMS (e.g., PostgreSQL, MySQL).
Strong understanding of database internals, storage engines, indexing, partitioning, and replication.
Proven experience in performance tuning and optimization (PTO) at both SQL query and infrastructure levels.
Familiarity with high availability solutions (e.g., clustering, replication).
Experience in scaling database and infrastructure solutions to support large, high-traffic systems.
Experience with Change Data Capture such as Kafka Connect.
Experience with database monitoring and management tools (e.g., Prometheus, grafana, exporters, etc.).
Knowledge of cloud database services (Google Cloud SQL, AWS RDS/Aurora) is a plus.
Experience working with Google Cloud Platform (GCP) is advantageous.
Strong analytical and problem-solving skills.
Understanding of Internet Protocols and Networks.
Proactive working attitude, open-minded, and result-oriented.
Excellent communication and documentation abilities.
Available for off-hour support.
Ability to work under high pressure.
Nice to Have:
Experience with NoSQL databases (e.g., Cassandra, ScyllaDB), data streaming platforms (e.g., Kafka), and data warehouse platforms (e.g., BigQuery).
Exposure to CI/CD pipelines and infrastructure-as-code (e.g., Terraform, Ansible, Git).
Responsibilities:
Design, implement, and optimize database schemas, indexes, and queries to improve performance, scalability, and reliability.
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, disaster recovery strategies.
Proposing cost-effective solutions.
Set up and manage database partitioning, indexing strategies to handle large data volumes efficiently.
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.
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.