SUMMARY:

• Confidential is a DB2 Confidential DBA with 12+ years of experience in LUW, 9+ years of experience in z/OS, 3 years as an AS/400 (I series) DBA, and 2 years of SQL Server development experience, and lesser amounts of Teradata and Oracle, and with deep roots in both Data Warehousing (OLAP) and Confidential .
• Confidential is a well - rounded DBA with 4+ years of experience in the installation and operation of DB2 databases, not only in large-scale insurance environments (up to 11 TBs) operating on both AIX and LINUX servers, but other industries such as banking, railroading/logistics, retail distribution, and software.
• Confidential is looking to continue his career and is immediately open for the opportunity.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Responsibilities:

• Solved BMC Remedy tickets on such production and test problems as needing to add space to DMS containers so REORGs (much less further changes to the tables) could occur, solving date issues where they had columns named TIMESTAMP that were CHAR(26) and had non-date data inserted in them and also needed increases in LOGPRIMARY, LOGSECOND, and LOGFILSIZ to do deletes based on date logic once I’d eliminated non-date data (prior to planning to change it over to a TIMESTAMP rather than CHAR(26) column).
• Did an install of a fixpack from QA3 to Dev3 for 10.5.

Confidential, Cary, NC

Responsibilities:

• Supported production and test DB2 LUW Confidential 11.1 and 10.5 databases including large DPF databases.
• Solved problems such as determining that a problem we’d had was not really log-related (as some of the error messages seemed to imply) but medium-related (TPF in this case but they also used NetBackup, SVC, zerto, SRDF, Networker, AVAMAR etc.), adding swapspace in AIX, etc.
• Took courses on SkillSoft on Machine Learning, Python, Ruby on Rails, Splunk

Confidential, Vernon Hills, IL

Responsibilities:

• Working in a R7V1 AS400 Confidential environment with Navigator and Data Studio solving DB2 database-related RPG IV program problems, tuning queries via Visual EXPLAIN, doing Index Advise to create new indexes to help queries run better in large databases (often approaching a billion rows in some tables).
• Using Implementer as an AS400 tool to move changes in tables, indexes, constraints, and Stored Procedures in test to QA to Production.
• Using Confidential a.k.a. COOL 2E as the data modeling tool.
• Dealing with multiple environments in test, QA, and HA for the schema design of our moves to production using Agile Methodology for Bid Request and other business areas.

Confidential, Rensselaer, NY

Responsibilities:

• Working in a V10.1 large database (10 TB database in production alone with tables often in the hundreds of millions of rows) Confidential environment, running DML and DDL for corrections to NY State of Health Affordable Care database using both Data Studio and native LINUX server command line commands.
• Doing security updates and investigations
• Reviewed changes to Erwin data modeling tool
• Testing out, debugging, and moving to production Stored Procedures and Materialized Query Tables.
• Dealing with numerous schema types for our overall schema design on each server and between servers for eventual moves to production.
• Doing analysis of performance for test versus production using db2top, EXPLAIN, db2advis, Optim, etc.
• Reformed the Research Requests process for security violations.
• Solving production problems on call (e.g., Production transaction log full, failing back servers via HADR aka HA).
• Space planning for backups and for scp-ing of backups to standby boxes, test boxes for restores.
• Maintained and expanded Korn Shell scripts on both autosys and native crontab in LINUX.
• Aided in software selection for test data masking/de-identification by interviewing vendors via demos, etc.
• Submitted standards for foreign keys in relation to our primary keys.

Confidential, Amarillo, TX

SQL Server DBA

Responsibilities:

• Saved $25,000 a year for Anderson Merchandising by compressing V9.1 and V9.5 server databases using db2dart and REORG along with COMPRESS YES to eliminate 1 TB of wasted space.
• Reduced query time by at least 30% and up to as much as 90% by range partitioning for fact tables in Cognos Data Warehouse.
• Cataloged and established connectivity to various AS400 servers for Business Objects reporting both via standard DB2 connections and ODBC connections.
• Used Navigator Explain to add suggested indexes on AS400 tables (physical files) for speeding difficult queries.
• Created and managed WMS tables and returns tables Data Warehouse and associated Korn Shell Scripts and TSM backup for music vendors EMI, UMG, and SME on a DB2 V9.7 AIX platform for Business Objects reporting. Established federation between DB2 Confidential V9.7 on AIX and AS400 servers. Large database had tables approaching a billion rows.
• Aided AIX administrator in dealing with IBM on various fixes.
• Added file systems for Automatic Storage to databases.
• Upgraded numerous DB2 Confidential servers from V9.1 or V9.5 to V9.7 and installed Data Studio.
• Did extensive backup and restores of databases including redirects from one server to another.
• Implemented incremental TSM database backups for previously mentioned database system for WMS and returns.
• Did reorgs and runstats for large database (tables in 600 million row range).
• Did traces on AS400 in coordination with IBM to fix problems with AS400 extracts.
• Implemented databases for data warehouse returns system that uses Business Objects.
• Using SQL Server Management Studio, created data model using Visio data modeling tool and SQL Server 2008 R database for EDI system.

