Jesus Gonzalez 214-***-**** adzocl@r.postjobfree.com

Professional Summary:

• Having over 14 years of experience as a SQL Server Database Administrator, Overall, 28 years of experience the Information Technology field including Service Delivery Manager, Maintenance, Support, Database Administration and Sales Technical Support.

• Overseeing the end-to-end management of large-scale databases, including installation, configuration, backup, and recovery, and ensuring data integrity and security.

• Analyzing and fine-tuning database performance, optimizing queries, and implementing index strategies to enhance system responsiveness and reduce resource consumption.

• Adapting at designing and implementing data warehousing solutions, enabling efficient data storage, retrieval, and analysis for business intelligence and reporting needs.

• Track record of effectively leading and inspiring cross-functional teams, fostering a collaborative and cohesive work environment, and nurturing the professional growth of team members.

• Installing and configuring of SQL Server / Oracle (on UNIX – Sun Solaris/ HP-UX) and Windows NT / Windows 2000, 2003, 2012 and 2016 Platforms. Also, in Cluster environments active/active and active/passive.

• Set up MS SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2019, and 2022 database instances.

• Upgrade experience from SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008 R2 / SQL Server 2012 and SQL Server 2008R2/ SQL Server 2012 to SQL Server 2016

• Set up SQL Server 2012/ 2014/2016/2019/2022 Always on for High Availability solutions.

• Capacity Planning and Creating Databases as per Microsoft Recommendations.

• Creating and Deploying DTS (in SQL 2000), SSIS (In SQL 2005), SQL Server 2012 and SQL Server 2016 Data Tools packages.

• Installing SQL Server Analysis Services, Installing SQL Server Reporting Services and creating test reports to make sure all working as per expectations.

• Setup linked server connection in SQL Server to pull data from various data source like AS400, Oracle etc.

• Data Migration from Access, Oracle, MySQL, and Teradata to SQL Servers.

• Setting up processes for regular backups and restore methods using Native and SQL Safe, and ensuring the processes are followed.

• Disaster Recovery Planning & Implementation.

• Setting up of Database Replication, Mirroring, Log Shipping and Clustering for High Availability and Always-On.

• Database Migrations/ Database Administration Activities across environments.

• Kron Shell, Bourn Shell, AWK, and Power shell scripting.

• SQL Server Cloud support on AWS

• Administering Oracle Database Administration 11g & 12c and Shell Programming.

• Ensure reaching SLA on ITIL process for Incident Management, Request Management, Change Management.

• On call production support 24/7

Technical Skills

Operating System : UNIX – Sun Solaris/HP-UX, AIX, Windows XP, and Windows NT/ Windows

Windows Server 2003, 2012,2016 platforms, Open VMS, MS-DOS.

Languages : SQL Server T-SQL, PL/SQL, AWK, Shell Scripting, DCL, BSH, KSH, and

Power shell scripting.

RDBMS : MS SQL Server 6.5/7.0/2000/2005/2008/2008R2/2012/2014/2016/2019/2022,

Teradata 17 13.10.07, 14.10.0.7, 13.10.07.12 9i, Oracle 6, 7.3, 8i,11g, and 12c.

MySQL 5.6.1 AWS, Snowflake.

Design Tools : Microsoft Visio 2007

Tools : Teradata Studio, Teradata Administrator, Teradata SQL Assistant, TD Viewpoint

SSMS, SSIS, SSRS, MySQL Workbench, Oracle SQL Plus and PL-SQL

SQL Query Analyzer, EM, SQL Profiler, DTS, Remedy, Service Now

NetBackup, CommVault.

BI/ ETL Tools : SQL Server Integration Services, and SQL Server Data Tools (SSDT),

Reporting Tools : SSRS 2012, 2016, Crystal Reports 9.0, Microsoft Excel 2007.

Professional Experience

Client: Brinker International, Dallas, Tx Aug 2016 – Present

Employer: Softtek Integration System Inc

Role: Manager Sr. Database Engineering

Achievements:

• Executing and coordinating the DBA tasks for upgrading Teradata 13.10.07.12, 14.10.0.7.08 to 17.10, and 17.20

• Executing DBA tasks for migrating Teradata from version 14.10.0.7.08 to Teradata Cloud on version 16.20.33.02

• Supporting datacenter migration

• Reducing 2 hours on the Polling Process on Teradata Data Warehouse as well as SQL Server integrations

• Implementing and purging process for information no longer needed on Teradata Data Dictionary as well as on User Databases

• Purge tables and databases no longer needed on Teradata, SQL, and Oracle saving more than 10TB

• Reorganizing Teradata (Net-Vault) backups and test restores

