Uploaded File
Jesus
jislas10@msn.com
425-281-4105
16316 Bridgewalk Dr
Lithia, FL 33547
336-510-7294
Sr. Database Administrator
21 years experience W2
2
Recommendations
Average rating
567
Profile views
Summary

Certified Database Administrator with over 18 years of IT experience in the technology, health care, retail, financial and shipping industries covering all phases of the system development life cycle where database development, design and physical implementation have been my main duties, with a focus on DB2, Oracle and Informix RDBMS administration. I have a solid background in data modeling (logical and physical), dimensional modeling, 3rd normal form, performance tuning for large databases, data warehouses, partitioned databases, table partitioning, database programming, data integrity analysis, and data migration.

Experience
Data Architect
Information Technology
Oct 2016 - Dec 2017
  • Make the proper analysis and design to build a Core-Peoplesoft data warehouse for the Data Analytics team
  • Build Peoplesoft and Key Alerts data marts using 4 fact tables as main drivers to server more than 400 reports
  • Designed Employee and snowflake dimension model using type I dimensions based on requirements
  • Trained ETL and SQL developers physical implementation in Oracle and best practices for Data Warehouse
  • Build range partitioned tables using different table spaces for better performance
  • Explained ETL and SQL developer why “Referential Integrity Not Enable”? Improves performance and allows Oracle optimizer to use faster execution paths, binary joins and Materialize View Log for ETL.
  • Maintained logical and physical data models as well as published HTML reports using Toad Designer
  • In charge of physical implementations and played the DBA role for DDL implementation and use proper table spaces.
  • Explained the importance to coordinate statistics collection around ETL jobs
  • Responsible for performance tuning in the entire project as well as trained people on binary indexing and use of explain plan

Technical environment (Oracle 12c, Toad for Oracle, Toad Designer, Informatica)

Data Architecture Data Marts Data Warehousing Database Design DBA TOAD SQL Performance Tuning Informatica Oracle ETL SQL Developer HTML IDQ
Remove Skill
Sr. Database Administrator Team Lead
Information Technology
Jan 2012 - Sep 2016
  • On call database production support 24/7 for OLAP and OLTP applications
  • Performed multiple Fix Pack and version upgrades for DB2 LUW on HADR and DPF environments.
  • Oracle database administration on windows servers which includes database upgrades on windows cluster with Oracle data guard, ASM, transparent gateway, performance tuning and troubleshot production issues
  • Performance improvement for MicroStrategy reports and ETL processes by analyzing complex explain plans and suggest indexes or SQL changes on both Oracle and DB2 LUW
  • Trained data architects and ETL team members to understand how to use Database Partition Feature (DPF). Explain, what is collocation, MQTs (Replicated and Repartition) and trained DBAs to identify red lights in the explain plan such as BTQ or MBTQ
  • Mentor DBAs on DB2 DPF, DB2 HADR and Oracle ASM
  • Participate in dimensional modeling to solve performance issues related to dimensions type II
  • Performed physical design for fact and dimension tables implementing range and database partitioning using multiple tablespaces per range partition. Also, identify 16K or 32K pages for better performance
  • Migrate multiple Fact and dimension tables from DB2 to Netezza using NZload, NZmigrate, NZsql.
  • Perform DB maintanence and support using NZadmin
  • Create multiple objects and participate in the physical design in the DB migration from DB2 to Netezza
  • Implement incremental backups on data warehouse and staging databases
  • Implement sampling statistics collection to reduce processing time
  • DBA support for HADR environment upgraded and applied fix packs
  • Lower HWM using db2dart for DB2 9.1 and 9.5
  • Lower HWM using Oracle data pump
  • Install and setup Oracle 11g on Windows with ASM
  • Duplicate and recover Oracle databases using RMAN

Technical environment (Oracle 11g, DB2-LUW 9.1, 9.5, 9.7,10.1,10.5 Netezza AIX 6.1, shell scripting, vi editor, Embarcadero, Performance Expert, db2top, Microstrategy)

Oracle DB2 LUW DB2 Netezza Shell Scripts MicroStrategy DBA Database Upgrades DBMS OLTP OLAP Production Support Performance Tuning HADR ETL Data Architecture DB2 DPF Database Backups Data Modeling Logical Modeling Physical Modeling Data Warehousing PostgreSQL Database Partitioning AIX Windows Server Database Design SQL Scripting Windows
Remove Skill
References
Average Rating

