Experience

MSP Recovery

• United States
• Software Development
• 1 - 100 Employee

• Amazon Redshift Administrator and ETL Developer, Business Intelligence

  • Feb 2018 - Present

  Maintain multiple database environments (Redshift, RDS) in AWS. User management and group in Redshift. Design and Developed ETL jobs to extract data from RDS and load it in Redshift (Matillion ETL and python script). Experience working within the AWS Big Data Ecosystem (S3, RDS, and Redshift). Expertise in development of various reports and prepare the data for the utilization with tableau. Expertise Query Tuning and Performance optimization and Implementing Work Load management. Managing Amazon Redshift Snapshots using the console. Show less



FREELANCER

• Software Development
• 1 - 100 Employee

• Database Administrator

  • Jan 2016 - Dec 2017

  • Performance and Maintenance SQL Server and PostgreSql Database. • Designed of Conceptual Logical Model and Physical Model • Consultant at SQL Server PostgreSql. • Performance and Maintenance SQL Server and PostgreSql Database. • Designed of Conceptual Logical Model and Physical Model • Consultant at SQL Server PostgreSql.



CEAACES Consejo de Evaluación, Acreeditación y Aseguramiento de la Calidad de la Educación Superior

• Database Administrator

  • Nov 2014 - Dec 2015

  • Designed of Conceptual Logical Model and Physical Model. • Implemented, supported and managed the database. • Kept data integrity and availability. • Designed, deployed and monitored database servers. • Managed user administration • Migrated different databases in SQL Management, PostgreSql and Oracle • Migrated and created new database structures, such as tables, indexes and stored procedures from development to the production environment. • Created and tuned query, stored procedures, triggers, views and added/changed tables for data load and transformation, and data extraction. • Created backup and restored strategy of production, development and test environments. • Executed recovery databases and created the documentation to provide the disaster recovery processes. Show less



CEIGE Centro para la Informatización de Entidades

• Database Administrator

  • Sep 2007 - Oct 2014

  • Produced entity relationship & data flow diagrams, database normalization schemata logical to physical database maps, and data table parameters. • Installed and managed Database Server • Created and monitored user accounts, user permissions, database extents and table partitions. • Implemented robust backup and recovery procedures based on data volatility and application availability requirements • Monitored and optimized system performance using index tuning, disk optimization, and other methods. • Monitored the size of the transaction log. Managed databases on multiple disks using Disk Mirroring technology. • Collected, stored, managed, and enabled the ability to query the organization's metadata. • Ensured data availability using administration tactics • Designed, debugged, implemented, and maintained stored procedures, triggers, and user-defined functions that are stored in the DBMS Show less