Francisco Marzabal available

Francisco Marzabal

Oracle and IBM DB2 LUW Senior DBA / Engineer

available
Profileimage by Francisco Marzabal Oracle and IBM DB2 LUW Senior DBA / Engineer from
  • Freelancer in
  • Graduation: not provided
  • Hourly-/Daily rates:
  • Languages: English (Limited professional) | Spanish (Native or Bilingual)
  • Last update: 15.03.2018
KEYWORDS
ATTACHMENTS
CV

You need an account to view this information.

SKILLS
CERTIFICATIONS OCP DBA (Oracle certified professional) versions 7.3, 8, 8.i, 9i,10g and 11g.

BIG DATA IBM Certifications
Big Data Foundations Level I
Big Data Foundations Level II
Hadoop Foundations Level I
Hadoop Foundations Level II
Hadoop Adminsitration Level I
Hadoop Administration Level II
Hadoop Data Access Level I
Hadoop Data Acccess Level II
Hadoop Programming Level I
Hadoop Programming Level II
Data Science Foundations Level I
Data Science Foundations Level II
Data Science for Business Level I
Data Science for Business Level II
Statistics 101
Spark Level I
Spark Level II
Scala Programming for Data Science Level I
Scala Programming for Data Science Level II
Python Level I
Python Level II

Experience

