Oracle and IBM DB2 LUW Senior DBA / Engineer

CERTIFICATIONS OCP DBA (Oracle certified professional) versions 7.3, 8, 8.i, 9i,10g, 11g., 12c and 2019 (18c & 19c)

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 12c R1 ed1 new features for administrators 12c R1, Oracle online learning library.
Oracle 12c R2 ed2 new features for administrators 12c R2, Oracle online learning library.
Oracle 12c Analytic SQL for Datawarehousing, Oracle online learning library.
Oracle 19c new features for administrators, Oracle online learning library.
Oracle 21c new features for administrators, Oracle online learning library.
Oracle 19c Backup and Recovery, Oracle online learning library.
Oracle 19c Multitenant Architecture, Oracle online learning library.
Oracle 19c Performance management and tuning, Oracle online learning library.
Oracle 19c Dataguard Aministration Workshop, Oracle online learning library.
Oracle 19c Clusterware Aministration Workshop, Oracle online learning library.
Oracle 19c ASM Aministration Workshop, Oracle online learning library.
Oracle 19c RAC Aministration Workshop, Oracle online learning library.
Oracle 12c RAC and Data Guard Integration Workshop, Oracle online learning library.
Oracle 19c SQL Tuning workshop, Oracle online learning library.
Oracle Introduction to Oracle Security, Oracle online learning library.
Oracle Database Security, preventive controls. Oracle online learning library.
Oracle Database Security, detective controls. Oracle online learning library.
Oracle 19c Security Fundamentals, Oracle online learning library.
Oracle 19c Data Confidentiality, Oracle online learning library.
Oracle 19c Data Encryption, Oracle online learning library.
Oracle 19c Monitoring and Maintaining a Secure Environment, Oracle online learning library.
Oracle 12c Unified Directory Administration, Oracle online learning library.
Oracle Exadata Database, Implementation and Adminnistration. Oracle online learning library.
Oracle Exadata Database, X9M Whats´s new. Oracle online learning library.
Build a data warehouse with Oracle warehouse builder, Oracle University, Madrid, Spain.
Oracle Database 19c: Data Warehousing Concepts, Oracle online learning library.
Oracle Database 19c: Data Warehousing Techniques, Oracle online learning library.
Oracle Database 19c: Partitioning in Data Warehouse, Oracle online learning library.
Oracle Database 19c: Data Mining Techniques, Oracle online learning library.
Oracle Database 12c: Analytic SQL for Data Warehousing, Oracle online learning library.
Oracle 19c: Big Data Fundamentals, Oracle online learning library.
Oracle 19c: Understanding Data Lakes, Oracle online learning library.
Oracle GoldenGate 19c Fundamentals, Oracle online learning library.
Oracle GoldenGate 19c Troubleshooting and Tuning, Oracle online learning library.
Oracle GoldenGate 12c Integrate for Big Data, Oracle online learning library.
Oracle GoldenGate 12c Advanced Configuration for Oracle, Oracle online learning library.
Oracle Implement Machine Learnig using Oracle Data Miner, Oracle online learning library.
Oracle 19c: Predictive Analysis using Oracle Data Mining, Oracle online learning library.
Oracle 12c: R Enterprise Fundamentals, Oracle online learning library.
Oracle 19c: Python for Data analytics and Machine Learning, Oracle online learning library.
Oracle Database 19c: Advanced PL/SQL, Oracle online learning library.
Object-Oriented Analysis and Design Using UML, Oracle online learning library.
Data Modelling and Design, Oracle online learning library.
Develop Applications in Java with Oracle JDeveloper, Oracle Education, Madrid, Spain.
Database access with Java, Oracle University, Madrid, Spain.
Java SE: Programming I, Oracle online learning library.
Java SE: Programming II, Oracle online learning library.
Developing Applications for the Java EE, Oracle online learning library.
Develop Web services and Microservices with Java, Oracle online learning library.
Java EE Front-end Web Application Development, , Oracle online learning library.
Java Performance Tuning, Mission Control & Flight Recorder, Oracle online learning library.
Developing Web Apps with JavaScript, HTML5, and CSS, Oracle online learning library.
Oracle Cloud APEX Developer Foundations, Oracle online learning library.
Build Web Apps using Oracle Database and APEX Workshop, Oracle online learning library.
Oracle Application Express (APEX) Workshop I, Oracle online learning library.
Oracle Application Express (APEX) Workshop II, Oracle online learning library.
Oracle Database Appliance, Release 18c Overview. Oracle online learning library.
Oracle 12c database: Deploy, patch and update workshop, Oracle online learning library.
Oracle Enterprise Manager Cloud Control 13: Install & Upgrade, Oracle online learning library.
Using Oracle Enterprise Manager Cloud Control 13c, Oracle online learning library.
Oracle Advanced Replication, Oracle Education, Madrid, Spain.
Oracle Parallel Server (RAC), Oracle Education, Madrid, Spain.
Expert Forum, 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 Julian Dyke: the Advanced RAC master class. Oracle Madrid, Spain.
General English Intermediate level St. Giles International Brighton, United Kingdom.
General English Upper-Intermediate level St. Giles International Brighton, United Kingdom.
General English Advanced level St. Giles International Brighton, United Kingdom.
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.
AN49 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.
AN52 ERC 1.1 Advanced Tools for AIX Performance Anlisys.
Was855. Websphere Application Server Administration.
Was592. Websphere Application Server Problem determination
Was815. Websphere Application Sever, Performance tuning.
Big Data 101, IBM Cognitive Class.
Spark Fundamentals I, 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.
Simplifying 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.
Pyton for Datascience, IBM Cognitive Class.
Mathematical Optimization for Business Problems, IBM Cognitive Class.
Data analysis with Python, IBM Cognitive Class.
Data visualization with Python, IBM Cognitive Class.
R for databases, IBM Cognitive Class.
Data visualization with R, IBM Cognitive Class.
Deep Learning Fundamentals, IBM Cognitive Class.
Deep Learning with Tensorflow, IBM Cognitive Class.
Accelerating Deep Learning with GPU, IBM Cognitive Class.
Foundation Series Performance Optimization RedHat EX442. O'Really.
Foundation Series Linux Troubleshooting Red Hat EX342. O'Really.
Serverless fundatmentals for mircorservices. O'Really.
Introduction microservices, O'Really.
Docker Foundamentals. O'Really.
Effective DevOps and Development with Docker. O'Really