• Tracing and detecting main queries to tune on Teradata

• Coordinating and creating Changes requesting for implementing changes according with Project Management Plans

• Defining, deploying, and executing the migration for different instances from SQL 200X to SQL 2012 or SQL 2014 to 2016 and 2019

• Training and developing new team members

• Ensuring the team follow-up, the ITIL process for Incident Management, Request Management, Change Management.

• Implementing Problem Management and Root Cause Analysis

• Executing tuning and performance improvements of main data base processes operational and BI (data warehouse), reducing the time of response

• Implementing jobs and routines to purge old information on SQL Databases

• Ensuring 99% database backups reliability

• Implementing DB High Availability solutions, like Always On, Clustering, Log Shipping, Mirroring and Replication

• Database Administration of more than 1800 DB’s

o Teradata 17.20, 13.10.07, Oracle 11g, 12c, and Oracle Cloud. MySQL 5.6.1 AWS

o MS SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2019, 2022

Duties as a DBA tower leader are the following:

• Select the best resources provided by the sourcing department. During the last 14 years, I have been selecting the teams’ members for different projects that involve DBAs. I have interviewed more than 80 candidates specialized in MS SQL server, Teradata, Oracle, and MySQL.

• Reviewing team’ member's performance yearly, with a quarterly follow-up with the intention of reaching their goals and giving them the corresponding recognitions.

• Defining or approving at least 3 goals for each team member. These goals are based on:

o Reaching Service Level Agreements (incident, request, and change control management)

o Automating as much as possible the operation examples: Implementing maintenance routines, Index Rebuild, Space Reorg, Disk Space Capacity Planning, Backups Management, Update-Collect Statistics, etc.

o Implementing a purge process to keep only information needed for the operation and save disk space depending on the End-user necessities and budget.

o Applying security patches for avoiding vulnerabilities.

o Creating plan projects for upgrading to a new database version involving the respective teams like end-users, Windows, Unix, Networking, Storage, Dev, BI, etc.

o Implementing hard and soft dollar savings.

o Automating the PCI and SOX reports.

o Detecting blockings and performance issues.

• Audit quarterly meetings, with the SOX and PCI Auditors.

• Weekly meeting, with my team: The Accomplishments, Operation follow-up, Working in progress- Project, Areas of Improvement, Risk and Issues, Metrics and SLA trends, Root Cause Analysis, Problem Management, Training.

• Weekly meeting, presenting to the Customer - Manager: The Accomplishments, Operation follow-up, Working in progress- Project, Areas of Improvement, Risk and Issues, Metrics and SLA trends, Root Cause Analysis, Problem Management, Training.

• Bi-weekly meeting, presenting to the BI Director: The Accomplishments, Operation follow-up, Working in progress- Project, Areas of Improvement, Risk and Issues, Metrics and SLA trends, Root Cause Analysis, Problem Management, Training.

• Quarterly meeting, presenting to the IT directors and the CIO: The Accomplishments, Projects Completed, Metrics, and cases of Win-Win solutions.

Environment: MS SQL Server 2000/ 2005/ 2008/ 2008R2/ 2012/2014/2016/ 2019, and 2022 Enterprise and Standard on Windows Server 2000, 2003, 2008, 2012 and 2016. SQL Server 2008/2012/2016 Business Intelligence Studio – SQL Server Integration Services Analysis Services, and Reporting Services on Windows 2012, CommVault. Teradata 17.20, Oracle 11g, 12c, and Oracle Cloud. MySQL 5.6.1 AWS.

Employer: Softtek Information Services SA de CV

Global account: Levi’s México Country

Aguascalientes State Project Leader and DBA SQL Server/Oracle From: 05- 2010 To:05-2013

Employer: Softtek Information Services SA de CV

Global account: Restaurant Brands International RBI (Burger King Company and Tim Hortons).

México Country

Aguascalientes State Project Leader and DBA SQL Server/Oracle From: 05- 2013 To:08-2016

Duties as a DBA SQL Server/Oracle:

• Database Administration SQL Server 2000, 2005, 2008, 2012, 2014:

1. Database Installation and Configuration: Proficiency in setting up and configuring Microsoft SQL Server instances, including selecting appropriate configurations for performance and security, as well as High availability, Log-shipping, mirroring, replication, and clustering.

2. Database Maintenance: Skill in performing routine maintenance tasks like backups, restores, and index optimization to ensure database integrity and performance.

3. Performance Tuning: Ability to identify and address performance bottlenecks using tools like SQL Server Profiler, Query Store, and Dynamic Management Views (DMVs).

4. Security Management: Expertise in implementing security measures such as user authentication, authorization, and encryption to safeguard sensitive data.

