Locornejor@hotmail.com
Lui*** ***** (XX Anni)
DBA a DBA
Residente fuori dall'Italia
Questo candidato e' disposto a spostare
|
Esperienza
DBA
DBA
Objective: Interested in participating in a company where I can develop my negotiation skills with staff, clients and / or suppliers. Provide my knowledge, experience and skills for interpersonal development and the company itself.
PROFESIONAL EXPERIENCE
Company: BTRG Group.
Client: Sculptor (NY) remote
Position: DBA
Date: November 1 2020 to Date
Function:
Assigned to Sculptor Capital Management. Remote way
Responsible for providing production support services.
Primary Responsibilities: Track and resolve database-related incidents, respond to alerts, work database-related,
and to fulfill service requests within SLAs to ensure databases are performing to expectations the client's. Duties
include performance tuning, backup and recovery, replication, data management,
Tools used: Oracle 11 and 12C, TOAD, SQL DEVELOPER, Shell Script, Linux Red Hat Management, Unix, Remote Desktop Manager.OEM 13c
Company: SMX Services & Consulting Inc.
Client: Evertec Puerto Rico remote
Position: DBA
Date: March 18 2020 to July 2020
Function:
Installation configuration maintenance and tuning of Oracle database as well sa the attention of incidents
Tools used: SQL Server, Oracle 11 and 12C, TOAD, SQL DEVELOPER, Shell Script, Linux Red Hat Management, Unix, Remote Desktop Manager.
Company: Sonda
Position: DBA
Date: January 2019 to March 2020
Function
Reception Installation and configuration of the Authentication Equipment AUT QA (NPE). Review of Servers that meet the requested operating system requirements as well as the prerequisites for the installation of SQL, Sybase and Oracle Database Engines , I worked with the migration of the Productive Environments from Chile, Panama, Uruguay to Mexico (Querétaro Triara) In August 2019 from 12 to 26 I was in Uruguay performing the Migration and Tuning of Oracle servers and databases that the Largest is 8.5TB They are servers in 2-node RAC and with ASM Storage
Supported through RMAN, The Tuning of the Migration of Uruguay from September 30 to October 11 was in person in the Migration of the Core Core CUT OVER
Tools Used: PostgreSQl, Oracle 12C , TOAD ,SQL DEVELOPER , Shell Script , Linux Red Hat, Unix
Company: Compartamos Banco
Position: Free Lance
Date: Octuber 2018 To January 2019
Database Migration Proyect
Functions:
Migration of a PostgreSQL Database to Oracle 12c as well as evaluation of Radiant System Performance
Already migrated the performance and good operation of the same was reviewed
Tools Used: SQL server, Oracle 11g , RMAN ,TOAD DATA GUARD, SQL DEVELOPER , DATA PROTECTOR Shell Script ,Linux Red Hat, Windows Server, Unix
Company: Multiva
Position: DBA Manager
Date: November 2017 to October 2018
Functions:
Maintain the Lumina and SABI systems that are in Oracle and Progress Database functioning properly and with an adequate performance. Monitoring and implementation of data base replication that is in Oracle DATAGUARD, Installation of Oracle Engines and Installation of Databases Configuring the boot parameters according to the requirements.
Backups through Data Protector, In Oracle the DataGuard is managed for replication. The Instances are handled in Stand Alone and in RAC of 4 nodes for backups it is used expdp and impdp as well as the RMAN. To keep backups, tools such as DATAPROTECTOR and Veritas are used.
Management of Linux to know the Performance of the Server with commands like TOP, SAR, VMSTAR,
UPTIME, FREE among another creation of Shells to automate tasks and perform crones for execution of specific day and time tasks.
It helps developers in their queries for the best performance and hints index recommendations and some performance technique.
I am in charge of 3 operators and 1 dba jr.
Tools Used: SQL Server, Informix, DATA GUARD, TOAD, Enterprise Manager
Company: Intercam
Position: DBA ORACLE
Date: February 2015– November 2017
Functions :
Support to ORACLE Databases Both the Bank (Sibamex) and the Brokerage House (Lumina) that the Bases are in Optimal Performance Levels, Constant Monitoring of the Database as well as Revise Spaces, Statistics. Stand Alone Instances are handled as well as ORACLE RAC ASM and for RMAN backups. Management of Oracle DATA GUARD for replication, installation, configuration and start-up of new databases and Oracle engines for Development and testing environments. It helps the developers in their queries for the best performance and hints index recommendations and some performance technique.
Tools Used: SQL Server, DATA GUARD, TOAD, Oracle version 11 y 12 Enterprise Manager
Company:: KSK
Position: DBA ORACLE
Date: November 2014 A February 2015
Client: BRIDGESTONE-FIRESTONE
Functions :
Support to ORACLE Databases at the LATINOMAERICA level (Costa Rica, Brazil, Argentina), the main Databases are the Manufacturing and BOSS Data Bases, as well as SQL Bases SERVER Performance Improvements of the Databases are carried out. Incident Support The Tools Used are SQL Development, TOAD Enterprise Manager.May Stand Alone Instances as well as ORACLE RAC ASM and for RMAN backups. Installation of new Instances of Databases in new environments
Restitution of productive environments in Development and testing.
Company: Tecnides-IBM
Position: ORACLE DBA
Client: Banorte - Bancomer
Date: July 2013 – Noviember 2014
Sumando Banorte Project Design of the Database through Erwin. Sizing of the Data Base generation of the Tablespaces as well as the Generation of Scripts for creation of Users, Tables Indices. Tools Used TOAD, TOAD Modeler and SQL DEVELOPMENT
Security Project of Distributed Databases for Bancomer. Shell Review
Scripts for the Base Lines and Hardening of each of the BD that are around 300
Instances in 80 Servers. Tools Used TOAD.
ORACLE RAC ASM is used and for RMAN backups
Company: SOFTTEK (AGUASCALIENTES)
Position: DBA ORACLE
Client: LG Financial – McKesson
Date: July 2012 – July 2013
Support to all BD and General Electric Applications (GE) are recorded incidents through Remedy and served in the times established by the SLA Changes were made to the BD and applications in scheduled time windows, Oracle was used Versions 9 10 and 11 TOAD, Enterprise Manager for backups (export, import) and RMAN. All in High Availability (RAC and ASM)
Mckesson (Pharmaceutical in the US) was also supported. Attending the Incidents that were presented through the Remedy according to the times established by the SLA.
The tools used are: Oracle versions 9 10 and 11g and Enterprise Manager.
Backup information with RMAN. High availability management (RAC and ASM)
Company: AFORE BANAMEX
Position: DBA ORACLE
Date: March 2009 – July 2012
Monitoring of the databases of the different systems of the AFORE (ISISEF, DIGIPRO, among others), Oracle version managed with Oracle 9, 10 and 11.1.0.7 with HP UX. The day-to-day activities were to monitor the correct functioning of the Databases that were active and with an adequate performance, review of the backup generated these were generated by means of datapump (export - import) to make releases to the production of the applications as well as of the Databases., handling and monitoring of disk spaces. The applications used the Weblogic and OAS. Management of a 4-node RAC High availability and ASM for disk spaces.
Here I was in charge of 4 External Consultants of Condor Consulting.
Company: BANCO AZTECA
Position: DBA ORACLE
Date: AUGUST 2007 - MARCH 2009
Monitoring of the Bank and Electra Stores Data Bases, as well as their correct Operation Attention to the Incidents presented in them and to the Databases and Applications must be available 24 hours a day, 365 days a year. also supports South America (Argentina, Brazil, Peru, Guatemala, among others). Release to code production developed at home as well as support to the developers for the tunning, the scripts are revised with their execution plans and suggestions are made and improvements to them, Creation of Maintenance JOBS (generation of statistics among others) creation of Shels of unix for the creation of information backup. Tools used GRID Control Enterprise Manager, TOAD and for RMAN DATAGUARD backups for database replication.
Company: GRUPO CAPRINET
Position: SYSTEM CONSULTANT
Client: Health Secretary
Date: AGOSTO 2006 – JULIO 2007
Support and maintenance of the rhsalud.com.mx portal as well as maintenance and correct Operation of the SQL SERVER 2005 database.
Company: SECCION AMARILLA.
Date: FEBRUARY 1996 JULY 2006
In this company I had several positions:
DBA ORACLE – INFORMIX / Administrador de Portal y Analista de Mercadotecnia.
As a DBA participates in the Migration of Payroll Applications and Accounting first to Informix and later to ORACLE version 9, 10 the Application of Pagination of the Book of a Hierarchical Database to Oracle was also migrated to this was done with a Jewish Company AMDOCS.
Monitoring and proper operation of the BD and applications.
As Portal Administrator the portal was developed and I was in charge of reviewing and uploading all the contents of it.
Marketing Analyst Creation of Databases for the Area, as well as exploitation of the same to obtain statistics of the sales of the directories, a CRM was implemented and the Business Object was worked on.
Company: CTBR
Date: May 1991 – February 1996.
Position: SYSTEMS ANALYST – DBA Informix
Participate in the definition of programming and implementation of Payroll, Accounting and Building Control systems.
Take the Informix Administration courses and dedicate myself to the migration of the most important applications (Payroll, Accounting, Building Control) to Informix. Design, data creation and migration were made from the design.
ACHIEVEMENTS.
1- Creation of true and reliable Data Bases to obtain statistics on the behavior of the sales, income of the hiring and the most sold in terms of products and classifications.
2.- Keep the Databases available and stable by 90% and with an adequate performance.
3.- Development and implementation of the Payroll, Accounting and Billing systems
4.- Migration of Systems from one Database to another as well as the transfer of Data without problems
5.- Release of Code new to production without errors.
COURSES
Usuarios MM/3000 Con Lotes Septiembre 1989 Hewlett Packard
INFORMIX SQL Noviembre 1990 Informix
INFORMIX 4GL Noviembre 1990 Informix
UNIX Básico Marzo 1994 Consultoría en Sistemas Abiertos
UNIX Programación del Shell Abril 1994 Consultoría en Sistemas Abiertos
Análisis y Diseño Estructurado Agosto 1996 Stratega Consultores
Developing Procedures, Policies & Documentation Noviembre 1996 Information Mapping
Diseño y Elaboración de Manuales de Operación Octubre 1996 ASEMH
Análisis Estructurado Agosto 1996 Sección Amarilla
INFORMIX SERVER SYSTEM ADMINISTRATION Noviembre 1998 Informix
WORKSHOP WINDOWS 2000 Julio 1998 Microsoft
Supporting Microsoft Windows NT 4.0 Agosto 1998 Hewlett Packard
Administering Microsoft Windows NT 4.0 Agosto 1998 Hewlett Packard
VMS 7.0 Systems & Networks Management I Julio 1998 Global Knoeledge Network
Implementing a Database on MS SQL Server 7.0 Septiembre 1999 Kapellmann Educacion
System Administration for MS SQL Server 7.0 Octubre 1999 Kapellmann Educacion
Supporting MS Windows NT 4.0 Core Technologies Abril 2000 Kapellmann Educacion
Administering MS Windows NT 4.0 Marzo 2000 Kapellmann Educacion
Internetworking MS TCP/IP MS Windows NT 4.0 Junio 2000 Kapellmann Educacion
Supporting MS Windows NT 4.0 Enterprise Julio 2000 Kapellmann Educacion
System Administration MS SQL Server 7.0 Enero 2001 Kapellmann Educacion
Programming SQL Server 2000 Database Julio 2001 Aster Mexico
Introduction A Oracle 8i SQL y PL /SQL Julio 2001 Executrain
Oracle 8i Arquitectura y Administration Julio 2001 ORACLE
Oracle 8i Backup and Recovery Julio 2001 ORACLE
Oracle 8i Afinación del Rendimiento de la BD Julio 2001 Executrain
Oracle 9i Develop Web Based Applications PL /SQL Octubre 2001 ORACLE
Administrating Oracle 9i Application Server Octubre 2001 ORACLE
Implementing MS Windows 2000 Clustering Octubre 2002 Kapellmann Educacion
Oracle 9i Fundamentos DBA I Mayo 2003 ORACLE
Oracle 9i Fundamentos DBA II Mayo 2003 ORACLE
Designing MS Windows 2000 Directory Services Septiembre 2002 Kapellmann Educacion
Managing and Maintaining Windows Server 2003 Enero 2006 Microsoft
Designing Implementing Database SQL SRV 2000 Diciembre 2005 Microsoft
Oracle 11g Database Workshop I Abril 2008 ORACLE
Liderazgo Equipos de Alto Desempeño Septiembre 2009 Axialent
Webshere Application Server V7 Administration Linux Enero 2011 ITERA
Taller para Administradores de Herramientas Enero 2011 ITERA
Using InfoSphere Data Architect Enero 2011 ITERA
Essentials of IBM Rational Build Forge V7.1 Enero 2011 ITERA
SCHOLARSHIP
1983 - 1987
Ingeniería en Computación UNAM.
ADDITIONAL INFORMATION
- Generals: Mexican, Married, 55 years old
- RFC: CORL6311067CA
- Languages: Inglés 50%
- Programs: Excel, Word, Power Point, Data Bases: SQL Server, Informix y Oracle Sybase.
Curriculum simili