CAREER HISTORY
2021-10 Allegis Group, project in Swiss investment bank, the role is Data leader, the environments are Oracle RAC, Oracle Exadata, Temenos banking ERP, IBM DB2 for Z/OS, SQL, PL/SQL and R, the main task are migration Temenos  application to IBM
DB2 for Z/OS, physical database design, definition and design of migrations data plans, Extraction-Transformation and Load. Aditional tasks are Oracle SQL sentences tuning, reindexing and another technics.
2018-2021 EPAM, projects in Swiss Investment Bank. Application Dba task with
Oracle, DB2 for LUW, SQL, PL/SQL, QA, Datawarehouse ETL, reporting and
analitics.
2014/6-2018/06 Freelance, I used to work as IBM AVS for DB2 Luw, IBM Content on
Demand and Oracle specialist. Diferent projects in some customers:
AVS (Add value support) for DB2 in Retail company, Websphere commerce
and internal applications. Supporting development, business analyst and DBA
Team.
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.
Retail Company Sterling Commerce for DB2 support. Oracle support for I
nternal application with latch issues. Tunnig, Support Development and
Bussines analysts
International Telco company. 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.
Public spanish Television, Support for DB2 for LUW and support dba team
for Oracle support, Implementaion OEM and Zabix SNMP monitoring, Tuning
and support for diferents Oracle database versions, RAC and RMAN.
Financial Institution, support for IBM Unica and performance Oracle database.
Marketing Company, 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.
Retail company DB2 LUW and Oracle support and incident management.
2013/6-2014/06 IT company, I used to work as IBM AVS for DB2 Luw, IBM Content
on Demand. Diferent projects in some customers:
AVS (Add value support) for DB2 in Retail company, Websphere commerce
and internal applications. Supporting development, business analyst and DBA
Team.
Public spanish Television, Support for DB2 for LUW and support dba team
and Zabix SNMP monitoring.
2012-2013 Oracle DBA in financial instituion in Andorra. Oracle 11g, Dataguard, RAC,
ASM, Grid Control and Avaloq ERP. Tables with more than 1 billion of rows and 400
transactions by second. We used the ITIL methodology to manage the incidents and
problems, I have done tasks such as support the develop team, design schema,
programming SQL and PL/SQL.
2008-2011 Oracle and DB2-LUW DBA team leader in a spanish International Bank. I
used to work with DB2-UDB for AIX, Windows and Linux. Partition Database and
HADR technology. IBM Content on Demand, Support develop team. I have worked
with Websphere Application Server, versions 6.x and 7.x. Oracle RAC, Grid Computing
and Dataguard, different versions ERP and BI with Sap and PowerCenter. the ITIL
methodology have been used in the incidents and problems, I have done tasks such as
support the develop team, design schema, programming SQL, PL/SQL and Java
(JDBC).

2006-2008 Oracle and DB2-LUW Administrator in Retail Company. Operating system
AIX 5L, HACMP, Cluster, Backup Software Tivoli Storage Manager. Oracle RAC, Grid
computing., RMAN, DB2- Partition Option and HADR and db2connect Zlinux. Sap,
Siebel. ITIL methodology to manage the incidents and problems, I have done tasks such
as support the develop team, design schema, programming SQL, PL/SQL and Java
(JDBC)
2005-2006. DB2-UDB Administrator for Financial Institution. Working with DB2-UDB
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, I used to work with ITIL methodology to
manage the incidents and problems. I have supported the develop team, design schema,
programming SQL, PL/SQL and Java (JDBC).
2004-2005. IT company, this company belongs to spanish finantial institution,
Administrator DB2-UDB version 7.x for AIX 4.x and HACMP 4.3, DB2 for Solaris
Migration from these versions to DB2-UDB version 8.x, Aix 5.x and HACMP 5.1, DB2
for Solaris, implement the geographic backup system for databases, HADR technology
Oracle Administrator. RAC, RMAN, OEM and Standby. Databases with SAP ERP and
Siebel CRM.
2002- 2004, Freelance, I have developed application for management and invoices,
implement the solution with Websphere application server developer (java), Visualage
for java, Visualage for C/C++, CA and certficates X.509 for digital signature, DB2-
UDB for Windows version 7.x.
1999- 2002 Oracle Partner. DBA Oracle and DB2 for Windows and AIX,
DB2/400, different projects.
Migration internal applications (settlement, clearing, accounting) from AS/400
to Oracle.
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
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.
1992-1996. IT company, this company belong to spanish Bank, different projects with
with distinct technologies and roles, system administrator with TUXEDO, Informix,
Unix System V, Network administrator in protocols TCP/IP, SNMP for Hardware and
software monitoring. System administrator for AS/400
1991-1992, ALP Electronic, maintenance networks, computers and devices, working
with operating systems Xenix and MS-DOS, Windows 3.1.

LANGUAGES
English Advanced Level.
Spanish Native.
German basic level (A2) , currently I am studying it