Mario A. M. R. freelancer experto en Oracle, SQL Server, WebLogic

SKILLS

•    Oracle RDBMS Installation and configuration, Configuration for UNIX Kernel parameters, Oracle RDBMS Upgrade .
•    SO Basic Configuration task (create users, logical volumes, filesystem, basic security, etc)
•    Installation and configuration for Oracle RAC (12c, 11g, 10g,9i)
•    Installation and Configuration for Oracle OPS (8i)
•    Create large database using row devices (UNIX)
•    Create a database for Data Werehouse.
•    Create Oracle HA enviriments using Clusterware / ASM
•    Installation and Configuration for Oracle Applications 12, 11i, 11.03 and 10.07
•    Upgrade from Oracle Application 11.0.3/ 10.07 to 11i ( 11.5.9)
•    Performance monitoring and fine tuning for Oracle Applications
•    Storage fine tuning using  Oracle Tools (Change Manager) or BMC Tools (Patrol DB Reorg)
•    OA system administration task: create user, create profiles, create and management concurrent process, install customs reports and forms, install modules patches, etc

Wepro Technologies             January ‘ 2008 – Today

Project Name:    BAXTER HEALTCARE DE MEXICO, S.A. DE C.V.
Description:    •    Administration for 60 dataservers ORACLE/SQLServer on Mx/co/Br/Ar/Chl/Ecu
•    Performance Monitoring on Diferernt Non-ERP Application(MSAF/Kronos/Signature)
•    Storage Management and Reorganization large tables
•    Fine tuning on init.ora for use CBO parameters
•    Create technical documentation
Responsibilities:    •    Administration, security, develop and dxecute performance monitoring task and detect all “future” problems
Into 100 Databses (Oracle/SQLServer)

Database:    •    Oracle RDBMS v 11gR2(11.2.0.4), 10gR2(10.2.0.5.0), 9iR2(9.2.0.7.0) EE/SE 32/64Bits
•    SQLServer 2000/2005/2008/2014 EE/SE 32/64Bits
•    MSAF SW, Kronos WF, Signature
•    Interfaces to Oracle JDE / PeopleSoft
•    Oracle Enterprise Manager
    
Platform:    Windows WY2/WY5/WY8/WY12 SRV/PE
Technologies:    Oracle, MS



SYAAT DE MEXICO, S.A DE C.V.  (FreeLance)        AGOST ‘ 2006 – 2008
Oracle Techical Consultant

Project Name:    JANNSEN – CILAG DE MEXICO, S.A. DE C.V.
Description:    •    Performance Monitoring on Oracle RDBMS v 9.2.0.7.0 on SAP/R3 4.7
•    Storage Management and Reorganization large tables
•    Fine tuning on init.ora for use CBO parameters
•    Create technical documentation
Responsibilities:    •    Develop and Execute performance monitoring task and detect all “future” problems into into DB
Database:    •    Oracle RDBMS v 9.2.0.7.0 for Windows 2000 ES 32 Bits based Systems
•    SAP/R3 V4.7
•    Oracle Enterprise Manager
    
Platform:    Windows WY2 ES / WY2Professional
Technologies:    Oracle, MS




Project Name:    COMISION FEDERAL DE ELECTRICIDAD
Description:    •    Performance Monitoring on Oracle RDBMS v 9.2.0.7.0 on SAP/R3 SC 5.0 Enviroment
•    Storage Management and Reorganization large tables
•    Fine tuning on init.ora for use CBO parameters
•    Create technical documentation
Responsibilities:    •    Develop and Execute performance monitoring task and detect all “future” problems into into DB
Database:    •    Oracle RDBMS v 9.2.0.7.0 for Sun Solaris 64 Bits based Systems
•    SAP/R3 SC 5.0
•    Oracle Enterprise Manager
    
Platform:    Sun Solaris and , Windows 2000 Professional
Technologies:    Oracle, Solaris , MS


Project Name:    SABRITAS, S.A. DE C.V.
Description:    •    Proactive technical Support to 197 production databases
•    Create technical documentation
•    Provider technical support to DSK Team
•    Technical Review and Fine Tuning on OA 11.5 ( 3 environments: DSK, TEST and PROD)
Responsibilities:    •    Provide a solutions where DSK tams need
•    Develop and Execute performance monitoring task and detect all “future” problems into into DB
•    Create tables, indexes and database objects where DSK team needs
Database:    •    Oracle RDBMS v 8.1.7.4.0 for HPUX  64 Bits Based Systems
•    Oracle RDBMS v 9.2.0.5.0 for Windows NT/2000/XP 32 Bits Based Systems
•    Oracle Applications 11.5.9
•    Oracle Enterprise Manager
Platform:    HPUX v 11i, Windows 2000 Professional
Technologies:    Oracle, HP, MS



KEENTIS IT  (FreeLance)        OCTOBER – DECEMBER ‘ 2004

Project Name:    SABRITAS, S.A. DE C.V.
Description:    •     Assessment Review on E-Business production enviroment 11.5.5
•    Fine Tunning on Oracle E-Business and Oracle RDBMS v 8.1.7.4.0
•    Create technical documentation
•    Apply MiniPacks and One-On-Patch on OA11i v 11.5.5.
•    Provider technical support to DSK Team
•    Technical Review and Fine Tuning on OA 11.5 ( 3 environments: DSK, TEST and PROD)
Responsibilities:    •    Provide and apply a fine tuning on enviroment production
•    Develop and Execute performance monitoring task and detect all “future” problems into into DB
•    Provide technical documentation
•    Create tables, indexes and database objects where DSK team needs
Database:    •    Oracle RDBMS v 8.1.7.4.0 for HPUX  64 Bits Based Systems
•    Oracle RDBMS v 9.2.0.5.0 for Windows NT/2000/XP 32 Bits Based Systems
•    Oracle Applications 11.5.5
•    Oracle Enterprise Manager
Platform:    HPUX v 11i, Windows 2000 Professional
Technologies:    Oracle, HP, MS




MSG Multi Global Consulting (FreeLance)        April ‘ 2004 – October ‘ 2004
Oracle Techical Consultant

Project Name:    ABN AMBRO BANK, S,A, DE C.V.
Description:    •    Proactive technical Support
•    Create technical documentation
•    Provider technical support to DSK Team
Responsibilities:    •    Provide a solutions where DSK tams need
•    Develop and Execute performance monitoring task and detect all “future” problems into into DB
•    Create tables, indexes and database objects where DSK team needs
Database:    Oracle RDBMS v 8.1.7.4.0 for HPUX  64 Bits Based Systems
Platform:    HPUX v 11i, Windows 200 Professional
Technologies:    Oracle, HP, MS