Work History

Work History
Jun 2015 - Present

SR. SQL Server DBA

Actinver

Administration, configuration and maintenance of production databases, implementing the appropriate security to production databases, upgrading SQL versions, creation of DRP, Capacity planning, and Change request processes. Administration, monitoring and tuning of BI processes. Normalization of databases.

Dec 2014 - Apr 2015

SQL Server DBA

Praxis for AON

Administration, configuration and maintenance of production databases, implementing the appropriate security to production databases, upgrading SQL versions, creation of DRP, Capacity planning, and Change request processes. Administration, monitoring and tuning of BI processes. Normalization of databases. 1 recommendation available upon request

Oct 2014 - Dec 2014

Project Leader

Asignet
Project Leader at (3 months)
Nov 2011 - May 2014

Database Administrator Manager

Royal Holiday

Database development, migration of queries, stored procedures, triggers, functions from Oracle to SQL Server, assure the recovery, availability and well performance of the productive databases, give the appropriate security to productive databases, recommend and supervise best practices on the developmentarea, participate on the design, improvement and implementation of new and existing processes.

Jul 2011 - Oct 2011

Technology Specialist

DCH for Microsoft Mexico

Giving Support to Dynamics AX partners by giving them solutions to any technical issue that presents on the Dynamics AX environment(Microsoft SQL Server, Microsoft Windows Server, TSQL, etc.)

Mar 2011 - Jun 2011

Production Database Administrator

Consupago

Assure the recovery, availability and well performance of the productive databases, review the security of productive databases, recommend best practices on the development area, participate on the design, improvement and implementation of new and existing processes.

Jun 2010 - Mar 2011

Production Database Administrator

PagaTodo Holdings SAPI de C.V.

Assure the recovery, availability and well performance of the productive databases, give the appropriate security to productive databases, recommend and supervise best practices on the development area, participate on the design, improvement and implementation of new and existing processes.

May 2010 - Jun 2010

Infrastructure and database administrator

THSD

Maintenance and administration of servers, creation of capacity planning reports, disaster recovery and backup plans for application, web and database servers. Installation, configuration and administration of SQL Servers and Windows Servers.

Sep 2009 - Dec 2009

Database Administrator

StrategySys Consulting

 Development of queries and stored procedures for the creation of reports on Reporting Services, creation of SSIS for massive data loading, Creation and assigning roles and privileges to users depending on their activity. Importing and saving HL7 XML files on databases.

May 2009 - Sep 2009

Database Administrator

Brendcar

Migration and upgrading from SQL 2000 to SQL 2005 and SQL 2008, creation of complex queries, stored procedures, triggers for reports, implementation of maintenance plans on productive databases, import and export of data using DTS and SSIS, creation of capacity planning for an effective space management.

Aug 2008 - May 2009

Database Administrator

Actinver

Administration, configuration and maintenance of production databases, implementing the appropriate security to production databases, upgrading SQL versions from SQL 2000 to SQL 2005 and 2008, creation of DRP, Capacity planning, and Change request processes. Administration, monitoring and tuning of BI processes for the Operational data Store. 

Jan 2008 - Aug 2008

Database Administrator

Dextra

Normalization of databases, creation of projects for the upgrade of SQL Server 2000 to SQL Server 2005,  creation of complex queries, stored procedures, triggers, jobs.  Database tuning.

Feb 2007 - Oct 2007

Software Engineer

Softtek

Maintenance and support to the Data warehouse Operational Data Store (ODS), Enterprise Data Store (EDS) and datamarts;  administration and database tuning, creation and implementation of Data Transformation Services for the extraction, cleaning and load of  information to the data warehouse EDS and ODS.  Importing and exporting data using DTS and complex queries or stored procedures for reporting purposes. Monitoring of EDS and ODS servers performance.

Oct 2006 - Dec 2006

Support Engineer

Siscon S.A. de C.V.

Database administration, analysis of information to create complex queries, stored procedures or DTS for reports, importing and exporting data, creation of database maintenance and backup plans.  Provided second level support to users.

Apr 2006 - Oct 2006

Software Development Engineer

Nekotec Tecnología S.A. de C.V.

Optimization of queries for reports in Crystal Reports, creation and implementation of new reports, creation of new queries and stored procedures.  Migration of reports on Crystal Reports to Reporting Services.  Installation and configuration of SQL Server 2000.

Sep 2004 - Sep 2005

CTI

Telemark Corporation 

User administration, creation of reports of IVR’s, creation of queries for  data analysis and report  validation, analysis of client requirements to create use cases and process data flows by using UML

Mar 2004 - Jul 2004

Process Analyst

Pagoss

Creation and improvement of Data Flow Diagrams, use cases, Entity relation Diagrams using Rational Rose, establishment of work level estimates, creation of layouts on XML, creation of tables on SQL 2000.

Oct 2002 - Nov 2003

Support Operator

Servicios Administrativos de Wal-Mart S. de R.L. de C.V.

Administration of the Retail Link system, user administration for the Retail Link Access control, creation of bilingual manuals and guidelines of the reports used by Retail Link.

Certifications

Certifications
Jul 2013

SQL Server 2008, Business Intelligence Development and Maintenance

Microsoft

Microsoft® Certified Technology Specialist

Jul 2013

SQL Server 2008

Microsoft

Microsoft® Certified Solutions Associate

Mar 2012

Database Developer 2008

Microsoft

Microsoft® Certified IT Professional

Dec 2011

Database Administrator 2008

Microsoft

Microsoft® Certified IT Professional

Nov 2011

SQL Server 2008, Database Development

Microsoft

Microsoft® Certified Technology Specialist

Jun 2011

SQL Server 2008, Implementation and Maintenance

Microsoft

Microsoft® Certified Technology Specialist

Feb 2009

Microsoft Certified Professional

Microsoft

Installing, Configuring, and Administering Microsoft SQL Server™ 2000 Enterprise
Edition

Designing and Implementing Databases with Microsoft SQL Server™ 2000
Enterprise Edition

Education

Education
2000 - 2003

Bachelor  Computer Science

Centro Universitario Grupo Sol

Skills

Skills

Professional Skills 

Database and Data Management
Database Design –Modeling
Database Administration/Operation
Database Programming
Requirements Specifications
Deployment
Maintenance Planning
Test Planning
Datawarehouse: Data Extraction and Transformation
Datawarehouse: Data Cleansing
Datawarehouse: Data Load
Datawarehouse: Security
Datawarehouse:Backup and Recovery
Datawarehouse: Performance Monitoring
Datawarehouse: Database Management