About Myself

Over eight years experience as a Database Administrator and Development working with MySQL/MariaDB, five years working with MongoDB, two years with PostgreSQL, one year with Oracle Databases and MS SQL on multiply UNIX/Linux and Microsoft Server platforms with MS SQL 2012-2016. Over two years experience as a System Engineer working with multiply UNIX/Linux and Microsoft Server platforms, systems/network architecture, installation, implementation, integration, security and administration with a programming background on php/python. Two years experience of applying MicroServices with Docker and Kubernetes to the QA/UAT/Development environment. Free years working with reporting, creating KPI reports through procedures. Knowledge of Big Data structure like Hadoop, Hive, Pig Latin and NoSQL Database Cassandra.

11

Years of Mysql

16

Years of IT

5

Projects

89

Today views

1878

Total views

1

On site

After Effects 85%

MySQL 90%

Docker 50%

MSSQL 45%

PHP 70%

Python 50%

devOps 65%

  • March 2017 to present

    Colorlib

    Senior Web Developer
    Santa monica, Los angeles

  • March 2017 to present

    Colorlib

    Senior Web Developer
    Santa monica, Los angeles

  • March 2017 to present

    Colorlib

    Senior Web Developer
    Santa monica, Los angeles

My Expertise

MySQL

MySQL is the world's most popular open source database. With its proven performance, reliability, and ease-of-use

Business Analytics

is “the study of data through statistical and operations analysis, the formation of predictive models, application of optimization techniques.

Docker

is a container technology for Linux that allows a developer to package up an application with all of the parts it needs.

MariaDB

MariaDB, the most popular Open Source SQL database management system since MySQL acquisition by Oracle Corporation, is developed, distributed, and supported by community.

devOps

DevOps is the combination of cultural philosophies, practices, and tools that increases an organization's ability to deliver applications and services at high velocity.

MS SQL

MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. This product is built for the basic function of storing retrieving data as required by other applications. It can be run either on the same computer or on another across a network.

Positions

Managed Maintenance Inc

Database Engineer

November 2015 - Present

Normalize RDBMS; Participated in the development of new products; Creation of Data Warehouse (OLAP) with Triggers, Procedures, and ETL scripts; Support of ETL processes through bash and T-SQL language; Architect and administrate MySQL/MariaDB/MongoDB/MSSQL; Developing and supporting production, QA and development MySQL databases; Responsible monitoring and optimizing database performance and capacity planning; Importing/Exporting data from and to xml/csv/txt/tsv files with and without ETL; Trace the slow running queries and optimize SQL queries for improved performance and availability; Managing server instances (AWS RDS), disaster recovery, replication and cluster; Developing and supporting database replication and clustering, and plan and execute for database scalability; Working with application engineers, developers and the QA team as well as applications support teams in the maintenance and care of the Linux Network and Database infrastructure; Applying Docker/Containerization technologies; Supporting Redis; Supporting Business with Data Analytics queries;

LiveIntent Inc

MySQL DBA/Developer

Participated in the development of new product; Analyzing current environment & languageing workable in-house solutions; Understand core systems and data processes for normalization, data validation, data aggregation, and customized reporting and migrations to the new product; Identifying & building tools to assist in database and transactional processing (i.e. Store Procedures, Triggers, etc.); Worked on language and development of Relational Database Management System (RDBMS) and reduce the redundancy by data normalization. Migrated high-volume fields from MySQL to the Elasticsearch in order to get easy access and high speed users search; Traces the slow running queries and optimize SQL queries for improved performance and availability; Managing MySQL servers instances (AWS), disaster recovery and replication; Creating Data Warehouse with Triggers, Procedures and ETL; Creating Data Marts through views for different departments

MySQL

Most popular

MS SQL

Microsoft SQL Server

MariaDB

Open Source RDBMS

Percona DB

Most Stable DB

AuroraDB

Amazon RDBMS

MongoDB

Most popular NO SQL

Cassandra

Apache Cassandra DB

HBASE

Couchbase

distributed multi-model NoSQL document-oriented database

Redis

Cache server

PHP

Web language

Python

High-level programming language

T-SQL

Language of SQL

Git

Version Control

Jenkins

Automation server

Maven

software project management

Docker

Container Platform

Kubernetes

Container Scheduling and Management

Nagios

IT Infrastructure Monitoring

Selenium

Automates Browsers

Puppet

Configuration managment tools

Ansible

Simple IT Automation

Load More Items

Recommendations

Recommendations from my college

Alex is a wonderful DBA person to work with. Alex is a good team player , he helps with in case anyone has problems with any DB issues. He is a very Jovial person and never hesitates to helps the teams achieve their deadlines.

Sreedevi Seetharam

Alex is a dedicated teammate. Always willing to go the extra mile to get projects completed. He has always gone above and beyond the job, and is very knowledgeable in the data and DBA space. Alex was a pleasure to work with, and a great addition to the team.

Matt Edick

Alex is a great versatile Database Architect. Highly recommended that is always looking for the best and fastest solution to have a maintainable database for applications in any company.

Hector Martinez