Senior Database Administrator

Summary

Join dLocal as a Database Administrator and be responsible for the performance, integrity, and security of our databases. You will interact with software engineers, maintain AWS RDS/AURORA MySQL instances, write SQL functions and procedures, troubleshoot performance issues, and migrate databases. This role requires a minimum of 5 years of experience managing MySQL database environments and exceptional knowledge of AWS RDS/AURORA MySQL and MySQL RDBMs architecture. You will work in a flexible, remote-first dynamic culture with travel, health, and learning benefits. dLocal offers a global team environment with opportunities for international career development.

Requirements

• 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
• A clear understanding of database metrics and available monitoring tools on: 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

Responsibilities

• 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
• Apply fixes, manage user access rights and privileges
• 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

Benefits

• Flexible, remote-first dynamic culture
• Travel benefits
• Health benefits
• Learning benefits