Angel P.

DATABASE ADMINISTRATOR

490 dollar

My experience

More

NearsoftNovember 2018 - Present

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, Versio, Slack

FreelanceJanuary 2017 - Present

More

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, Versio, Confluence, SentryOne Plan, Docker, VirtualBox
More

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
More

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
More

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
More

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
More

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
More

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
More

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.

My stack

XML, Windows Server, Web development, Visual Studio, VirtualBox, Virtual Box, VersionOne, VBA, Troubleshooting, TeamViewer, T-SQL, Sybase, SSRS, SSIS, SSAS, SQL Server Reporting Services, SQL Server Integration Services, SQL Server, SQL Developer, SQL, Slack, Shell, Scrum, RBAC, Project Management, PostgreSQL, Oracle 11g, NoSQL, MySQL, MongoDB, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server, Microsoft Excel, Kanban, JSON, jQuery, Jira, JavaScript, Java, HTML, GitLab, FlyWay, ETL, DevOps, Debugging, DB2, Database Engine Tuning Advisor, Database Design, Database and SQL tuning, Database Administration, Data Migration, Confluence, C++, Bitbucket, Azure, Analysis