Sql Server Systems Engineer

Computer Systems Engineer

Name: Carlos Alberto Méndez Jiménez

Date of Birth: 23-March-1983 Age: 41 Years old

Phone: 619-***-****

E-mail: *******.******.*******.****@*****.*** Professional license: 6001945 City: San Diego, CA.

PROFESSIONAL OBJECTIVE

Provide quality services according to my experience acquired during my management in different companies and / or projects, working mainly as PeopleSoft Senior Systems Administrator. ACADEMIC STUDIES

September 2001 - April 2006 September (1995 – 1997) Technological University of Mexico (UNITEC) Professional Institute of Computer Studies (IPEC) South campus. Computer Systems Engineer Technical career of Programmer Analyst WORK EXPERIENCE

**KIO NETWORKS (June 2010 – June 2024). IT Consulting. Acting mainly as SYSADMIN SR. and DBA SQL SERVER & ORACLE

--DBA SQL SERVER October 2019 – June 2024

Latest activities performed as DBA SQL Server:

Database Design and Architecture - Designing and planning the structure of databases.

Installation and Configuration - Installing and setting up SQL Server instances and related components.

Performance Tuning - Monitoring and optimizing the performance of SQL Server databases.

Backup and Recovery - Implementing and managing backup strategies and performing recovery operations.

Security Management - Configuring and managing database security, including user permissions and roles.

Patch Management - Applying updates and patches to the SQL Server software.

Monitoring and Troubleshooting - Continuously monitoring database health and resolving issues.

Capacity Planning - Forecasting future database storage and resource needs.

Data Migration - Moving data between systems or upgrading databases.

Index Management - Creating, maintaining, and optimizing indexes to improve query performance.

Query Optimization - Analyzing SQL queries for better efficiency.

Database Scripting - Writing and managing scripts for automation and routine tasks.

High Availability and Disaster Recovery - Implementing solutions like replication, Log Shipping, clustering, or Always On to ensure database availability.

Data Integrity - Ensuring the accuracy and consistency of data within the database.

Compliance and Auditing - Ensuring that database practices comply with legal and organizational policies and performing audits.

User Management - Managing database user accounts, roles, and permissions.

Documentation - Creating and maintaining documentation for database configurations, processes, and procedures.

Service Management - Managing and configuring SQL Server services and related components.

Troubleshooting Hardware and Software Issues - Diagnosing and resolving issues related to the database server hardware and software.

Collaboration with Development Teams - Working with developers to ensure database design supports application requirements and performance goals.

--Installation of the latest SYS version of PeopleSoft 9.2 with PeopleTools 8.58 on Oracle Linux 7 servers, both Database and Application for Deportes Martí client. September 2019

--Installation of DEMO version of PeopleSoft 8.8 with PeopleTools 8.45 for Deportes Martí client. August 2019

--Tuning to sentences that take a long time in the Database, as well as applying Advisor to Queries that need it to see a possible improvement and that the performance of it is optimal.

-- Migration of infrastructure (New Servers) due to change of Data Center, from RedIT Santa Fe to KIO Networks with (High Availability) and its respective DRP (Disaster Recovery Plan) of the Martí Sports client. April 2019.

-- Provide courses to Junior staff (First Level) of PeopleTools I and II, as well as oriented to the functions of a SYSADMIN, such as, configurations of Web Components or PIA (PeopleSoft Internet Architecture), Application Server, Process Scheduler, Integration Broker August 2018 - November 2018.

-- Migration of projects from alternative environments to production.

--Tools update 8.49 to 8.54 for the Bolsa Mexicana de Valores (BMV) client occupying Change Assistant December 2017.

-- Application of patches of components such as, PIA and Tuxedo of several aforementioned customers.

-- Manage the environments of Finance and Human Resources of the following accounts or clients: Martí Sports, Mexican stock exchange, Cinepolis, Farmacias del Ahorro, Scotiabank, Cruz Roja, Innova, OutHelping, Sportium, Provident, Karisma, Autotodo, Sura, Zurich, Teletón, Argos, Ignia, Grupo Expansión, Chedraui, Global Card y Caja Popular Mexicana.

--System Administrator in PeopleSoft (SYSADMIN) in the SAT Project by the CIMA SC consultancy (May 2009 – May 2010).

--Imparting PeopleTools 1 y 2 course (July 2009 – September 2009) to Jr. Technical Consultants at CIMA, SC.

**Consulting Company CIMA, SC. Business Solutions and Integral Services in Information Technology. Implementation of modules with PeopleSoft ERP on SQL Database and ORACLE. (August 2006 – May 2010).

**Consulting Company Hildebrando. Support and maintenance to BANORTE bank in COBOL and SQL programming language (September 2005- July 2006).

**Computer teacher of a private school (August 2003 – July 2005) and creation of the network of the computer lab of the same school.

**Department of Networks and computing. Support and maintenance of computer equipment. Liverpool Polanco Duración 1 año. (2002-2003)

SOFTWARE KNOWLEDGE

PeopleSoft with BD ORACLE and SQL (Excellent handling of Querys, Tunning, Remove Advisor (ADDM), Triggers), SQR, Crystal Report, Change Assistant, Application Engine, PeopleCode, WorkFlow, Component Interface, Oracle Designer 9i, SQL Plus & Server, C language, Microsoft Office (Word, Power Point, Excel, Publisher, Project, Visio), Operating Systems such as Solaris, Unix, Linux, AIX (Environment by command line) and Windows. COURSES AND WORKSHOPS OF PROFESSIONAL SKILLS

September 2001 - December 2001 Time management

January 2002 – April 2002 Negotiation

May 2002 – August 2002 Creativity and problem solving September 2002 – December 2002 Relationships

September 2002 – December 2002 Macromedia MX Seminar January 2003 – April 2003 Life and career plan

May 2003 – August 2003 Entrepreneur

May 2004 – August 2004 Professional quality

September 2005 – December 2005 Business consulting January 2006 – April – 2006 Self-education (English course Harmon hall) July 2005 Cobol

September 2006 - October 2006 PeopleSoft (Tools I y Tools II) January 2008 WorkFlow

July 2013 - November 2013 Oracle Database 11g Administrator Certified Assosiate (Certification) October 2019 DBA SQL Server Course

PROFESSIONAL SKILLS

*Techniques.- I have the facility to be able to adapt myself to the different tasks and areas that are presented and to be able to face them with the right and necessary tools. *Human.- With the passage of time I have acquired the power to make decisions of great risks, whether in work or family environments; and likewise the ease of directing and controlling groups of people due to work experiences. *Conceptualization.- I know that I have the ability to relate to any social environment and to adapt it for the development of any activity.

Contact this candidate