Database Administrator & SQL Server Expert, San Diego

COMPUTER SYSTEMS ENGINEER DBA SQL SERVER

Carlos Alberto Méndez Jiménez

Address: San Diego, California Phone number: 619-***-**** e-mail: ******.***.*****@*****.*** PROFESSIONAL OBJECTIVE

Computer Systems Engineer with more than 20 years of experience in the Information Technology sector, specialized in the design, implementation, and management of technological solutions that optimize business processes and strengthen digital infrastructure.

My background includes IT project management, software development, SQL Server and Oracle database administration, cybersecurity, and user support, always with a focus on innovation, efficiency, and continuous improvement. I seek to join an organization where I can contribute my technical expertise, leadership, and analytical skills to drive digital transformation, ensure operational continuity, and support the achievement of the company’s strategic objectives. I am distinguished by my commitment, adaptability to emerging technologies, effective communication skills, and results-oriented mindset, which enable me to collaborate proactively with multidisciplinary teams and deliver solutions that generate tangible business value.

ACADEMIC STUDIES

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

SOFTWONE INTERNATIONAL LLC(Ago 2024 - Present)

Migrate PeopleSoft's production database from Oracle to SQL Server. Extract reports from PeopleSoft ERP and convert them for execution in SQL Server using stored procedures with PL-SQL.

Personal Project (Oct 2025 - Nov 2025)

Developed a construction estimation application to streamline project planning and budgeting. The tool calculates required materials such as drywall sheets and screw boxes, estimates labor costs, and provides detailed insights for more accurate project management.

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

--DBA SQL SERVER October 2017 – Juy 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 (2002-2003) SOFTWARE KNOWLEDGE

PeopleSoft with BD ORACLE and SQL Server (Excellent handling of Querys, Tunning, Remove Advisor (ADDM), Triggers), SQR, Crystal Report, Change Assistant, Application Engine, PeopleCode, WorkFlow, Component Interface, Oracle Designer 9i, Turbo C ++, C language, Java Standard Edition, J2ME, Macromedia (Flash Mx, Mx Dream Weaver, Fire Works Mx), SQL Plus & Server,, 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

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) Julio 2017 Capacitación DBA SQL Server

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