Senior Cloud Database Administrator

Summary

Join dLocal as a Cloud DBA and be responsible for database performance, integrity, and security. You will interact with software engineers, maintain AWS RDS and Aurora MySQL instances, write SQL functions and procedures, troubleshoot performance issues, migrate databases, manage user access, and ensure data integrity. You will also support BI, DW, and DataLake teams, plan database splits, and propose improvements to maintenance, usage, and monitoring. This role offers a flexible, remote-first culture with various benefits. dLocal is a global company with a dynamic team and a commitment to employee growth and development. The ideal candidate will have extensive experience with MySQL, AWS RDS, and database optimization.

Requirements

• Minimum of 5 years of experience managing MySQL database environments
• Exceptional knowledge of AWS RDS for MySQL and/or AWS AURORA MySQL
• Exceptional knowledge on 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)
• Strong SQL abilities (Query Optimization and proper indexing)
• Experience working with HA solutions supporting high transaction workloads (Multi- Primary. Primary-Replica, Cluster, etc)
• Clear understanding of database metrics and available monitoring tools on: AWS Cloud: CloudWatch, 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
• Ability to troubleshoot methodically, identifying and applying fixes for known errors as well

Responsibilities

• Interact daily with software engineers and participate in the systems operation process
• Maintain AWS RDS for MySQL and AWS 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
• Apply fixes, manage user access rights and privileges
• Ensure data integrity and availability
• Support BI, DW, Report and DataLake Teams optimizing queries and helping to define better strategies for data replication
• Planning split of huge and monolithic database instances to lower, performatic and optimized ones
• Proposing improvements on the most common aspects related to maintenance, usage and monitoring

Preferred Qualifications

• Experience in NoSQL (DynamoDB and ElasticSearch)
• Experience in MySQL Community related tools like: Percona TooKit, ProxySQL, mydumper, mysqlpump, MySQL Shell, GH-OST (GitHub's Online Schema migration for MySQL)
• Experience in In-Memory databases
• Experience in other AWS products like: Redshift; Open SearchDMS (Database Migration Service); CloudTrail; Kinesis; Backup; Cloud Shell; Service Catalog (SC)

Benefits

• Remote work: work from anywhere or one of our offices around the globe!*
• Flexibility: we have flexible schedules and we are driven by performance
• Fintech industry: work in a dynamic and ever-evolving environment, with plenty to build and boost your creativity
• Referral bonus program: our internal talents are the best recruiters - refer someone ideal for a role and get rewarded
• Learning & development: get access to a Premium Coursera subscription
• Language classes: we provide free English, Spanish, or Portuguese classes
• Social budget: you'll get a monthly budget to chill out with your team (in person or remotely) and deepen your connections!
• DLocal Houses: want to rent a house to spend one week anywhere in the world coworking with your team? We’ve got your back!