5. High Availability and Disaster Recovery (HADR): Knowledge of setting up and managing features like, failover clustering, and log shipping for data redundancy and fault tolerance.

6. SQL Scripting: Proficiency in writing T-SQL scripts for data manipulation, querying, and automation of administrative tasks.

7. Troubleshooting: Capability to diagnose and resolve database-related issues, including troubleshooting connectivity problems and resolving conflicts.

• Tower & Project Leader/DBA Senior

8. Hiring, training, or firing the DBA team.

9. Follow up the daily operation in the different shifts supporting 7x24 coordinating the offshore team in China and Mexico

10. Open create and follow up the respective change’s controls according with the maintenance windows for upgrading, service pack installations or new configurations.

11. In case of severity 1 incidents follow up to complete and close with Root cause Analysis

12. Ensuring to avoid breaking the SLA for incidents, and it requests.

• Database Administration Oracle 12c, 11g,10g (RAC and ASM Options)

1. Database Installation and Configuration

2. Backup and Recovery in native mode with RMAN.

3. Performance Monitoring and Tuning.

4. Data Security.

5. High Availability Solutions: Familiarity with Oracle Real Application Clusters (RAC), Data Guard, and Active Data Guard for achieving high availability and disaster recovery.

6. SQL and PL/SQL: Proficiency in writing and optimizing SQL queries, as well as developing stored procedures, functions, and triggers using PL/SQL.

7. Database Upgrades and Patching.

8. Data Migration.

Functional and Technical

Experience: PM & DBA Senior SQL Server, DBA Oracle, DBA MySQL 5.6.13.

Tools: Linux x64, Oracle 10g MS Project, Visio, Unix Korn Shell Programing, AWK, Server W2003,8,12, SQL Server 7, 2000, 2005, 2008, 2012.

Employer: Mainbit S.A. de C.V.

Account: Encyclomedia México City

Project Manager

From: 11- 2008 To: 06- 2009

Duties as a Project Manager:

• Organize and manage different groups for distributing PC’s and software along “all” public schools in the country of 32 states.

• My main achievement as a Project Manager was updating 48750 PCs to the 2nd version of Encyclomedia in 8 states with a 98% of progress.

• I provided weekly and monthly reports of Updating Encyclomedia Project

Functional Experience: PMI Methodology.

Tools: MS Project, Visio, Unix Korn-shell Scripting and PHP, Peregrine Service Centre, Excel pivoted Tables, generate graphics and advanced functions for reports.

Personal Business

México City Client Op Manager & Sales Representative From: 04- 2007 To: 05-2010

Duties as a Client Operation Manager & Sales Representative:

• Selling and promoting for renting equipment for social events.

• I created and designed the processes for inventories, sales, logistics and distribution.

• I trained the employees for the new processes.

• Budgeting and sales projections.

Functional Experience: PMI Methodology

Tools: MS Project, Visio, Oracle, Excel pivoted Tables.

Employer: EDS de México S.A. de C.V.

Account: KUO México Country Service Delivery Manager From: 06-2005 To: 02-2007

Duties like Service Delivery Manager:

• Using ITIL methodology ensuring to reach the SLA’s.

• Managing 45 workplace system engineers, and 15 help desk consultants.

• Managing up to 200 workplace system engineers during the technical refresh of PC’s and Laptops.

• Selling and charged new projects, coordinate and support datacenters and centralizing Unix Servers, managing suppliers, deploying ERP SAP, etc.

Functional Experience: Project Management

ITIL (Service Level, Incident, Request, Risk and Problem Management).

Supporting development and implementation of major initiatives.

Budget management, Vendor Management

Tools: Remedy, SAP, Oracle, Datacenter, Windows and Unix Servers, Visio, MS Project, MS Office, Routers, TNG UAM, SDO, RCO, etc.

Employer: EDS de México S.A. de C.V.

Account: Grupo BIMBO S.A. de C.V.

México City Service Delivery Manager.

From: 03-2002 To: 05-2005

Duties like Service Delivery Manager:

• Manager IT Bimbo metropolitan zone administration of 25 workplace system engineers

• ITIL (Incident, Request, Risk Service Level and Problem Management).

• Leading and managing many projects simultaneously following the PMI Methodology

• Implementing the CA UNICENTER Solutions (TNG, UAM, SDO, RCO, SLMO, BRIGHSTOR, SQL 2000),

• Supporting infrastructure like datacenters, Solaris Servers, Sybase DB, SQL Server 2000, SIA etc.

• Vendor Management.

Employer: EDS de México S.A. de C.V.

México City Infrastructure Specialist

(IT Architect)

From: 05-2000 To: 02-2002

