Leonardo Guerrero G. Email & Phone Number

Oracle DBA• Database Server Administration• Review, detection and correction errors• Control, management of incidents & problems• Performance review on RAC servers• Execution and script review ( performance analyze )• Assignment of permissions• Migration of servers• Data import and export• Backup and restore• Monitoring and check Configuration in Cloud ControlSQL Server, Senior DBA• Administration and configuration of stand alone and cluster database servers.• Review detection and correction of errors• Optimization and Tuning• Control and management of incidents and problems• Management and review of SQL script• Installation of SQL Servers versions 2008, 2012, 2014, 2019• Server performance improvement• Installation and Review High availability cluster, Mirroring, Always on• SQL Server Reporting servers• Management of capacity planning servers, memory, disk, cpu.Mysql / MariaDB• Installation and configuration• Database maintenance. • Backup and restore• Migration and update of versions• HA implementation. Mysql Cluster and Master-Slave Replication• User administrationMongoDB On premise / Atlas• Installation and configuration• Database maintenance. • Backup and restore• HA implementation. Cluster• User & security control• Optimizing

Santiago, Región Metropolitana De Santiago, Chile

Oracle DBA• Database Server Administration• Review, detection and correction errors• Control, management of incidents & problems• Performance review on RAC servers• Execution and script review ( performance analyze )• Assignment of permissions• Migration of servers• Data import and export• Backups and restore• Monitoring and check Configuration in Cloud ControlSQL Server, Senior DBA• Administration and configuration of stand alone and cluster database servers.• Review detection and correction of errors• Optimization and Tuning• Control and management of incidents and problems• Management and review of SQL script• Installation of SQL Servers versions 2008, 2012, 2014, 2019• Server performance improvement• Installation and Review High availability cluster, Mirroring, Always on• SQL Server Reporting servers• Management of capacity planning servers, memory, disk, cpu.Mysql / MariaDB• Installation and configuration• Database maintenance. • Backup and restore databases• Migration and upgrade version• HA implementation. Mysql Cluster and Master-Slave Replication• User administration

Provincia De Santiago, Chile

AQL Server, Senior DBA• Administration and configuration, stand alone and cluster database servers.• Review detection and correction errors• Optimization and Tuning• Management and optimizing SQL queries• Installation of SQL Servers versions 2005, 2008, 2012, 2014• Development alarms for monitoring SQL Servers.• Handling recover information tools in Databases.• Server performance improvement• Cluster Installation and Review• Review of problems and correction of cluster and failover• SQL Server Reporting servers• Management of capacity planning servers, memory, disk, cpu.: Oracle Database Administrator• Installation DB Oracle 10, 11, 12 and configuration under Linux platforms, HPUX• Database Server Administration• Review, detection and correction errors• Control and management of incidents & problems• Check performance review in Stand Alone and RAC servers.• Script execution and review• Implementation of Server Monitoring under• Assignment of permissions• Migration of servers and data• Data import and export• Backups and restores• Review and configuration of Golden Gate• Review and configuration of Dataguard• Review, Monitoring Configuration in Cloud Control• Creation of specific profiles for Cloud Control monitor ( 12c)

Oracle 10g, 11g, 12c - Informix 11.7 - DBA - Linux, AIX, HPUX- Oracle versions 10, 11g, 12c- Installation and configuration process- Migration Proyects- Oracle RAC - Monitoring - Performance- Backups. SQL Server DBA, senior- Installation, configuration and upgrading of Microsoft SQL Server server software and related products.- Improve process, script, and Tunning- Evaluate MSSQL Server features and related products.- Establish and maintain backup and recovery policies and procedures.- Take care of the Database design and implementation.- Implement and maintain database security (create and maintain users and roles, assign privileges).- Database tuning and performance monitoring. Developing special report- Setup and maintain documentation and standards.- Plan growth and changes (capacity planning).- Do general technical trouble shooting and give consultation to development teams.- ITIL Skill ( Related with Problem Management - Incident Management - Change Management, etc)- Manage and process BI, OLAP and SSIS servers.- Clustering - SQL Server Reporting Server 2005 - 2008 - 2008R2 - Migration Proyects

Paseo Av. Bulnes 147 Piso 8 Santiago Centro, Santiago

- Installation, configuration and upgrading of Microsoft SQL Server server software and related products.- Evaluate MSSQL Server features and related products.- Establish and maintain backup and recovery policies and procedures.- Take care of the Database design and implementation.- Implement and maintain database security (create and maintain users and roles, assign privileges).- Database tuning and performance monitoring. Developing special report- Application tuning.- Setup and maintain documentation and standards.- Plan growth and changes (capacity planning).- Do general technical trouble shooting and give consultation to development teams.- Interface with MySQL/Oracle/AS400 for technical support.- ITIL Skill ( Related with Problem Management - Incident Management - Change Management, etc)

Engineer, Computer

Engineer, Industrial

Postgraduate, Software Engineering Specialization