COMPLEMENTARY FORMATION
Analyst-Programmer, Samicro academy, A Coruña, Spain
Operating System Unix System V version 4, Unisys ,La Corunna, Spain.
TCP/IP & SNMP, Unisys, Spain, La Corunna.
AS/400 Operating System and Development tools.  IBM partner GSE, La Corunna., Spain.
Oracle Getting Started, Oracle University,  Madrid, Spain.
Develop Applications with PL/SQL, Oracle Education, Madrid, Spain.
Oracle Administration I, Oracle Education, Madrid, Spain.
Oracle Administration II, Oracle Education, Madrid, Spain.
Oracle tuning, Oracle Education, Madrid, Spain.
Oracle 8, the new features for administrators, Oracle Education, Madrid, Spain.
Oracle 8i, the new features for administrators, Oracle Education, Madrid, Spain.
Oracle 9i, the new features for administrators, Oracle Education, Madrid, Spain.
Oracle 10 g, the new features for administrators, Oracle Education, Madrid, Spain.
Oracle 11 g, the new features for administrators, Oracle Education, Madrid, Spain.
Oracle 12 c, the new features for administrators, Oracle Education, Madrid, Spain.
Oracle Advanced Replication, Oracle Education, Madrid, Spain.
Oracle Parallel Server (RAC), Oracle Education, Madrid, Spain.
Develop Applications in Java with Oracle JDeveloper, Oracle Education, Madrid, Spain.
Database access with Java, Oracle University, Madrid, Spain.
Build a data warehouse with Oracle warehouse builder, Oracle University, Madrid, Spain.
Expert Forum, CEL Lexx Hamn: Everything you always wanted to know about optimizer. Oracle University, Madrid, Spain.
Expert Forum, Building your business on the web, Oracle, Madrid, Spain.
Expert Forum, Tuning Internals, Oracle, Madrid, Spain.
Expert Forum, Oracle 9IAS wireless edition, Oracle, Madrid, Spain.
Expert Forum, CEL Tanel Poder, Advanced Oracle Troubleshooting for DBAs & Performance Engineers. Oracle, Madrid, Spain.
Expert Forum, CEL SE Jonathan Lewis: Cost Based Optimization. Oracle, Madrid, Spain.
Expert Forum, CEL Craig Shallahamer: Reactive Performance Management Intensive, Oracle, Madrid, Spain.
Expert Forum, CEL Tom Kyle: New features 11 G, Oracle, Madrid, Spain Expert Forum,
CEL Julian Dyke: the Advanced RAC master class. Oracle Madrid, Spain.
Hands on Forum, Develop Applications and components with Java and Oracle JDeveloper, Oracle, Madrid, Spain.
Hands on Forum, WebDB, Oracle University, Madrid, Spain.
Oracle Sales Champion, Madrid, Spain.
Programming with IBM VisualStudio , IBM Visualage for Java and DB2.
CL2x3. DB2 udb 10 Basic Administration.
CL284 Fastpath to db2 udb versión 10 for Experienced Relational DBAs.
CL720 Oracle to DB2 enablement workshop.
CL493 Db2 udb 10 Advanced Database Recovery.
CL413 DB2 udb 10 performance tuning and monitoring workshop.
CL443 Db2 udb 10  performance tuning and monitoring workshop for single and multiple partition Dbs.
CL800 DB2 9.8 PureScale implementation and control for db2 luw administrators.
CL100 DB2 programming workshop. POT IBM DB2 10.1 HADR and TSA (V1.2) .
POT New features db2 version 10. POT DB2 LUW advanced recovery solutions.
POT DB2, Know what your CPU is doing: Take Control with WLM Dispatcher.
POT DB2 10.5 Tools. POT IBM DB2 LUW* Performance Management Tools (v3.2) .
POT Discovering the value of IBM DB2 Compression.
POT IBM DB2 10.5 pureScale.
POT Step-by-Step Performance Management for IBM DB2 Advance Enterprise Server Edition.
POT IBM LUW* Performance Management Tools (v3.2).
POT Discovering the Value of IBM Enterprise Report Management featuring IBM Content Manager OnDemand.
Course CL 463 DB2 DB2 LUW Advanced Administration with DB2 BLU Acceleration.
DB2 indepth Técnical Class.
AN52 ERC 1.1 Advanced Tools for AIX Performance Anlisys.
AN40 ERC. 1.1 Aix SAN management I: Administration
AN15 ERC 3.0 Power System for AIX III: Advanced Administration and Problem Determination
AN51G ERC 5.2: Power System for AIX IV: Performance Management.
Course was855. Websphere Application Server Administration.
Course was592. Websphere Application Server Problem determination
Course was815. Websphere Application Sever, Performance tuning.
Big Data 101, IBM Cognitive Class.
Spark Fundamentals I, IBM Cognitive Class.
Spark Fundamentals II, IBM Cognitive Class.
Hadoop 101, IBM Cognitive Class.
MapReduce and Yarn, IBM Cognitive Class.
Moving Data into Hadoop, IBM Cognitive Class.
Accessing Hadoop data using Hive, IBM Cognitive Class.
Apache Pig 101, IBM Cognitive Class.
implifying data pipelines using Apache Kafka, IBM Cognitive Class.
Controling Hadoop Jobs using Oozie, IBM Cognitive Class.
Developed distributed applications using Zookeeper, IBM Cognitive Class.
Solr 101, IBM Cognitive Class.
Using Hbase for real-time access your Big Data, IBM Cognitive Class.
SQL access for Hadoop, IBM Cognitive Class.
Data Science 101, IBM Cognitive Class.
Data Science Hands-on with open source tools, IBM Cognitive Class.
Data Science Metodology, IBM Cognitive Class. R 101,
IBM Cognitive Class. Data privacy fundamentals,
IBM Cognitive Class. Digital analytics and regression, IBM Cognitive Class.
Predictive modeling fundamentals, IBM Cognitive Class.
Scala 101, IBM Cognitive Class.
Spark overview for Scala Analytics
Data Science with Scala
Spark Mlib
Exploring Spark GraphX
Analyzing Big Data in R using Apache Spark
General English Intermediate level St. Giles International Brighton, U.K.
General English Upper-Intermediate level St. Giles International Brighton, U.K.
General English Advance level St. Giles International Brighton, U.K.


2013-2017 Freelance, I used to work as IBM AVS for DB2 Luw and Oracle specialist. Diferent projects in customers:
AVS (extended suppport) for DB2 in Inditex, Websphere commerce and  internal applications.
Tirea (Insurance Company) Oracle 11g migration to IBM DB2 for LUW, the main task were support/convert for OLTP (Pro*C) applications and PL/SQL migration, SQL Plans test and performance issues.
El Corte Inglés Sterling Commerce for DB2 support. Oracle support for internal application with latch issues.
Vodafone. The task were, Planning and implentation de IBM Unica application. Hardware definition (Linux RedHat Intel 64 bits processador), Oracle instalation, ASM instalation. Tuning Unica application and Oracle DBMS.
RTVE (public spanish Television), Support for DB2 for LUW and help dba teams for Oracle support, Implementaion OEM and Zabix SNMP monitoring, Tuning and support  for diferents Oracle database versions, RAC and RMAN.
ING financial Institution, support for IBM Unica and Oracle performance.
Anekis, instalation and definition Datawarehouse in Oracle 11G, the main task were Block size definition, ETL definition, Star Schema definition and Tunig issues. IBM Cognos task.
Mayoral retail company DB2 LUW support Oracle advices and support for issues.