Duties like IT Architect:

• Designing and implementing technical solutions from Database Perspective for distributed systems environments in several accounts.

• Sales support for preparing Outsourcing Projects.

• Coordinating a leading different project using the Project Management Institute methodology.

Employer: IBM de México S.A. de C.V.

México CSTS Manager

Client Server Technical Services Manager From: 09-97 To: 04-2000

Duties like CSTS Manager:

• IT Architect and IT Manager leading 8 infrastructure system engineers,

• Making and supporting infrastructure proposals for ERP’s SAP, Baan, JDE One World, Oracle, People Soft, and Network solutions like Tivoli (TEC, Workload, Desktop Management), Cisco Routers, HP Open View,

• Implementing Desktop Management Solutions like Tivoli (Software Distribution, Remote Control, Inventory),

• Leading and supporting system Administration of Unix environments (Solaris 2.5, 2.6, 7, 8, HP-UX,7,8 AIX, Linux) Database Administration of Oracle, Sybase, Informix SQL Server, and Wintel Servers,

• Leading Data Warehouse Solutions, etc.

Employer: EDS de México S.A. de C.V.

Account: Aeroméxico, Mexicana Airlines. México Oracle DBA From: 09-96 To: 09-1997

Employer: EDS de México S.A. de C.V.

Account: Televisa, Citibank, ACES DE COLOMBIA.

México & Colombia Oracle DBA From: 09-94 To: 09-1996

Duties like Client Server Technical Service Manager:

• DBA Oracle (7.3.& 8.i), DBA Sybase, DBA INFORMIX. System Administrator Unix (Solaris, HP-UX, AIX)

• Installation of Oracle Database Engines

• Database creation, backup management

• Cron/Jobs automation

• Shell scripting on Unix for automation

• Security Administration like creating and granting user and roles

• Database Space administration

• Tables and Object creation

• PL/SQL Programming

Education

Bachelors Degree Computer Sciences UNAM,

Mexico City

1989- 1995

Certifications and Training

Microsoft Certified Technology Specialist SQL Server 2008 Implementation and Maintenance

Aguascalientes

2011

PMP Preparation Exam Training,

Aguascalientes

2014

PROFESIONAL TECHNICAL TRAINING:

Teradata:

Introduction to Data Warehouse and Teradata

Getting Stated with Teradata

Data Warehousing Technology

Teradata Warehouse Administration

MSSQL Server:

DP-300: Administering Microsoft Azure SQL Solutions (DBA)

SQL Server Database Administration 2016

SQL Server Database Administration 2012

SQL Server Integration Services 2012

SQL Server Reporting Services 2012

SQL Server Profiler

Mastering SQL Server 2016 SSIS

Oracle:

Oracle Database Administration 11g & 12c

Oracle Database utilities

Real Application Cluster

Oracle PL/SQL

Oracle Dataguard

Oracle 11g Certified Professional Exam Prep

Miscellaneous Training

Tivoli Framework &Tivoli TEC, Manhattan NY., Tivoli Inventory, Phoenix Arizona

Peregrine Service Center, San Diego Cal,

Peregrine Asset Center, Orlando Fda.

Administración ESSBASE, México D.F.

DB2 UDB & DB2 OLAP Server, México D.F.

Oracle Data base Administration, Tuning, Backups, México D.F.

Unix Solaris System Administration, Unix HPUX System Administration, México D.F.

Administration I y II AIX RS6000, México D.F.

Database Administration SYBASE, Database Administration INFORMIX, México D.F.

PROFESIONAL ADMINISTRATIVE TRAINING:

• Project Management Professional 5.0, 4.0, 3

• Root cause analysis and troubleshooting

• Finance Administration (overview Billing Agreement, Budget’s, Forecast Tool & AP)

• Meta Management

• ITIL Foundation: Incident Management, Request Management, Problem Management, Change Management

• ITAM Desarrollo de Habilidades Gerenciales

• Business Review Boards (BRB) & Technical Review Boards (TRB)

• Effective communication

REFERENCES:

Contact information.

Name: Arturo Madero Tel. +1-469-***-**** email: adzocl@r.postjobfree.com

Position: Cyber Security Architect

Company: GM

Name: Vinay Keerthipati Tel. +1-940-***-**** email: adzocl@r.postjobfree.com

Position: Senior Developer

Company: ABSLI

Name: Abner Cordova

Position: Information System Manager

Company: ADTRAN

Tel. +256-***-****

email: adzocl@r.postjobfree.com

Name: Hector Ruiz

Position: Service Delivery Manager Tel. +521-55.1974.8692 email: adzocl@r.postjobfree.com

Contact this candidate