Looking for a job

Elvis Aarón Medina Amezcua

@elvisaarnmedinaamezc

Message

Seasoned DBA specializing in MySQL with a focus on performance.

Mexico

Message

What I'm looking for

I seek a role that fosters innovation and offers opportunities for professional growth.

I am a seasoned Database Administrator with over a decade of experience managing high-performance systems that handle millions of transactions. My expertise lies in data security, performance tuning, and scalability, allowing me to tackle complex challenges and ensure uninterrupted operations. I thrive on continuous learning and am self-taught in various advanced database management techniques.

In my current role at Clickbalance, I manage and optimize production databases for an ERP system hosted on AWS, achieving significant improvements in reporting speed and replication efficiency. My previous experience as a System Development Manager at Coppel involved leading the development of payment collection systems across 1,300+ retail branches, where I implemented innovative solutions that enhanced database performance and scalability. I am passionate about leveraging technology to drive process improvements and am recognized for my proactive approach to problem-solving.

Experience

Work history, roles, and key accomplishments

Current

Database Administrator

Current

Clickbalance

Feb 2023 - Present (2 years 4 months)

Managed and optimized production databases (MySQL 5.7/8) for the Clickbalance ERP system hosted on AWS. Eliminated MySQL replication lag (from 2+ hours to real-time) by implementing Multi-Threaded Slave (MTS) with 8 worker threads and transaction-group parallelism.

MySQL AWS ERP Systems Database Optimization Replication Performance Tuning

System Development Manager

Coppel

Aug 2013 - Aug 2021 (8 years)

Led the development and maintenance of payment collection systems for 1,300+ retail branches. Optimized database performance for the “Collection Listings” application by identifying slow queries and creating missing indexes, enabling its scalability from 4 cities to over 25 branches nationwide.

Rsync SQL MySQL PostgreSQL Distributed Systems

Database Administrator

Homex

Aug 2009 - Mar 2013 (3 years 7 months)

Managed the Production database of the customer prospecting engine (MySQL 5.6). Automated Infonavit mortgage pre-qualification by developing a multi-threaded php cURL scraper to fetch housing sub-account data in seconds.

Database Administration MySQL LAMP PHP CURL Automation Open Source Technologies Performance Optimization

Education

Degrees, certifications, and relevant coursework

UNIR México

Master's Degree in Website Management and Engineering, Website Management and Engineering

Pursued a Master's Degree focusing on website management and engineering principles. Gained advanced knowledge in web technologies and project management.

Instituto Tecnológico de Culiacán

Bachelor's Degree in Computer Science, Computer Science

Completed a Bachelor's Degree in Computer Science, building a foundational understanding of computing principles. Developed skills in various aspects of computer science.