20012-2013 Oracle and DB2-LUW Team leader of DBA team in Credit Andorra Bank. I used to work with Oracle 11g and Bank ERP Avaloq, DB2 UDB fo LUW version 9 credit-card systems, Oracle VLDB size few PetaBytes.

2008-2011 Oracle and DB2-LUW Team leader of DBA team in Santader- Bank. Working with DB2-UDB for AIX, Windows and Linux. Partition Database and HADR technology. Support for develop team. Working with Websphere Application Server, versions 6.x and 7.x. Oracle RAC, Grid Computing and Dataguard, different versions ERP and BI.

2006-2008 Oracle and DB2-LUW Administrator in Corte Ingles. Operating system AIX 5L, HACMP, Cluster, Backup Software Tivoli Storage Manager. Oracle 11.1 and 11.2 RAC, Grid computing., RMAN, DB2- Partition Option and HADR and db2connect Zlinux. Sap, Siebel.
2005-2006. DB2-UDB Administrator in Santader- Bank (BSCH). Working with DB2UDB for AIX, Windows and Linux. Partition Database and HADR technology. Support for develop team. Working with Websphere Application Server, versions 5.x and 6.x., Oracle with RAC, RAM, Grid Computing

2004-2005. Solium-Center, this company belongs to Bilbao-Vizcaya Bank (BBVA), Accenture and Telefonica Data, Administrator Senior Oracle and DB2-UDB version 7.x for AIX 4.x and HACMP 4.3, DB2 for Solaris. Migration from these versions to DB2UDB version 8.x, Aix 5.x and HACMP 5.1, DB2 for Solaris, implement the geographic backup system for databases, HADR technology. Oracle Administrator version 9, 10.1
and 10.2. RAC, RMAN, OEM and Standby and Dataguard. Databases with  SAP ERP and Siebel CRM

2002- 2004, Freelance, Developing application for management and invoices, implement the solution with Websphere  application server developer (java), Visualage for java, Visualage for C/C++, digital signature, DB2-UDB for Windows version 7.x.

1999- 2002 Sermatica Oracle Partner. This company belong to Pastor Bank, DBA Oracle Senior and DB2/400. different projects. La Corunna Council, migration from Microsoft Windows and SQL-Server to Digital Tru64 and Oracle. Maersk Spain, Administration Oracle RAC, RMAN, OEM, Standby Dielectro-Galicia, Oracle Administrator, RMAN,OEM, Advanced Replication. Implementation of BI for different companies, Oracle Warehouse Builder, Oracle Designer. 1996- 1999. European Card Services, System Analyst, for implement the Credit-card solutions. Encrypt protocols DES, RSA, Specific hard for PIN generation, programming PL/SQL, C language and Pro*C, sockets, Shared memory, Queues, RS-232, X.25, TCP/IP Sockets interfaces. Operating system AIX versions 3.x and 4.x, Unix scripting, and Microsoft Windows, Oracle databases. In this company we developed the application for processing Mastercard credit card, we used in version 7.3 referential integrity, triggers, PL/SQL procedures, it was the first Oracle version that it integrated these new technologies.

1992-1996. Sermatica, this company belong to Pastor Bank, different projects with distinct technology. Xunta Galicia , Administrator Unix System V, OLTP Tuxedo, Informix, TCP/IP, SNMP, Unix scripting, different hardware ATT hubs, Cisco Routers, Unisys computers. SEAT Consulting for application, support users and application, environment AS/400, RPG VI, DB2/400. Pastor Paris Bank, Programmer-Analyst, AS/400 RPG VI, COBOL 400, DB2/ OS2 versions 1.1 and 2.1, Rexx language. APPN and APPC Networks. LAN and WAN technology.

1991-1992, ALP Electronic, maintenance networks, computers and devices, working with operating systems Xenix and MS-DOS, Windows 3.1.
PROJECT HISTORY
Pending references
YOUTUBE - VIDEO
YouTube Profil Oracle and IBM DB2 demos spanish channel
GET IN TOUCH

Message:

Sender: