Database Administrator Specialist

Description

Job Summary: The Cactus team is seeking a DBA Specialist with a DBRE (Database Reliability Engineer) profile to ensure high availability, performance, scalability, and security in high-volume, mission-critical data environments. Key Highlights: 1. Administer and optimize MySQL Aurora (AWS) databases 2. Work in highly critical environments, ensuring high availability 3. Develop and evolve monitoring and observability systems **Who we are:** Cactus is a company offering a customized White Label platform, holding approximately 40% of the Brazilian gaming market, with around 30 operators using its platform. The Cactus platform connects betting operators with banks and game providers. **What we seek:** We are looking for a DBA with a DBRE (Database Reliability Engineer) profile at Specialist level, possessing solid experience in relational and non-relational databases. This professional will be responsible for ensuring high availability, performance, scalability, and security in mission-critical, high-volume data environments. ### **Responsibilities** * Administer, maintain, and optimize MySQL Aurora (AWS) databases using tools such as ProxySQL; * Operate in highly critical environments, ensuring high availability through clustering, replication, and failover strategies; * Perform performance tuning, execution plan analysis, advanced troubleshooting, and resolution of issues such as deadlocks; * Optimize complex queries, including advanced use of JOINs, subqueries, and indexing; * Evaluate and select NoSQL technologies (e.g., MongoDB, Redis, DynamoDB, Cassandra), assessing trade-offs among consistency, availability, and partition tolerance (CAP theorem); * Design and implement data storage solutions using non-relational (NoSQL) databases according to requirements for scale, performance, and flexibility; * Automate operational routines and database processes; * Execute and manage backup, restore, replication, and data migration processes (including tools such as AWS DMS, Percona Toolkit, and ProxySQL); * Implement and manage security policies, access control, encryption, and auditing; * Develop, maintain, and evolve monitoring and observability systems (e.g., Zabbix, Prometheus, or similar); * Operate under high-availability conditions (24x7), ensuring service reliability and continuity; * Collaborate in defining data architecture, including hybrid environments (relational + NoSQL), aiming for scalability and resilience. ### **Technical Requirements** * Strong expertise in relational databases, especially MySQL and PostgreSQL; * Practical experience with non-relational (NoSQL) databases such as MongoDB, Redis, Cassandra, or similar; * Advanced knowledge of Linux and/or Windows Server operating systems; * Experience with Infrastructure-as-Code (IaC) practices, preferably using Terraform; * Experience with containerized environments (Docker) and orchestration with Kubernetes; * Hands-on experience in cloud environments (AWS), particularly with managed database services. **Benefits? Absolutely!** Meal/food allowance via Caju card, with full flexibility to use as preferred. Flexible mobility allowance (via Caju). Health and dental insurance ️‍ ️ Wellhub (Gympass) for you to take care of your physical health however you prefer — 100% covered by the company, including for your dependents. Conexa Saúde – Online nutritionist Psicologia Viva – Sessions with psychologists Childcare allowance; ‍‍ Extended leave: extended maternity and paternity leave; Allowance for children with special needs; Home office allowance; Birthday day off