DB2 Solution Expert - Chris Fierros
Objective
Database projects implementing DB2 Universal Database (UDB) technologies including Workgroup Edition,
Enterprise Edition, Enterprise Extended Edition (EEE), and Enterprise Server Edition (ESE) on distributed
client server open systems platforms with DB2 UDB for Linux, UNIX, and Windows.
Profile
Over ten years database related experience with DB2 distributed client server open systems platforms. IBM
Certified Advanced Database Administrator – DB2 UDB v8.1 and IBM Certified Solutions Expert (ICSE) in
DB2 UDB Administration, Replication, Clustering, DRDA, and Development with extensive hands on experience including:
Server installation, configuration, and upgrade experience on single processor, symmetrical
multiprocessing (SMP), massively parallel processor (MPP), cellular multiprocessing (CMP), and
nonuniform memory access (NUMA) systems with enterprise storage area networks (SAN). Client installation, configuration, and upgrade experience using both interactive and unattended install
profiles for users, developers, and administrators. Instance and database creation, configuration and tuning experience in single node non-partitioned
(EE), multiple node partitioned (EEE), and multiple logical node (MLN) partitioned database servers configurations. Client/server communications experience using TCP/IP, NetBios, SNA (APPC), IPX/SPX, and Fast
Communications Manager over System Area Networks with TCP/IP and VIA protocols. Database maintenance experience with Reorg, Runstats, Rebind, Export, Import, Load, Auto-load,
Backup and Restore utilities. Scripting experience using SQL and DB2 Administration API with IBM Object REXX, Windows Shell
Scripts, and JScript with Windows Scripting Host (WSH) interfaces. Database backup, restore, and roll-forward recovery experience using advanced recovery techniques.
High availability (HA) experience implementing Microsoft Clustering Services (MSCS) for fail over
recovery in both a SCSI and SAN attached disk subsystems environment. Database monitoring and tuning experience using DB2’s Performance Monitor, Snapshot Monitor,
Event Monitor, Explain, Visual Explain, and Index Advisor performance tools. System and database security and data auditing experience using table definitions, triggers, data
replication, and the DB2 Audit Facility. Stored procedure, user defined function, and user defined table functions experience with JAVA
Development Kit (JDK). Database benchmarking experience using Quest Software Benchmark Factory and Mercury
Interactive Load Runner benchmarking tools. Problem identification, management, and resolution experience with DB2 diagnostics, trace facilities,
database analysis reporting tool (DART), and DB2 “Backdoor” debugger. Distributed relational database architecture (DRDA) and data replication experience using IBM’s DB2
Connect and DB2 Data Replication to interface with mainframe databases. Database analysis and design experience using Power Designer Data Architect, Embarcadero
ER/Studio, and Computer Associates ERwin.
Accomplishments
Author of Doing More with More - The New and Improved DB2 UDB v8.2 published August 2004 by
DB2 Magazine (www.db2mag.com). Author of More Scripting with DB2 UDB for Windows published June 2004 by IBM DB2
DeveloperWorks website (www.ibm.com/developerworks/db2). Author of DB2 UDB Scripting with Windows Scripting Host article published November 2003 by IBM
DB2 DeveloperWorks website (www.ibm.com/developerworks/db2). Speaker on Scaling DB2 UDB on Windows Server 2003 at IBM's eServer xSeries 2003 Technical
Conference, Orlando, FL. Co-author of IBM Redbook Scaling DB2 UDB on Windows Server 2003 published September 2003 by
IBM International Technical Support Organization, Almaden Research Center, San Jose, CA (www.ibm.com/redbooks). Technical Editor for Learning DB2 Universal Database by Susan Visor and Bill Wong published
August 2003 by SAMS Publishing. Instructor of A Technical Introduction to DB2 Universal Database v6 and v7 July 2003, February 2003,
and March 2002. Author of An Introduction to DB2 UDB Scripting on Windows article published July 2003 by IBM DB2
Developer Domain (www7b.boulder.ibm.com/dmdd). Author of DB2 UDB v8.1 Exploitation of Windows Environments published January 2003 by IBM
International Technical Support Organization, Almaden Research Center, San Jose, CA. Subject Matter Expert on IBM Professional Certification Program for IBM Certified Advanced
Technical Expert - DB2 UDB 8.1 Advanced Database Administration for Linux, UNIX, and Windows. Author of Scaling Up on Windows 2000 published July 2002 by DB2 Magazine Online.
Speaker on Scaling-Up on Windows 2000 Datacenter Server at International DB2 Users Group (IDUG)
2002 North America conference, San Diego, CA.
Certifications
IBM Certified Advanced Database Administrator – DB2 UDB v8.1 IBM Certified Solutions Expert - DB2 UDB v7.1 Database Administrator IBM Certified Solutions Expert - DB2 UDB v7.1 Application Developer IBM Certified Advanced Technical Expert – DB2 Clustering (EEE) IBM Certified Advanced Technical Expert – DB2 Replication (DPROPR) IBM Certified Advanced Technical Expert – DB2 Connect (DRDA)
Education
|
