Developer Sql Server

PROFESSIONAL EXPERIENCE

C*ntro Telecom.

February 2013 – Present.

Dutties:

Creation of models E –R, using MySQL Workbench.

Creation of databases.

Installation of instances of mysql in enviroment Linux

Migration from an old MySQL version to new MySQL version.

Creation of triggers, stored procedures, functions and event schedule

.Creation of users inside of MySQL Database

Granting and revoking privileges from users

Monitoring performance of database servers

Making benchmarking and profiling to watch behavior of database servers.

Tunning queries through adding indexes into MySQL tables

Configuration of my.cnf file.

Developing infraestructure High Availability through MySQL Replication, Innodb Cluster and Percona Xtradb cluster

Using pt-tools to administer MySQL Databases.

Technologies used: MySQL, MySQL Workbench,Moodle, pmm-admin,mysql-tools,pt-tools, MySQL Innodb Cluster, Percona Xtradbcluster

Escuela de Enfermería Helen Keller.

February 2013 –February 2017

Dutties:

Creation from the database.

Installation from Moodle on this LAMP enviroment.

Installation of MySQL.

Creation of triggers, stored procedures and task Schedule inside of MySQL Database

Modification from Moodle for especifically own functions from the school.

Developing of a chat to interaction student-

Configuration of Apache using VirtualHost.

Technologies used: MySQL, MySQL Workbench,Moodle, PHP, HTML5,CSS3, Bootstrap,Komodo Edit,Linux y Apache

UNACH (Dirección de Formación e Investigación Educativa).

August 2011 – Septiembre 2017..

Dutties:

Creation of models E –R, using MySQL Workbench.

Installation of LAMP enviroment.

Configuration of Apache, creating a VirtualHost.

Creation of database, users, privileges, tables, primary and foreign keys

Creation of indexes, triggers, stored procedure and task schedules inside of MySQL database

Configuration from my.cnf file for a high performance from the database server.

Migration from Mysql to Oracle .

Developing systems with PHP language

Layout of my webpage with HTML5 and CSS3

Responsive Design with Bootstrap

Technologies used: PHP, HTML5, CSS3, Linux, MySQL, MySQL Workbench,UML, Umbrello, Bootstrap, JQuery, Komodo Edit, Oracle, SQL Developer, Linux y Apache.

UNACH (Coordinación de Tecnologías de la Información).

January 2009– August 2011.

Dutties:

Creation of models E –R, using MySQL Workbench.

Creation of database, users,privileges, tables, primary and foreign keys.

Creation of indexes, triggers, stored procedures and task schedule inside of MySQL database .

Configuration from my.cnf file for a high performance from the database server..

Developing systems with PHP language.

Layout with HTML5 and CSS2.

Monitoring performance from database server

Technologies used: PHP, XHTML,CSS2,MySQL,MySQL Workbench,Komodo Edit,Umbrello,Linux, Herramientas de consola

ACADEMIC TRAINING

Universitat Oberta de Cataluña.

March 2017.-September 2017

Specialty in Big Data and NoSQL

Titled

Colegio de Posgrado en Desarrollo de Software.

2009 – 2011.

Master in Development of Software

Titulado.

Universidad Autónoma de Chiapas.

2003 – 2007.

Bachelor in computer systems.

Titulado.

TECHNICAL SKILLS

Lenguajes de Programación / Scripts:

ASP .NET

C

C#

C++

CSS

HTML 4

HTML 5

JavaScript

PHP

PL/SQL

SQL

Transact-SQL

Python

Frameworks / Librerías:

AJAX

Bootstrap

CakePHP

JQuery

JSON

Bases de Datos:

Microsoft SQL Server

SQL Server Profiler

SQL Server Management Studio

MySQL

Oracle Database

SQL Developer

MongoDB

Hadoop

Spark

Ambientes de Desarrollo (IDE):

ActiveState Komodo

Visual Studio

Patrones de Diseño:

MVC

Patrones de Arquitectura:

Programación por Capas

3-Niveles

Modelo Vista Controlador (MVC)

Administrador de Contenidos / Plantillas:

Joomla!

Wordpress

Moodle

Metodologías / Modelos de Calidad:

Agile Software Development

UML

Sistemas Operativos:

LINUX

Windows NT3/NT4/2000

Windows 3x/9x

Protocolos / Plataformas de Comunicación:

TCP / IP

UDP

HTTP

POP3

IMAP

REST

SOAP

LANGUAGES

English: Intermediate level.

Contact this candidate