Database Administrator

**Why you should join dLocal?**

dLocal enables the biggest companies in the world to collect payments in 40 countries in emerging markets. Global brands rely on us to increase conversion rates and simplify payment expansion effortlessly. As both a payments processor and a merchant of record where we operate, we make it possible for our merchants to make inroads into the world’s fastest-growing, emerging markets.

By joining us you will be a part of an amazing global team that makes it all happen, in a flexible, remote-first dynamic culture with travel, health, and learning benefits, among others. Being a part of dLocal means working with 800+ teammates from 25+ different nationalities and developing an international career that impacts millions of people’s daily lives. We are builders, we never run from a challenge, we are customer-centric, and if this sounds like you, we know you will thrive in our team.

**What’s the opportunity?**

As our DBA (Database Administrator), you will be responsible for the performance, integrity and security of our databases, planning and developing ways to improve them, as well as in troubleshooting cases.

**What will I be doing?**:

- Interact daily with software engineers and participate in the systems operation process
- Maintain AWS RDS/AURORA MySQL instances with high workloads and zero downtime
- Write functions and procedures in SQL Language
- Troubleshoot slow queries and possible performance issues/bottlenecks
- Migrate databases between platforms and versions
- Ensure data integrity and availability
- Support BI, DW, Report, and DataLake Teams by optimizing queries and helping to define better strategies for data replication
- Planning split of huge and monolithic database instances to lower, performative and optimized ones
- Proposing improvements on the most common aspects related to maintenance, usage, and monitoring

**What skills do I need?**:

- Minimum of 5 years of experience managing MySQL database environments
- Exceptional knowledge of AWS RDS/AURORA MySQL
- Exceptional knowledge of MySQL RDBMs Architecture (versions 5.6, 5.7, and 8)
- Database Instance configuration, performance, and tuning
- Database objects optimization (table indexes, table statistics, table partitioning procedures, and function revision/code)
- Deep SQL abilities (Query Optimization and proper indexing)
- Experience working with HA solutions supporting high transaction workloads (Multi
- Primary. Primary-Replica, Cluster, etc)
- A clear understanding of database metrics and available monitoring tools on:

- **AWS Cloud**: AWS CloudWatch, RDS Performance Insights, and Common Metrics on AWS Console
- **MySQL**: information_schema, performance_schema, error logs, audit logs, slow query logs, and general logs, show engine innodb status
- Proactivity to propose improvements on the team’s day-to-day and all current processes adopted
- Ability to multi-task and flex when priorities change
- Ability to influence peers and drive results through teamwork and collaboration

**What happens after you apply?**

Also, you can check out our webpage, Linkedin, Instagram, and Youtube for more about dLocal