Miguel Emanuel Martinez Villavicencio
About
Detail
DBA MSSQL
Pachuca, Hidalgo, Mexico
Contact Miguel regarding:
Flexible work
Timeline
work
Job
school
Education
Résumé
Jobs
verified_user
0% verified
- EFreelancerEnginering Cervantes S.A de C.VJan 2024 - Current (1 year 5 months)• Creating new ID Databases and applied proper changes. Applying patching on the Given permissions access Applying Failover in Database Refresh table refresh different Jobs. Decommissioning databases. new databases using dictionary, Entity-relationship diagrams, Troubleshooting. Creating Views, Stored Procedures and Triggers.
- TDatabase AdministratorTata Consulting Services CDMX,Aug 2022 - Jan 2024 (1 year 6 months)• Daily Status Report. • Attendance of tickets in environments of Development, Test, Stage and Production. • Execution of queries, plans of maintenance, creation of database, tables, SP, application of shrink, checks backups. • Install SQL Server and refresh of databases. • Give permission to the users • Check blockings, performance and drives on the server. • Check problems with always on and mirroring. • Scheduling jobs. • Deploy packages in SQL Server. • The company that I was working with Pfizer • Using Idera server to monitor the databases and servers.
System developerGrupo SalinasMar 2021 - Jul 2022 (1 year 5 months)- Desarrollo en SQL SERVER y Analysis Services, creación de queries, Strored Procedures, triggers, extracción de información y minerÃa de datos, creaciones de cubos de información. - Creación de bases de datos relacionales y de estrella, normalización de tablas, diccionario de datos. - Despliegue bases de datos para desarrollo y de producción y uso de la herramienta Visual Business Intelligence para creación de métricas, catálogos y dimensiones.- GDatabase Administrator and System DeveloperGrupo Salinas CDMX,Mar 2021 - Jul 2022 (1 year 5 months)• Development in SQL Server and Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services • (SSRS). • Using the tool Jira for activities during the day. • Daily Status Report. • Query automation. • Creating information cubes. • Developing ETL and Data Warehouse with tool Informatica. • Creating metrics, catalogs, dimensions. • Generate business reports. • Creating instances and Virtual Machines in Google Cloud Platform (GCP). • Giving permissions in IAM portal. • Validate the domain of the devices. • Granted permissions to the users and roles. • Creating Job backups. • Lindked servers. • Created monthly maintenance to check the database and performance. • Using Idera server to monitor the databases. • Us
- IDatabase development professionalInstituto Nacional Electoral INEMar 2020 - Mar 2021 (1 year 1 month)- Diseño de estructura de base de datos y desarrollo de programas para explotar y cargar información basada en los requerimientos por el usuario del área. - Migración de base de datos Oracle a MYSQL en la nube en AWS trabajando con RDS, normalización de tablas, creación de triggers y diccionario de datos. - simulación de grandes cargas de información y explotación de datos y uso de Azure para crear instancias en VM's.
- IArchitect Development ProfessionalInstituto Nacional Electoral CDMX,Mar 2020 - Mar 2021 (1 year 1 month)• Design the structures of the databases, and develop programs for loading and exploiting information with Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS). • Based on the requirements requested by the user area to meet their needs and expectations, and also provide support to the information systems. • Daily Status Report. • Migration Oracle Database to MYSQL in AWS (RDS). • Create SQL Server instances in Azure in a VM's. • Creating the database tables, indexes, Stored Procedures, data dictionary and flowcharts. • Functional tests and performance tests.
- GDatabase administratorGrupo Enlace S.AAug 2018 - Feb 2020 (1 year 7 months)- Generación de queries para extracción de información, administración de servidores y bases de datos, restauración de bases de datos, métodos de recuperación en SQL SERVER. - Actualización de ambientes de desarrollo y producción, migración de servidores Windows, hardening, monitoreo de servidores, bases de datos y de aplicaciones de desarrollo y producción.
- GDatabase administrator Agus.Grupo Enlace CDMX,Feb 2018 - Jan 2020 (2 years)• Generation of queries for information extraction with Analysis Services (SSAS). • Data Mining. • Database administration in SQL Server 2016 and 2008. • Restoration and database backups. Server Management. • Update of development and production leagues. • Migration of servers, database managers and necessary configurations. • Use of the Monitis program to monitor production and development links, CPU behavior monitoring, RAM memory behavior monitoring and hard disk behavior monitoring on the server. • Creation of production and development leagues on servers. • Use of Excel to generate reports. • Creation of process OLTP with the tool SQL Server and keep the sales and payroll active. SQL SERVER, IIS, Servers 2008 2012, Excel, Mon
- Information analystGrupo VizionAug 2017 - Jul 2018 (1 year)- Actualización de las bases de datos en MYSQL y FoxPro, creación de indicadores de comportamiento de ventas y perdidas, análisis de 389 tiendas en la réplica mexicana, realizando mineria de datos, extracción y análisis.
- SSystem SQL developerSIES Sistemas EspecÃficosMar 2016 - Aug 2017 (1 year 6 months)- Desarrollo y documentacion en Java Netbeans del SPEI, monitoreo y soporte al usuario final, testeo del sistema en producción y desarrollo, desarrollo y creación de bases de datos en SQL SERVER y Oracle, pruebas de software.
- SInformation AnalystSIES Soluciones de Software CDMX,Mar 2016 - Aug 2017 (1 year 6 months)• Updating and feeding of MySQL and Fox Pro databases. • Creation of indicators and sales behavior. • Analysis of the missing, surplus, sale of the 389 Waldo's stores in the Mexican Republic. • Data mining, extraction and analysis and Data Warehouse.
Education
verified_user
0% verified
- UBachelor of sciencie of informatic, computer and information sciences and support servicesUnidad Profesional Interdisciplinaria de IngenierÃa y Ciencias Sociales y Administrativas.Jan 2012 - Aug 2016 (4 years 8 months)