Mariano Pachame available

Mariano Pachame

SAP BASIS and DBA DB2

available
Profileimage by Mariano Pachame SAP BASIS and DBA DB2 from BuenosAires
  • 1001 Buenos Aires Freelancer in
  • Graduation: System Analyst
  • Hourly-/Daily rates: not provided
  • Languages: English (Limited professional) | Spanish (Native or Bilingual)
  • Last update: 17.06.2013
KEYWORDS
SKILLS
Proffesional Experience

1997 to 1998
DaimlerChrysler Argentina S.A
Job: First level of technical support on Windows environment, Novell, MS-Office and PC repair.

1998 to 1999
DaimlerChrysler Argentina S.A
Job: Help Desk.
Area: TOS (Telecommunications and operative systems)
1999 until 2003

DaimlerChrysler Argentina S.A
Job: Database Administrator and System Programmer.
Area: TOS (Telecommunications and operative systems)

Job Description:

- Definition of new structures and modification of them already existing, covering the requirements received of the responsible analysts.
- Analysis of the performance and tuning of the processes to detect possibility of improvements and offers the most suitable solution.
- Administration the security of the database systems, in order to limit the access, in conformity with the requirements received of the analysts responsible for the application.
- Administration the backup and restore of the database systems in all the platforms. Installation/migration and maintenance all the database systems in any plataform that the DBMS resides.
- I develop all these functions for such RDBMS like: DB2 for OS/390, DB2 UDB for UNIX, Informix for UNIX, Oracle for NT and SQL Server.

2002 until 2005
OSDE Group
Job part-time (6 hs per day): Database Administrator and SAP R/3 BASIS Administration.
Area: Technology

Job Description:

- Advice in analysis of performance and tuning, backup/restore for IBM DB2 UDB with HP-UX.
- Advice in SAP\'s administration R/3 BASIS 4.6D / 6.10 with DB2 UDB for UNIX.
- Installation, configuration and tuning of all the databases with DB2 UDB installed in the company, without import the platform in which resides.


2003 until 2005
Argencard S.A (Mastercard Argentina)
Job: Database Administrator and SAP BASIS administrator
Area: Technology

Job Description:

- Definition of new structures and modification of them already existing, covering the requirements received of the responsible analysts.
- Analysis of the performance and tuning of the processes to detect possibility of improvements and offers the most suitable solution.
- Administration of the safety system of the database systems, in order to limit the access, in conformity with the requirements received of the analysts responsible for the application.
- Administration the backup and restore of the database systems in all the platforms. Installation/migration and maintenance all the database systems in any plataform that the DBMS resides.
- I develop all these functions for such RDBMS like: DB2 for OS/390, DB2 UDB for UNIX, Informix for UNIX, Oracle for NT.
- Tuning of databases on UNIX and Windows.

2005 to 2007

IBM Argentina
Job: Database Administrator and SAP BASIS Administration.
Area: IBM Global Delivery Center Argentina (Data Management)

Job Description:

- Technical support for installations with DB2 UDB 6.x, 7.x, 8x and 9.x on different operating systems UNIX and Windows. These facilities are located in Europe, specifically in Spain where Spanish customers are outsourcing their equipment to IBM Spain. The administration of all databases, is done directly from Argentina
- Technical Support for installations with SAP BASIS SAP 4.6x/4.7x, ECC 5.x and 6.0. Installations, migrations, heterogeneous / homogeneous copies, monitoring, troubleshooting, tuning, etc.

2007 to 2010

IBM Argentina
Job: Distributed Database Team Leader
Area: IBM Global Delivery Center Argentina (Data Management)

Job Description:

- Technical support for installations with DB2 UDB 6.x, 7.x, 8x and 9.x on different operating systems UNIX and Windows. These facilities are located in Europe, specifically in Spain where Spanish customers are outsourcing their equipment to IBM Spain. The administration of all databases, is done directly from Argentina
- Technical Support for installations with SAP BASIS SAP 4.6x/4.7x, ECC 5.x and 6.0. Installations, migrations, heterogeneous / homogeneous copies, monitoring, troubleshooting, tuning, etc.


2007 until today
Grupo OSDE
Job: Database Administrator and SAP BASIS Admininstrator
Area: Technology

Job Description:

