Omar E. López Rodríguez

Calle Catania # *** Fracc. Canto de Catania, Juárez, Chihuahua 32540

Cell: +52-656-******* - ac995k@r.postjobfree.com

Professional Summary

Skilled Computer Systems Engineer with 5 years of experience in Database Administration and 10 years of loving what I do professionally.

Skills

Database administration

SQL Server 2000 - 2016

Update and upgrade SQL Server

Database design

Performance tuning

Database security and Audit

High Availability

Database maintenance

Backups and Restores

Replication

Linked Servers

Inventory

Windows 2003, 2008, 2008 R2, 2012

Oracle 9i, 10g, 11g

Linux

Troubleshooting

Monitoring

Batch jobs

Automation

Teamwork

Accountability

Problem Solving

Innovation

Storage design

Quality

Fast learning

Proactive

Self learning

Migration

T-SQL

Work Experience

02/2015 - currently

Database Administrator at Foxconn PCE Technology – Juarez, Chihuahua, Mexico

MS SQL Server

Installation, update, upgrade and configuration of MS SQL 2000, 2005, 2008, 2008 R2, 2012, 2014 and 2016.

Database maintenance.

Backups and restores.

Performance Tuning

Archiving

Audit.

DB Monitoring.

Log shipping and Mirroring.

Maintenance Plans.

Notifications management.

Administration and monitoring of processes.

Monitoring of performance.

Linked Servers

Drive space monitoring.

Logon triggers.

Users and roles administration (Security).

Partitioning.

SQL Server Reporting Services (SSRS)

SQL Server Information Services (SSIS)

Inventorying.

TDE (Transparent Data Encryption)

Replication.

SSMA Oracle to SQL Server Migration Assistance.

Oracle

Installation, update, upgrade and configuration of Oracle 9i, 10g, 11g and 12c.

Database creation

Oracle data pump.

Backups and restores.

Database shrinking.

Archiving

Users and Security.

Partitioning of big tables.

Dataguard Real time Apply.

Monitoring.

Migration from Oracle to SQL Server.

Hadoop Ecosystem

Basic installation and configuration of Ambari, HDFS, YARN, Hive, HBase, Pig, Scoop, Zookeeper, Ranger and all HDP and HDF components thru Ambari on CentOS 7.

Database creation and data migration from RDBMS to Hive.

Manage of XML’s files from HDFS using Hive and SerDe.

I’m starting to learn this technology, no much experience yet but I know the basics.

11/2011 to 02/2015

SQL Server Database Administrator at Corporacion Atlas S.A. de C.V. – Juarez, Chihuahua, Mexico

Installation, upgrade and configuration of MS SQL 2005, 2008 and R2 Express, Standard and Enterprise versions.

Database maintenance.

Backups and restores.

Replication.

Manual Maintenance and Automate Plans.

Notifications.

Administration and monitoring of processes.

Indexes creation and maintenance.

Monitoring of Performance.

Cluster installation (High Availability) Users and roles administration (Security).

Inventory

SAP BASIS

Installation SAP ECC 6.0 SR3 on Windows 2008 / MSSQL Server Client copy SAP ECC.

System Copy SAP ECC.

Kernel Upgrade on SAP ECC.

Administration of users and roles on ERP Systems such as SAP ECC 6.0, CRM 5.0.

Review and Jobs schedules SAP Systems.

Profile System Maintenance SAP.

Package updating (SPAM) SAP RFCs Configuration SAP.

Basic Client Administration.

SAP Transports Management System.

SAP Services and performance monitoring.

Dump Analysis.

Applications Administrator

Installation and administration of VMware ESX 4.1 Deployment of virtual machines.

Installation and administration of MS Exchange 2010 Administration of Active Directory resources.

Administration of users and profiles on MS Dynamics AX Users administration of MS Lync 2010.

Installation and upgrade of applications such as (Tress, Computacion en accion, SAE).

Restoring data with EMC Networker.

Review and backup schedule Symantec BackUp Exec/Veritas.

Migration Active Directory Certificate Services.

05/2011 to 11/2011

IT Coordinator at Universidad del Valle de Mexico – Chihuahua, Chihuahua, Mexico

Network infrastructure for voice and data design and administration.

Academic and language labs administration and technical support.

Installation and configuration of SmoothWall (Firewall/Proxy WebCache) E-mail Live accounts administration.

LAN and Windows Servers Administration.

Technical support to administrative staff.

05/2009 to 05/2011

IT Coordinator at Universidad TecMilenio Campus Chihuahua – Chihuahua, Chihuahua, Mexico

Performed project Network Reengineering.

Execute preventive and corrective maintenance of computer equipment on Linux, Windowsand iMac Laboratories.

Performed the project: Network enlargement bringing communication between buldings.

Bring Technical Support to Sedes UTM Cuauhtémoc, Camargo and Parral.

Bring Technical Support to student body, teaching and administrative staff.

Teaching.

05/2008 to 05/2009

Technical Support at Zapaterías BHermanos S.A. de C.V – Chihuahua, Chihuahua, Mexico

Bring Technical Support to some different points of sale to improve the performance of the workstations and ensure customer care.

08/2007 to 12/2007

Technical Support at TRW SWS Chihuahua – Chihuahua, Chihuahua, Mexico

Planing of project "Fault Tolerant Architecture for Production Network" to improve and ensure the high availability of the network services to keep the business running.

Bring technical support to production lines ensuring productivity and avoiding idle time.

08/2006 to 12/2007

SITE Assistant at Instituto Tecnologico de Chihuahua II – Chihuahua, Chihuahua, Mexico

Auxiliary structured wiring Cat 6.

Configuration of network devices.

Installation of Servers/Firewall.

Personal Information

Marital Status: Married.

Age: 33 years old.

Date of Birth: December 31, 1984.

Place of Birth: Delicias, Chihuahua.

Nationality: Mexican.

Willing to relocate: Yes

Education

2011

Master's Degree: Information Technology Management

Universidad TecMilenio - Chihuahua, Chihuahua, Mexico.

In my master's degree, I continued my education focusing on information Technology Management to enforce my bachelor degree.

2007

Bachelor Degree: Computer System Engineer

Instituto Tecnológico de Chihuahua II - Chihuahua, Chihuahua, Mexico

I studied to prepare myself as a computer systems engineer.

I performed professional practices and helped to improve the security of the campus.

I also helped to improve the technical support to administrative staff.

Certifications

Microsoft Word Specialist

Courses and Seminars

SQL Saturday

EMERGENETICS.

Coaching at Universidad TecMilenio.

Conference: XII Simposium Internacional de Informática y Computación SIINCO.

Goal

Apply the acquired knowledge to professional development, oriented to a continuous improvement culture with an attitude of constant learning, in order to serve the company in which I develop and through this contribute to the welfare of the community.

Contact this candidate