# Elvis Aarón Medina Amezcua

Elvis Aarón Medina Amezcua is a remote worker on Himalayas, Database Administrator at Clickbalance, based in Mexico.

Source: https://himalayas.app/@elvisaarnmedinaamezc

```text
Seasoned DBA specializing in MySQL with a focus on performance.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Mexico |
| Authorized to work in | Mexico |
| Job categories | Database Architect, Database Architect |
| Skills | Percona Toolkit, Performance Optimization, Linux Administrator, MySQL, Database Administration, Data Security, Backup, SQL, Query Optimization, AWS, Automation, Percona, PHP, Windows, Toolkit, PostgreSQL, Linux |

## What I'm looking for

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

## About

```text
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

### Database Administrator (current)

Clickbalance. Feb 2023 - Present

```text
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.
```

Skills: Performance-Optimization, ERP, MySQL, AWS, Database-Optimization, Replication

### System Development Manager

Coppel. Aug 2013 - Aug 2021

```text
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.
```

Skills: Rsync, SQL, MySQL, PostgreSQL, Distributed-Systems

### Database Administrator

Homex. Aug 2009 - Mar 2013

```text
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.
```

Skills: Database-Administration, MySQL, LAMP, PHP, CURL, Automation, Open-Source-Technologies, Performance-Optimization

## Education

### UNIR México

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

```text
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

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

## Tech stack

- MySQL
- PostgreSQL
- Percona
- Gmail
- PHP
- Linux
- Windows
- Toolkit
- SQL

To contact Elvis Aarón, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [David Holoboff](https://himalayas.app/@mysqldba): Database Administrator, Pason Systems Corp
- [Laura Morales](https://himalayas.app/@lauramorales1): Senior Database Administrator, Intuit
- [lizet sharai ortega ramirez](https://himalayas.app/@lizetsharaiortegaram): SQL Server DBA, Ivy Mobility Company
- [Rodrigo Cunille](https://himalayas.app/@rodrigocunille): Senior PL/SQL Developer, Luxoft
- [Marco Antonio Ramirez](https://himalayas.app/@marcoantonioramirez): Multicloud Database Architect, Mobility ADO
- [Tania Lugo García](https://himalayas.app/@tanialugogarcia): Oracle Cloud DBA, SQL Server DBA, ASTECI, S.A. de C.V.
- [Gerardo Fontes](https://himalayas.app/@gerardofontes): Tech Ops L2 Support Engineer, Cars.com
- [Ulises Félix Alarcón Hernández](https://himalayas.app/@ulisesflixalarcnhern): Coordinador de Soporte TI, Bancoppel
- [Ulises Rosales](https://himalayas.app/@ulisesrosales): DWH Developer, UST Global Mexico / RGA
- [Mario dali Chavarría bravo](https://himalayas.app/@MarioDali): Database Administrator, Intermex (via Boz IT)