- Advice in analysis of performance and tuning, backup/restore for IBM DB2 UDB with HP-UX and Solaris.
- Advice in SAP\'s administration for SAP ECC 6.0, PI 7.1, CRM 5.0 DB2 LUW
- Installation, configuration and tuning of all the databases with DB2 UDB installed in the company, without import the platform in which resides.

Technical knowledges:

- Computer Associates CA IDMS 12.0, 14.0:
Experience 4 years

- IBM DB2 UDB para UNIX / 390 / NT 6.0, 7.2, 8.1, 9.1 y 9.5:
Experience 10 years

- IBM IMS 4.1, 5.1 and 6.1:
Experience 2 years

- IBM AIX 4.x, 5.x:
Advanced managing - Experience 8 years

- HP HP-UX 11.x:
Advanced managing - Experience 6 years

- Sun Solaris 9.x, 10:
Experience 5 years

- IBM OS/390 1.3, 2.5, 2.11:
Experience 4 years

- Informix RDBMS 7.x for UNIX/NT:
Advanced managing - Experience 4 years

- Oracle RDBMS UNIX / NT version 7, 8i:
Experience 2 years

- Linux RedHat / SUSE:
Experience 8 years

- TSM Tivoli Storage Manager 3.7 / 5.1
Experience 5 years

- AIX Workload Manager
Advance managing - Experience 2 years

- SAP BASIS 3.0x, 4.5x, 4.6x, 4.7, ECC 5.0, 6.0
Advanced managing - Experience 9 years

Courses/Seminars and Certifications:

Ä Introduction to Oracle SQL and PL/SQL.
Ä DB2 Fundamentals
Ä DB2 OS/390 System Administration
Ä DB2 OS/390 Database Administration
Ä DB2 UDB Administration for UNIX/NT
Ä MVS/ESA Facilities
Ä OS/390 System Operations
Ä SAP R/3 System Administration Technical Core Competence
Ä SAP R/3 Workload Analysis and Tuning
Ä CCNA from Cisco Networking Academy
Ä Presentation of Oracle 9i
Ä Presentation of DB2 UDB Version 7
Ä SAP NetWeaver Database Operation (DB2 UDB for Unix, Windows and Linux
Ä IBM DB2/SAP Bootcamp

Realized projects

- Participation in the migration of platform for SAP of OS/390 to RS/6000.
- Participation in the project of Y2K
- Participation in the project of integration of Chrysler\'s SAP into Mercedes Benz Argentina’s SAP system
- Migration of the SAP FI-CO-MM-SD of 3.0F to 4.6C SR1
- Migration of the SAP HR of 4.5B to 4.6C SR1
- SAP\'s installation CRM 2.0C
- SAP\'s installation BW 2.1C
- Migration of DB2 UDB version 2 to 5.2, in environment productive SAP.
- Migration of DB2 UDB version 5.2 to 6.1, in environment productive SAP.
- Migration of DB2 UDB version 6.1 to 7.2, in environment productive SAP.
- Installation and migration of TSM Server version 3.7 to version 5.1, and installation of clients/API\'s in AIX, NT, Windows 2000, Linux, SQL Server, DB2 UDB, Informix and Oracle.
- Installation, migration and tuning of SAP R/3 databases with DB2 UDB 7.2 in HP-UX 11i.
- Migration of SAP R/3 4.0B to SAP Enterprise 4.7 with DB2 ESE V8 for Linux
- I teach a course of Database Administration of DB2 V8 in New Horizons Institute from Argentina, Buenos Aires.
- Migration of SAP R/3 4.6C to SAP ECC 6.0 with DB2 ESE V8 for HP-11 to Solaris 10 with DB2 V9.1
- Migration of CRM 3.0 to CRM 5.0 with DB2 ESE V8 for HP-11 to Solaris 10 with DB2 V9.1
- Installation and configuration of SAP Netweaver PI 7.1 on mixture arquitecture (Database server on DB2 V9.5 in Solaris 10 and Applications Servers on Redhat Enterprise 5.5)
PROJECT HISTORY
Lic. Osvaldo Rucco, DaimlerChrysler Argentina: Phone +54-11-4808-8749.

Marcelo Giusti, OSDE: Phone +54-11-4310-5000.

Lic. Gabriela Lachowicz, Argencard: Phone +54-11-4340-9800

Lic. Eric Roman Racero, IBM Argentina: Phone +54-11-4898-4898
TIME AND SPATIAL FLEXIBILITY
Travel two o three weeks per year
GET IN TOUCH

Message:

Sender: