Peningo Systems, Inc.

Resume of Candidate: PEN178

Netezza Consultant  - IBM Specialist - PureData System for Analytics


Database Administrator (DBA) specializing in performance tuning and troubleshooting, with a broad technical background including system and network
administration and programming, and experience from architecture design to deployment to on-going operations of IT systems.  My key skills include:
·        Database Administration (DBA):  DB2, Oracle, Netezza
·        System Administration:  AIX, Linux, Windows
·        Programming:  Perl, shell scripting, SQL, C/C++


Oracle Database 10g and 11g Administrator Certified Professional (OCP), IBM Certified Database Administrator - DB2 10.1 and 10.5, IBM Certified
Specialist - PureData System for Analytics (Netezza) 7.0


04/2009-12/2015        Senior Database Administrator        System Engineering
Database administrator for Oracle, DB2, and Netezza databases with a focus on architecture and performance tuning.  Responsible for about 40 Oracle
databases, 300 DB2 databases, and 200 Netezza databases.
·        Migrated Oracle databases from Oracle 10gR2 on Solaris in Florida to 11gR1 RAC on Linux in California with Data Guard for DR, with a production
outage of only 24 hours vs. the application team’s estimated 80 hours.  Performance on RAC was measured as 10 to 100 times faster depending on the
operation.  Implemented NetApp SnapManager for Oracle (SMO) for backups and non-prod database refreshes.  Planned an Oracle 12c upgrade for the
RAC with a migration to HP 3PAR storage.
·        Received recognition from multiple managers outside of the System Engineering department for excellent services in performance turning and
trouble shooting.  For example, reduced execution time from 1 day per day to 100 seconds per day for an agent facing database, enabling insurance
agents to search by names in seconds rather than hours. There are five such examples.
·        Upgraded Netezza Mustang 4.6 servers to TwinFin 6.0 and 7.1, instituted incremental backups, created an automated solution to keep DR databases
in sync with production, and automated QA refreshes from production.  Added a Striper 7.1 server and migrated QA databases there.
·        Upgraded DB2 databases from 8.2 to 9.1, then 9.5, 9.7, 10.1, and 10.5, including ESE to AESE upgrades.  Used HADR and Tivoli System Automation
(TSA) and PowerHA (formerly HACMP) with disk failover for fault tolerance, and Q Replication to maintain the main production reporting database.  
Implemented NetApp snapshot backups for production database and clones for stage refreshes.
·        Monitored and managed databases with Oracle Enterprise Manager, IBM Data Server Manager, and Foglight.
·        Used ERwin and Toad Data Modeler for data modeling.
·        Trained operators and developers in DB2 administration to build a group of junior DBAs.

01/2008 to 09/2008        Database Administrator        Mercury Insurance
    Pacific Technical Staffing        Brea, CA
Database administrator for DB2 databases.
·        Created the Mercury Enterprise Data Warehouse DB2 DPF database, and worked with the Business Intelligence team to troubleshoot and tune the
extract, transform, load (ETL) processes in Informatica and MicroStrategy.
·        Maintenance, troubleshooting, performance tuning, capacity planning, and development support for OLTP and data warehouse environments using
DB2 8 and 9 for Linux and AIX on x86 and pSeries platforms.

2005-2007        I/T Architect        IBM Global Services
    International Business Machines, Inc.        San Diego, CA
Delivery consultant with a focus on DB2 and Tivoli solutions.
·        Repaired IBM’s relationships with three customers who were highly dissatisfied with previous IBM consulting experiences.  For example, repaired
a failed Tivoli implementation by a subcontractor, and restored customer relationship via good communication and knowledge transfer.  
·        Administration, maintenance, troubleshooting, performance tuning, and capacity planning for OLTP and data warehouse environments using DB2 8
and 9 for Linux, Unix, and Windows on Linux x86 and AIX pSeries.
·        Designed and implemented Tivoli solutions using Framework, Enterprise Console (TEC), Monitoring (ITM), Configuration Management (Software
Distribution, Inventory), NetView, and Netcool OMNIbus.

1998-2005        Senior Technical Consultant        Open Systems Division
    Sirius Computer Solutions, Inc.        San Diego, CA
Served as a pre-sales and post-sales consultant with a focus on DB2 and Tivoli solutions.
·        Implemented, migrated, and tuned DB2 LUW partitioned, high availability, and single-node configurations.
·        Designed and implemented Tivoli solutions using Framework, Enterprise Console (TEC), Monitoring, Configuration Management, Software
Distribution, Inventory, Remote Control, Decision Support, Cognos, Identity Manager, User Administration, Access Manager, and NetView.
·        Used my C, Perl, AIX, Solaris, HP-UX, Linux, Windows, HACMP, Oracle, Sybase, SQL Server, Cisco networking, CiscoWorks, firewall, VMware, Remedy,
SQL, Cognos and other skills for many projects.

1997        Systems Management Engineer        The Associates
    EDP Contract Services        Irving, TX
Lead engineer for the automated fault management project of the System Management and Engineering team using Tivoli Enterprise Console and Sybase
on Solaris.  Supporting engineer for the network management and software management projects using HP OpenView and BMC Patrol on Solaris.

1996-1997        Network Engineer        MCI Telecommunications        
    The Computer Merchant, Ltd.        Richardson, TX
TCP/IP network management consultant for the LAN / WAN support team for the Test and Integration group of the Intelligent Services Network (1-800-
COLLECT, StarCard, etc.) using HP OpenView and Bay Networks Optivity.

1995-1996        Technical Specialist        Houston Consulting
    BSG Alliance / IT, Inc.        Houston, TX
·        Technical architect for a sales support application with Forte, C, and Perl on Linux for US West.
·        Lead Windows NT and networking consultant for the Ruby Tuesday Technical Architecture team.
·        Technical lead for BSG's system management enablement project with HP OpenView Network Node Manager, Remedy AR System, HP OpenView
Operations Manager, ERwin, and Oracle databases on HP-UX.

1994-1995        UNIX System Administrator        Information Technology Services
    Mary Kay Cosmetics        Dallas, TX
System administrator for both the production and development I2 manufacturing planning systems on Solaris.

1992-1994        Senior Consultant        Network Operations Center
    Digital Equipment Corporation        Linthicum, MD
Designed, implemented, and maintained network management software in C for a satellite cellular phone system.
If your organizations has an IT Staffing or Consulting need for
a  Netezza - IBM PureData Resource, please email us at . If you wish to speak with someone from
Peningo Systems,
please click here to contact Peningo.
Back to the Peningo Netezza Consultants resume page
Back to the Peningo Netezza Consultants home page.