2 recommendations
Sr Database Administrator Team Lead
Retail
Jan 2010 - Jan 2012
  • Development DBA responsible for data warehouse implementation on DB2 DPF environment (i-SAS admin and 4 data nodes)
  • Involved in data warehouse (star schema) migration from DB2 i-Series to DB2-LUW in a database partition environment (DPF). A total of 15 fact tables, 40 dimensions and 4 data mart tables
  • Participate in the analysis to migrate part of the data warehouse from DB2-LUW (DPF) to Netezza
  • Migrate multiple Fact and dimension tables from DB2 to Netezza using NZload, NZmigrate, NZsql.
  • Perform DB maintanence and support using NZadmin
  • Designed physical databases (database, buffer pools, table spaces, table partitioning, hash keys, MDC and MQTs)
  • Maintain physical data model using Power Designer
  • Developed shell scripting on AIX with embedded SQL for data marts trickle feeding
  • Helped Cognos developers to improve performance by creating MQTs and improving SQL
  • Participated on cube performance tuning analyzing MDX
  • Involved on large data migration using DB2 load and export utility
  • Supported and mentored Informatica ETL developers to use DB2 load
  • Participated in the backup design for a large database (20 TB) with an average of 40 table spaces
  • Developed shell scripts on AIX for database maintenance (runstats, reorg) and scheduled them in the Unix cron table
  • Monitored and generated results for performance tuning tasks using Unix (vmstat, iostat) and DB2 tools (db2top) and performance expert
  • Analyzed explain plans to improve performance on SQL statements
  • Installed DB2 database servers and clients on Linux, Unix and Windows.
  • Configured HADR for database servers with primary and stand by peer.
  • Participated on Purescale implementation with Queue Replication.
  • Support Informatica and Cognos developers with DB2 load and performance tuning
  • Changed instance owner and was admin password for cubing services console
  • Headed security standards and create document database security for DB2-LUW

Technical environment (Netezza,DB2-LUW 9.7, 10.1, Purescale and Queue Replication, AIX 6.1, shell scripting, vi editor, Power Designer, Performance Expert, db2top, Cubing Services, Cognos, MDX)

DB2 DB2 LUW Shell Scripts Cognos DBA Data Replication Netezza UNIX PureScale Performance Tuning Data Warehousing Data Migration AIX HADR DB2 DPF Powerdesigner SQL ETL DB2 PE Database Design Database Maintenance MDX Physical Modeling Linux Database Backups ETL Developer Informatica Scripting Windows
Remove Skill
Database Services Specialist/Team Lead
Information Technology
Jan 2006 - Jan 2009
  • Developed complex PL/SQL stored procedures using in-line queries, inner and outer joins
  • Created and executed work plans for CPU patches and database upgrades
  • Performed database tuning in the production applications for Oracle (ADDM, AWR) and DB2 (advise, explain plan)
  • Provided 24/7 support to Oracle 10g and DB2 database using Transparent Gateway. Mostly OLTP systems with a very high volume of transactions, such as: loan origination, billing systems, and fraud profiling systems
  • Participated in the annually Business Recovery exercise by restoring Oracle and DB2 production databases and make note of any opportunity areas
  • Saved time by improving Business Recovery process (RMAN and shell scripting).
  • Participated in the assessment and decision making to buy a new data modeling tool
  • Headed logical and physical Data Model migration from Oracle Designer to IDA using CVS
  • Documented logical and physical Data Models on Oracle Designer and IDA with CVS.
  • Creation of packages, sequences, functions, procedures, stored procedures, tables, tablespaces, indexes, and customized views using PL/SQL
  • Mentored DBAs on data modeling best practices
  • Implemented materialized views, MQTs, table and index partitioning for Data Warehouse
  • Participated on lunch and learn activities to share knowledge among the group
  • Organized meetings with technical and non-technical groups to collect and validate requirements
  • Only team member with expertise on Oracle and DB2 databases

Technical environment (Oracle 9i 10g,, PL/SQL, RMAN, Shell scripting, iSeries, DB2-LUW 9.5, AIX 6.1, OTG, Oracle Designer, InfoSphere Data Architect (IDA), CVS, Turnover, RUP, IDEF1X, Clearcase)

