Minimum of 5 years in MySQL management., Exceptional knowledge of AWS RDS/AURORA., Deep SQL abilities required., Experience with high transaction workloads..
Key responsabilities:
Maintain AWS RDS/AURORA MySQL instances.
Troubleshoot performance issues and bottlenecks.
Report This Job
Help us maintain the quality of our job listings. If you find any issues with this job post, please let us know.
Select the reason you're reporting this job:
dLocal started with one goal – to close the payments innovation gap between global enterprise companies, and customers in emerging economies. We have over 900 payment methods, in more than 40 countries.
We are relentlessly focusing on serving our customers and solidifying our position as the preferred infrastructure solution for Global Merchants across Emerging Markets.
With the ability to accept local payment methods and facilitate cross-border fund settlement worldwide, our merchants reach billions of underserved consumers in the high-growth markets of Africa, Asia, and Latin America. dLocal offers the ideal payment solutions for global commerce:
Payins: Accept local payment methods
Payouts: Compliantly send funds cross-border
dLocal for Platforms: Unify your platform’s payment solution
Defense Suite: Manage fraud effectively
Unlock the power of emerging markets.
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 900+ 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
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
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?
Our Talent Acquisition team is invested in creating the best candidate experience possible, so don’t worry, you will definitely hear from us. We will review your CV and keep you posted by email at every step of the process!