Confidential, Vegas, NV

DB2 Confidential LUW DBA

Responsibilities:

• Installed Fixpacks for DB2 V9.7 for both AIX and LINUX.
• Fixed LOAD process to use DATA BUFFER and SORT BUFFER to avoid hanging loads.
• Fixed refreshes (including Korn shell scripts) of test servers from production data.
• Developed "timing" chart for production server script versus refresh server script.
• Worked with data modeler to create a true data warehouse and to begin having an E-RD for production (though with no foreign key enforcement - they only had 17 foreign keys for over 500 tables and wished to keep it that way).
• Added space to tablespace containers to fix Operational Data Store HADR or HA failover issues.
• Created documentation for our team on setting up connectivity on TOAD as well as adding subscription and modifying subscriptions for Change Data Capture replication tool for our Operational Data Store.
• Developed Korn shell scripts to show any GRANTs which violated our GRANT to ROLE AISUSER framework.

Confidential, Irving, TX

DB2 Confidential LUW DBA/Data Modeler

Responsibilities:

• Worked as DB2 DBA on V9.7 for Confidential Partners for their Early Resolution project dealing with troubled mortgages.
• Created system topology charts for database servers using Visio.
• Created E-RD with Erwin, doing all the data modeling to take a system which only had two foreign keys for almost 150 tables (referential integrity was done thus far programmatically) and gave them a diagram with almost 180 proposed foreign keys for those tables.
• Quantified the considerable number of orphan rows for child tables.
• Also handled various questions concerning DB2 of a technical nature.

Confidential, Greenville, SC

DB2 Confidential LUW and zOS DBA

Responsibilities:

• Worked as DB2 DBA for Confidential, the world's third largest ERP software vendor.
• Worked primarily on the Workbrain product (human resources) doing fixes and enhancements via SVN and Test Tracker for existing and new releases for DB2 LUW, DB2 zOS, Oracle, and SQL Server.
• Installed DB2 V9.5 LUW for AIX and LINUX servers.
• Document uninstalling previous DB2 V9 versions and installing DB2 V9.5 for laptops for our programmers.
• Did tuning on queries (in one example, unpinning a server's CPU from 100% to 5% by adding two new indexes).
• Loaded zip files of DDL and data for zOS testing for various test and QA schemas
• Updated Java Property or JNDI files for new versions for zOS testing.
• Created data model ERDs and physical ERDs of Workbrain using Erwin for data modeling.
• Updated manuals for new versions of our software.
• Used RECOVER in zOS and RESTORE REDIRECT in LUW for databases that needed it.
• Investigated advantages of DB2 9 zOS over 8 as well as DB2 V9.7 LUW over V9.5.

Confidential, Bloomington, IL

DB2 Confidential DBA

Responsibilities:

• Worked at an insurance company in Bloomington, IL on a variety of projects simultaneously (10 to 15 at any one time, usually Confidential ); created large (11 TB) DPF Data Warehouse OLAP systems such as Enterprise Claims Solution as well as much smaller applications (though often crucial, such as Customer Response Center and Interactive Voice Response) all under AIX 5.3 with DB2 V9.7, V9.5 or DB2 V8.2.
• Implemented interconnectivity between UNIX DB2 and zOS DB2 (both ways).
• Aided in Java property file parameters.
• Created databases and estimated needed space as well as SAN space for UNIX servers.
• Proposed a system of SAN requests (using calculus and inventory modeling) which saved the client $5130 a year per server (millions of dollars) due to lower labor costs dominating interest costs
• Maintained Korn Shell Scripts
• Performed mass moves via Quest and performance tuning via Quest Spotlight, db2top
• Used Visual Explain, db2advis, and reorgchk for vastly improving query performance (in just one example, saving $943,644 in CPU costs).
• Performed restore and recovery work (online and offline) from backups and logs.
• Worked on Rational Build Forge, ClearQuest, RequisitePro and TestManager setting up servers and databases
• Worked on IBM Tivoli Identity Manager (ITIM) implementation including use of snapshots and event monitors to resolve contention issues.
• Led Joint Application Design work and logical data modeling and physical transformation via ER/Studio, as well as some production support.
• Set up db2ts text search indexes.
• Used HP Service Desk for documenting change.
• Used Lotus Notes for documenting projects.

Confidential, Richardson, TX

Database Administrator

Responsibilities:

• Used DB2 Confidential V8 non-partitioned on Windows 2003 from data FTPed from Teradata sources.
• Did data modeling using ER/win, created database objects, load, reorg and runstats utilities, and did performance tuning on long-running queries.
• Also did SQL Server 2000 work on Dynamic SQL and DTS loads for a reporting application.

Confidential, FL

Database Administrator

Responsibilities:

• Working at a major telecom company in Temple Terrace on production support for dozens of DB2 Confidential platforms, both V7 and V8, partitioned and non-partitioned, failover and standalone, Confidential and Data Warehouse, on AIX, Solaris, HP UX and Linux.
• Created and modified Korn Shell Scripts, maintained entity relationship diagrams for our data models, estimated space for establishing new databases, supported problems dealing with TSM and netbackup, set up jobs via cron or aided autosys and ESP-x staff in doing so via those tools.

Confidential, Dallas, TX

Database Administrator

Responsibilities:

• Built comprehensive Entity-Relationship Diagram model using ER/win and previous System Architect and Visio diagrams, and tested other possible products such as Rational Rose.
• Worked on proof-of-concept for converting shop from OS/390 DB2 V6 and VSAM platform under CICS to an AS/400 V5.1 platform in order to save about $12 million per year.
• Established test environment using BMC and Operations Navigator to port DDL and data before tailoring it to the AS/400, and used Strobe and Confidential on OS/390 to compare speeds with AS/400 via Database Performance Monitor.
• Established CICS connectivity to AS/400 DB2 tables using DRDA. Performed production support, monitored DASD for production Storage Groups.
• Analyzed AS/400 and OS/390 CPU statistics using Cognos Impromptu and Powerplay.
• Aided in implementing DB2 V7 and Metadata repository.
• Some SQL Server 2000 exposure.
• Completed all Oracle 8i-Certified Classes (Oracle programming, Architecture, Backup and Recovery Performance Tuning, Networking).
• Completed Six Sigma class and The Leadership Discussion Series.
• Completed 2 NETg courses in HTML, 3 in SQL Server Database Administration, 3 in Data Warehousing, 2 in XML, 2 in JavaScript, 1 in Korn Shell.
• Received $19,128 bonus for:
• Improved BMC REORGPLUS efficiency, saving $15,000 a year.
• Saved $130,000 by implementing QMF for OS/390 V7 six months early.

Confidential, Irving, TX

Database Administrator

Responsibilities:

• Worked at Confidential installing Confidential V7 EEE on a Sun E3500 with Solaris 2.6 as the operating system, later benchmarking Confidential vs.
• Oracle 8i for their People Pages for speed on queries using db2batch vs. SQLPLUS, speed for loads, etc.

Confidential, Irving, TX

Database Administrator

Responsibilities:

• Worked at IBM to implement the new version of their PartnerWorld Certifications Data Warehouse for their business partners.
• Used XML for data model generation, implemented database loads using Java code as well as exports and imports into Confidential V6 tables on an AIX box as well as managing and querying Confidential objects using a Windows NT Client.
• Aided users with creating views involving rollups and cubes using Brio Designer.
• Had root authority on AIX box and did some elementary Unix administration tasks including creation of ids, group ids, and administration of cron jobs.

Confidential, Southlake, TX

Database Administrator

Responsibilities:

• Moved a Data Warehouse for Confidential EE system (a Unix version of DB2) from AIX box to a Solaris E540 box for the client Canadian Airlines, doing object creation, loads, queries, solving production problems, using Cognos, etc.
• Altered mainframe FTP cards, created Platinum unloads on mainframe DB2 Version 5 system to load data to the E450 after FTP, etc.
• Did performance tuning with Confidential for mainframe online and batch jobs.

Confidential, Dallas, TX

Database Administrator

Responsibilities:

• Through a nationally recognized computer resource provider, worked first at Litton Enterprise Solutions for client Hilton Hotels as the on-call 24X7 Production Support DB2 DBA with SYSADM authority helping to implement changes in DB2 tables in test and production as well as solving problems in production. Worked with version 3 of DB2 using standard IBM utilities.
• Worked with ERwin for data modeling. Worked with SYBASE under IBMs version of UNIX (AIX) on RS/6000 models J40, R20, and S70 to convert portions of Hilton Hotels DB2-based system to an AIX/SYBASE client server system.
• Did elementary System Administration for AIX using smit, ed, vi, etc. to create logon ids for users in various test regions, did tar commands for tape backup, allocated disk space, defined space for SYBASE, and created and dropped SYBASE databases and calculated space estimates in Excel spreadsheets.
• Used DBArtisan to aid in this process.
• Later worked as DB2 DBA with SYSADM authority, using Version 5, using BMC utilities such as Change Manager and Catalog Manager, as well as BMC loads, unloads, recovers, reorgs, imagecopies, etc.
• Tested newest release of BMC utilities to make sure they were Y2K compliant, created numerous test environments using Change Manager migration, compare, and import features and used these features to move changes to production for Canada issuer number Credit Card project.
• Did DASD estimation for databases as well as production utility datasets.