Mon expérience

Voir plus

NearsoftNovember 2018 - Présent

ACTIVITIES:
✓ SQL Database Operational support to tech users
✓ Implementing operational automation
✓ SQL Development ability to write and troubleshoot SQL Code and design
TOOLS:
MySQL 5.7, DataGrip, SCRUM, DevOps, GitLab, VersionOne, Slack

FreelanceJanuary 2017 - Présent

Voir plus

WebPTNovember 2018 - May 2019

✓ Worked as SQL Developer using different DBMS like MySQL, SQL Server, Vertica
✓ Stored procedures development
✓ Data mapping
✓ ETL process development
✓ Shell scripting
✓ Unit testing
✓ Database reverse engineering to create ER diagrams
✓ Query tuning

Technologies
✓ SQL Server 2017, MySQL, Vertica, SSMS, DataGrip, SCRUM, Git, VersionOne, Confluence, SentryOne Plan, Docker, VirtualBox
Voir plus

Deintec | NEORIS/CEMEXFebruary 2018 - November 2018

ACTIVITIES:
✓ DBA
✓ SQL Database Operational support to tech users
✓ Troubleshooting and resolving problems
✓ Debug
✓ Implementing operational automation
✓ SQL Development ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
TOOLS:
Azure SQL, SSDT, Visual Studio, SCRUM, DevOps, Bitbucket, Jira, Confluence, HipChap
Voir plus

NeoDatus | NatureSweetDecember 2016 - February 2018

ACTIVITIES:
✓ DBA
✓ SQL Database Operational support to tech users
✓ Installation and patching of SQL Server (2005,2008,2008R2,2012,2016)
✓ Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues,
connectivity issues, security issues etc
✓ Debug
✓ Database migrations, up-gradation and patching || SSIS || SSRS
✓ Implementing operational automation
✓ Backups, restores, recovery models, database shrink operations
✓ SQL Development ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
TOOLS:
SQL Server 2008 | 2012 | 2014 | 2016, remote desktop, Windows Server, SSIS, SSRS, SSAS, SSDT, Visual Studio, Microsoft Teams, KanbanFlow
Voir plus

Eslabón SystemJuly 2015 - September 2016

ACTIVITIES:
✓ DBA
✓ SQL Database Operational support to tech users
✓ Installation and patching of SQL Server (2005,2008,2008R2,2012)
✓ Database design
✓ Database migrations, up-gradation and patching || SSIS || SSRS
MongoDB:
Mongo Shell || JSON || CRUD || Import & Export data || Performance || Replication || Security || Backup & Restore || Monitoring || Install & Upgrade
TOOLS:
SQL Server 2008 | 2012 | 2014, Oracle 11g | 12c, MySQL, MongoDB 2.6 | 3.0 | 3.2, SCRUM, JSON, Visual Paradigm, Flyway, Remote desktop, Windows Server 2012, TeamViewer, VirtualBox
Voir plus

Financiera CoincidirAugust 2014 - July 2015

✓ Information Analysis.
✓ Database Design.
✓ Database Mapping.
✓ Debug Stored Procedures
✓ Queries Optimization (performance)
✓ Execute Plans
✓ Store Procedures, Triggers, Functions, Index, Views, Users.
✓ Automate Excel processes (macros).
✓ Reverse Engineering.
✓ Programmation C#
✓ Make new processes following policies

Tools: SyBase (ASE), SQL Server 2008, Macros Excel, PowerPivot for Excel, Evernote, Visual Studio 2012, TeamViewer, VirtualBox, Outlook
Voir plus

MBGE Intersistemas, S.A. de C.V.November 2012 - August 2014

✓ Information Analysis.
✓ Database Reconstruction.
✓ Migrate Databases, Different Managers (MySQL to SQL Server, Access to SQL Server, Excel to SQL Server, Oracle SQL Server) and vice versa.
✓ Database Design.
✓ Database Mapping.
✓ Create Store Procedures, Triggers, Functions, Index, Views, Users.
✓ Automate Excel Processes (macros).
✓ Manage Projects.
✓ Remote Assistance.
✓ Consultancy Face to Face.
✓ Reverse Engineering.

Tools: SQL Server 2005 | 2008 | 2012, Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Developer Oracle, MySQL Workbench, Access, Macros Excel, PowerPivot for Excel, MS Project, ZoHo Project, Evernote, MS Visio, TeamViewer, GoToMeeting, Skype, VirtualBox, AranXel Professional and Standard. InterXel3, FileZilla
Voir plus

Caja Popular San RafaelAugust 2011 - November 2012

✓ Information Analysis.
✓ Develop New Web Page
✓ Develop Application for Printing Constancies (Java).
✓ Implant Moodle.
✓ Training.
✓ Moodle Administration.
✓ Web Page Administration
✓ Creating Modules.
✓ Create Store Procedures, Triggers, Functions, Index, Views, Users.
✓ Automate Excel Processes(macros).
✓ Database Mapping.
✓ Reverse Engineering.

Tools: MySQL Workbench, Access, Macros Excel, MS Project, MS Visio, VirtualBox, FileZilla, CPanel, Joomla, Moodle, Java, HTML, HTML5, CSS, CSS3, JavaScript, PHP, IDE Eclipse, Hosting, MS Visio
Voir plus

Sanmina-SCINovember 2010 - March 2011

* PC Format | Laptops
* PC Configuration and Repair | Laptops.
* Users Attention.
* Software | Hardware Installation.
* Preventive Maintenance | Corrective.
* Privileges to users.    
* Remove Viruses.
* Structured Cabling.
* Remote Assistance.

Mes compétences

Environment of Development

Visual Studio, GitLab, SQL Developer

Protocols

RBAC, JSON

Languages

JavaScript, T-SQL, SQL, XML, VBA, HTML, Shell, C++, Java

Frameworks

jQuery

Technologies

Web development

Computer Tools

Microsoft Excel

Analysis methods and tools

Scrum, Kanban, DevOps, Confluence, JIRA

Other

Visual Basic for Applications, Microsoft Access, Microsoft C-SHARP, Microsoft Visual Studio, Microsoft Windows, English, Cascading Style Sheets, DataGrip, SSAS, DBA, Scrum Methodology, Microsoft Transact-SQL, MS-SQLServer 2008r2, Benchmarking, Access, Relational Database, Database, Microsoft Windows Server 2012, Microsoft SQL Server 2008, SQL Server Analysis Services

IT Infrastructure

Virtual Box, Azure, Windows Server

Databases

Microsoft SQL Server, SQL Server, NoSQL, Oracle 11g, inMemory SQL Database, PostGreSQL, FlyWay, DB2, Database and SQL tuning, Database Administration, Microsoft SQL Server 2005, Database Engine Tuning Advisor, MongoDB, MySQL, Sybase

Business Intelligence

SSRS, SSIS, ETL, SQL Server Integration Services, SQL Server Reporting Services

Software testing

Debugging

Others

Slack, Analysis, Bitbucket, Data Migration, TeamViewer, Database Design, Troubleshooting, VirtualBox, Project Management, VersionOne

Mes études et formations

SQL Server Integration Services - Lynda.com

Ing. Information and Communication Technologies, Data Modeling and Storage / Database Administration - Jalisco University of Technology2013 - 2014