Guillermo Matus

Experience

• 

  SOFTTEK GDC – Aguascalientes

  Jun 2006 - Feb 2007

  IT Administrator

  - Guided IT Projects as IT Consultant for US Clients- Consolidated IT infrastructures in Blade Centers technologies- Consolidated Information in SAN Storage (iSCSI)- Implemented, Monitored and Operated Blade Server Infrastructures on site and remotely- Evaluated and Coordinated the proper use of the operating system administration- Implementing the best practices for Microsoft IT infrastructures- Implemented, Monitored and Administration of Virtual Servers with VMWare Technology- Monitored and Deployed of Virtual and Physical Severs with Altiris Software- Guided the administration of Microsoft solutions for new client projects (Windows 2003 servers, SQL Server, Sharepoint server, Web Services, Cluster Services, ISA server, etc.) Mostrar menos

• 

  Corporativo de Materiales – Merida, Yucatan

  Mar 2007 - Jun 2007

  IT Consultant

  Provided tech support to SQL Server platform in Clustered Service for its optimal operation- Evaluated and Coordinated the Windows Server Package Updates- Monitored, Administration and Maintenance of the JDEdwards B7334 ERP (CNC)- Evaluated and Coordinated the proper use of the operating system administration and the ERP system (Software and Hardware)- Guided the administration, Maintenance and Performance tuning of the corporative databases implemented in Microsoft SQL Server 2000 Enterprise Edition (DBA) Mostrar menos

• 

  Hildebrando – Mexico

  Jul 2007 - Feb 2008

  SQL Server DBA (HSBC Consultant)

  - Provided tech support to SQL Server platform (Single and Cluster servers) for its optimal operation- Managed SQL Server Administration- Guided the administration, Maintenance and Performance tuning of Microsoft SQL Server 2000, 2005 and 2008 for more than 30 instances and +200 databases- Monitored SQL Server environments operation- Created, Deployed and Maintained list of SQL Server assets- Deployed SQL Server 2000 and 2005 environments as well as Implemented the best practices for Microsoft SQL Server- Developed TSQL and Stored Procedures in order to extract and process SQL Server System Information- Developed of reports with Visual Studio 2005 and Reporting Services 2005- Handled of Administrative tools “Quest Software” to Monitoring and solve problems of TSQL and Bottle Necks Configurations- Guided the administration of Integration Services and Analysis Services 2005 (SSIS and SSAS) Mostrar menos

• 

  ABB

  Mar 2008 - now

  Manage the delivery of end-to-end IS (information systems) solutions/services, including project delivery and quality operations assurance for solutions in scope (build and run).Collaborate with global business process owners to understand demand, provide delivery proposals and implement solutions based on IaaS and SaaS or on premises for different business areas.Establishing strong relationship relationships with business stakeholders and acting as IS focal point for overall leadership, control and accountability of the area at the local level.Participate in the meetings of the Local Management Committee of projects as IS Service Manager within the determined area.Coordinate and manage the planning and consumption of IS services resources for its optimal delivery.Acting as the owner Applications given in the scope are in line with the plan and are properly controlled for delivery.Coordinate the planning and consumption of the IS service budget in the scope.Ensure that the ongoing service delivery and support organization meets agreed business requirements and SLAs (service level agreements).Lead team members within a given area to ensure timely and benefit-based delivery of projects and services to our internal and external clients.Cooperate and collaborate with application administrators/owners to optimize the service delivery experience and performance.Being part of the IS NAM App Run leadership team and supporting the strategic objectives of our area/department.Ensure timely delivery of database services for all CA, US and MX applications within scope as a database manager. Mostrar menos NAM TEAM - SQL Server DBA - Lead. (+20 years of expertise with large Database Environments). SQL Server 2014 on cloud services.- Lead Administration, Maintenance and Performance tuning of Microsoft SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 (Enterprise and Standard Editions)- Database Services Migration and Upgrade- Cloud DB Servers- Monitor and Maintain MS Windows Servers and DB services to support business operation (+2000 DB’s )- Responsible for with Microsoft Clustering and High-Availability database solutions- Implement and Maintain SQL Server on MS Cluster Server environments- Help with best practices for TSQL and SQL Server setup- Develop TSQL Code to fix application issues- SQL Server Performance Tuning execution for query statements and data architecture- Database Monitoring tools Admin (Quest, Dynatrace)- Deploy, Administer and Maintain Database Replication for ABB Factories located in US (PP).- Conduct SQL Server Rebuild, Re-install, Recovery, Backup and Migration Plans and Strategies.- Deploy Business Solutions using SSRS, SSIS and SSAS Services- Active involvement in NAM Projects as DBA leader / Manager- Key member of NAM team for Microsoft SQL Server Databases- Mentoring new members of NAM NonERP App Database Team Mostrar menos

  • IS Service Manager

    Jun 2022 - now

  • SQL Server DBA Manager

    Mar 2008 - Nov 2022