Mario Chaves Rojas

Associate Site Reliability Engineer at Cheetah Digital
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Costa Rica, CR

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Software Development
    • 300 - 400 Employee
    • Associate Site Reliability Engineer
      • Jun 2018 - Present

      Main Daily Tasks: - Follow proper SOPs procedure to resolve an alert. - Ensure all alerts are acknowledged and resolved. - Implement new alerts to meet business requirements in a timely manner. - Find ways to improve thresholds and reduce alerts when necessary. - Evaluate efforts to find ways to automate SOPs to eliminate manual efforts. - Reduce volume of alerts by PM techniques. - Whenever there is a release activity monitor and report any abnormal behavior during and after it. Main Responsibilities: - In charge of ensuring the 24x7 availability and responsiveness of the Marketing Suite & CheetahMail products. - Manage application alerts to resolution. - Primary or secondary tier in alert response and follow-up. - Ensure effective communication to operational teams and business stakeholders such as DB, DevOps, Systems, Support, etc. - Implement visualizations and alerts for defined metrics to quickly raise issues and drive to remedy. - Improve documentation all around, either in application documentation, or in runbooks, explaining the why, not stopping with the what. - Responsible for troubleshooting system, application, database, and networking level issues and alerts. - Identify, escalate, and participate in production incidents, outages, and performance degradation issues with appropriate teams to ensure resolution. - Proactively report on current systems, database, and application checks to improve performance and notifications. - Use monitoring tools such as Shinken, BigPanda, SolarWinds, etc. to determine performance or system issues. - Implement new application alerts for technology and business stakeholders across several tools. - Responsible for writing scripts to help automate task resolution. - Evaluate and build improvements in monitoring capabilities. - Eliminate new alerts being implemented for new defects created in the application. - Support releases and maintenances. Show less

    • Costa Rica
    • Software Development
    • 1 - 100 Employee
    • Business Analyst and Senior Systems Analyst
      • Dec 2015 - Nov 2017

      For 5 months: At the Risk Department at Beto Te presta, as Business Analyst, preparing of behavioral analysis reports, extracting data from the DWH, preparing of reports for use by the Risk Department. Design and creation of data visualization, crosstabs, maps, charts and interactive dashboards using Tableau. (Using Tableau 9, Excel). For the rest of the time: Troubleshooting at the production environment for all the companies of the “Gente más Gente” group (Financial area: Beto te presta in Costa Rica, Pepe te presta in Nicaragua, Chepe te presta in Guatemala and Chamba te presta in El Salvador). Performs data updates on the different system tables according to each problem that is being attended, development and maintenance of store procedures and triggers, works also as “On Call officer” at night, checking the successful execution of all the night processes, performing root cause analysis, changes to the databases when needed, creating alerts at the PRTG tool to monitoring the systems on real time, creating improvements for the different systems of the company. All these on MS SQL Server, MySQL, etc. Show less

    • Information Services
    • 700 & Above Employee
    • Database Analyst II
      • Jul 2012 - Sep 2015

      Performed the different database updates for Experian customers, executing DB2 and DB3 codes and stored procedures (using the IBM AS/400 Mainframe environment, DB2 and DB3 coding, over MS SQL Server and PostgreSQL databases). Performed the different database updates for Experian customers, executing DB2 and DB3 codes and stored procedures (using the IBM AS/400 Mainframe environment, DB2 and DB3 coding, over MS SQL Server and PostgreSQL databases).

    • Costa Rica
    • Outsourcing and Offshoring Consulting
    • 1 - 100 Employee
    • SQL Server Database Administrator
      • Jul 2011 - Feb 2012

      Database Administrator (Support to the members of the DBAs team). ETL´s creation, maintenance and documenting using SSIS (Microsoft SQL Server Integration Services). Creation of some internal reports using SSRS (Microsoft SQLServer Reporting Services). MS SQL Server 2008. Database Administrator (Support to the members of the DBAs team). ETL´s creation, maintenance and documenting using SSIS (Microsoft SQL Server Integration Services). Creation of some internal reports using SSRS (Microsoft SQLServer Reporting Services). MS SQL Server 2008.

    • SQL Database Analyst
      • May 2008 - Jul 2011

      Development and Maintenance of Reports for the R&A Department (about 260 reports, each one combines MS SQL 2005 and 2008, Excel 2003 and 2007 and Visual Basic). Besides some database administration task for the maintenance and improvements for an application that runs 100% on SQL Server 2005. Development and Maintenance of daily, weekly and monthly reports for the R&A Department, internal programming of the reports, some DBA tasks (creation and maintenance of some specific stored procedures) and technical support within the R&A Department. Show less

    • Costa Rica
    • Outsourcing and Offshoring Consulting
    • 1 - 100 Employee
    • Analyst Corrective maintenance and incident response
      • Jan 2007 - May 2008

      Resolving incidents (on the production environment), root-cause analysis, and improvements in the applications area of CitiBank Credit Cards (formerly Grupo Financiero Uno) for credit cards that operate in the countries of Central America. Database design, creation, maintenance and development (tables, relationships, programming: stored procedures, triggers, functions, performance) of the different databases for Credit Card applications. Sybase SQL Server

    • Consultant and Information Systems Analyst
      • Oct 2003 - Jan 2007

      Analysis, Design, Implementation and Maintenance of CRM applications using Power Builder 6.5 for customers such as INCAE, Phillips House, Xeltron and Banco Popular. Additionally, application maintenance as "Exceltec Call Monitor" using MS Visual Basic 6.0Database design, creation, maintenance and development (tables, relationships, programming: stored procedures, triggers, functions, performance) of the different databases for business applications. (MS SQL Server 2000, Sybase, Oracle).

    • Stock Exchange Broker Management Systems Specialist
      • Jan 2000 - Feb 2003

      Analysis, Design, Implementation and Maintenance of applications for management and operation of the Stock Exchange Market (Operations, Treasury, Custody Securities Portfolio, OPAB / CAV, Investment Funds, the interfaces between them and simultaneously with the Accounting System General). In Power Builder 6.5. Database design, creation, maintenance and development (tables, relationships, programming: stored procedures, triggers, functions, performance) of the different databases for business applications. MS SQL Server 2000, Sybase SQL Server Experience on Project Management (Change Management, planning, resource management, design and monitoring of schedules, definition of internal business processes, etc.). In addition, development of micro-applications using PowerBuilder PFC's of Power Builder 6.5 for the ICE (Instituto Costarricense de Electricidad/Costa Rican Electricity Institute). Show less

  • Desarrollos Softec S.A.
    • San José, Costa Rica
    • Analyst / Programmer and Project Management
      • Feb 1999 - Feb 2000

      Systems for Banking , General Accounting, Inventory, Sales, Credit, Collection Systems Administrative and Legal (the latter for the Banco Popular), for clients such as ULATINA (Costa Rica and Panama), Reckitt Benckiser, Universal Printing and lithograph, Universal Bookstores and the Instituto Costarricense de Electricidad (the latter project was designated as Project Manager). Analysis, Design, Implementation and Maintenance of Systems for Banking, General Accounting, Inventory, Sales, Credit, Collection Systems Administrative and Legal. In Power Builder 6.5. In addition, development of micro-applications using PowerBuilder PFC's of Power Builder 6.5 for the ICE (Instituto Costarricense de Electricidad/Costa Rican Electricity Institute). Database design, creation, maintenance and development (tables, relationships, programming: stored procedures, triggers, functions, performance) of the different databases for business applications. MS SQL Server 2000, Sybase SQL Server Show less

    • Costa Rica
    • Financial Services
    • 1 - 100 Employee
    • Stock Exchange Broker Management Systems Specialist
      • Feb 1991 - Feb 1999

      Analysis, Design, Implementation and Maintenance of applications for management and operation of the Stock Exchange Market (Operations, Treasury, Custody Securities Portfolio, OPAB / CAV, Investment Funds, the interfaces between them and simultaneously with the Accounting System General). In BBx3 on UNIX 4.0 and Power Builder 6.0 y 6.5 on Win NT 4.0. Database design, creation, maintenance and development (tables, relationships, programming: stored procedures, triggers, functions, performance) of the different databases for business applications. MS SQL Server Experience on Project Management (Change Management, planning, resource management, design and monitoring of schedules, definition of internal business processes, etc.). For a while I performed various administrative duties within the IT Dept. (Purchase of Equipment and Design of the Disaster Contingency Plan, Design and implementation of the Plan for Backup and Data Recovery , keep relationships with suppliers, and coordination between all the parts, etc.) Show less

Education

  • Universidad Latinoamericana de Ciencia y Tecnología
    Bachelor's degree, Ingeniería informática
    1990 - 1997

Community

You need to have a working account to view this content. Click here to join now