Oracle PL/SQL Shell Scripts iSeries DB2 DB2 LUW Oracle Designer DBA Database Upgrades Data Modeling Data Architecture Performance Tuning OLTP RUP Stored Procedure Logical Modeling Physical Modeling ClearCase Turnover Database Design Scripting
Remove Skill
Data Modeler/DBA Lead
Transportation
Jan 2002 - Jan 2006
  • Led a DBA and two Data Modelers, where the four of us support a development team of 30 members
  • Developed a multi-tiered data warehouse, ODS in DB2, staging area and data marts on Oracle 9i.
  • Headed logical and physical Data Model project creation using Erwin and CA Model Mart
  • Successfully implemented functions in Erwin such as: Reverse and forward engineering, generate DDL, HTML and JPEG files in order to maintain the intranet Data Model version
  • Defined standard naming conventions and promote data architecture best practices
  • Developed stored procedures, triggers, and perform database tuning using Oracle 9i and DB2
  • Coordinated efforts with the business analyst group as well as the business users for gathering requirements and validation of business rules (JAD sessions)
  • Process improvement in the department as well as participating in implementation of methodologies
  • Created complex SQL queries for DB2 and Oracle

Technical environment (Oracle 9i, PL/SQL, iSeries DB2 V5R3, Unix Solaris, Erwin, CA Model Mart, Aldon ACMS, RUP, IDEF1X, Clearcase)

Oracle PL/SQL DB2 UNIX ClearCase RUP DBA Data Architecture Data Modeling Erwin Data Modler Stored Procedure Triggers JAD Data Warehousing Data Marts Process Improvement iSeries SQL Business Analysis Requirements Gathering HTML
Remove Skill
Database Developer
Transportation
Jan 2000 - Jan 2002
  • Developed new applications for the maritime system, and sales system using Oracle Forms, Oracle Reports, and PL/SQL developer
  • Successfully implemented military e-booking and Vessel Schedule System which were success factors to close business over $40 millions using ASP, JavaScript, VBScript, and HTML
  • Built complex stored procedures for DB2 and Oracle

Technical environment (Oracle 9i,PL/SQL, iSeries DB2 V5R3, Unix Solaris, Oracle Forms and Reports, VB and Java script, ASP, Shell scripting, RPG, Clearcase)

Oracle DB2 UNIX VBScript JavaScript Shell Scripts ClearCase PL/SQL Stored Procedure iSeries Java SQL HTML Visual Basic SAP SuccessFactors PL/SQL Developer Solaris SQL Developer
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Computer Science
Universidad Autonoma Metropolitana 1995
Attended in Technology and Innovation Management Incomplete
University of Tampa
Certifications
DB2 LUW Certified Advance Database Administrator (734)
DB2 LUW Certified Database Administrator (731)
DB2 LUW Database Associate certification (730)
Oracle 11G certification on SQL Fundamentals I (IZ0-051)
Skills
DB2
2016
15
DBA
2017
14
Oracle
2017
14
Data Architecture
2017
12
Data Modeling
2016
11
Data Warehousing
2017
11
Shell Scripts
2016
11
Performance Tuning
2017
10
ClearCase
2009
9
DB2 LUW
2016
9
iSeries
2009
9
Physical Modeling
2016
9
PL/SQL
2009
9
Scripting
2016
9
SQL
2017
9
Stored Procedure
2009
9
UNIX
2012
8
Database Upgrades
2016
7
ETL
2017
7
HTML
2017
7
Logical Modeling
2016
7
OLTP
2016
7
RUP
2009
7
AIX
2016
6
Database Backups
2016
6
Database Design
2017
6
DB2 DPF
2016
6
HADR
2016
6
Netezza
2016
6
Windows
2016
6
Data Marts
2017
5
Business Analysis
2006
4
Database Partitioning
2016
4
DBMS
2016
4
Erwin Data Modler
2006
4
JAD
2006
4
MicroStrategy
2016
4
OLAP
2016
4
PostgreSQL
2016
4
Process Improvement
2006
4
Production Support
2016
4
Requirements Gathering
2006
4
Triggers
2006
4
Windows Server
2016
4
Informatica
2017
3
Oracle Designer
2009
3
SQL Developer
2017
3
Turnover
2009
3
Cognos
2012
2
Data Migration
2012
2
Data Replication
2012
2
Database Maintenance
2012
2
DB2 PE
2012
2
ETL Developer
2012
2
Java
2002
2
JavaScript
2002
2
Linux
2012
2
MDX
2012
2
PL/SQL Developer
2002
2
Powerdesigner
2012
2
PureScale
2012
2
SAP SuccessFactors
2002
2
Solaris
2002
2
VBScript
2002
2
Visual Basic
2002
2
IDQ
2017
1
TOAD
2017
1
Data Integrity
0
1
Oracle 11i
2016
1
RDBMS
0
1
Languages
Spanish, Fluent/Bilingual