Ken Shaffer Email & Phone Number

Edgewater, Md, Us

Armonk, New York, Ny, Us

Armonk, New York, Ny, Us

The IBM Champion program recognizes innovative thought leaders in the technical community -- and rewards these contributors by amplifying their voice and increasing their sphere of influence. An IBM Champion is an IT professional, business leader, developer, or educator who influences and mentors others to help them make best use of IBM software, solutions, and services.

Provide Db2 solutions for various clients.

Supporting Large Data Warehouse in DPF, using QREP, DSM, WLM, HPU, TSAMP.

Arlington, Virginia, Us

 Sole DBA on large multi-database, mission-critical project during development and implementation phases. Installed and Provided Support for DB2 v8.2/v9.1/v9.7/v10.5 DB2 databases on AIX 5.3/6.1 Architected and implemented HA and DR solution (PowerHA and HADR) Supported production rollout and troubleshooting of OLTP system with 24x7x365 uptime requirements, and average data rates of hundreds of rows / second (every second!).  Developed unique strategies to purge data due to challenging requirements Stood up and supported multi-TB data warehouse (BLU) with challenging ETL requirements Provided SQL and DB2 support and SQL expertise to the development team Developed Scripting solutions to various problems, using Perl/DBI, ksh, JDBC.  Implemented solution to automate DDL deployment. Presented at IDUG NA 2015 and EMEA in 2014.

Austin, Tx, Us

Dallas, Tx, Us

• Provided DB2 DBA and AIX support for Siebel / SAP• Installed, configured and tuned entire DB2 environment to run a large Siebel implementation in 3 months• Setup DB2 installations for multiple SAP systems.• Designed backup / reorg strategies, and scripted solutions to manage DB2• Installed and tested HACMP Cluster for DB2 Siebel server

Us

• Provided DB2 DBA and AIX support for PeopleSoft Global Payroll• Tuned DB2 environment to support multi-terabyte database including tuning queries and database layout / parameters for the largest payroll in the world (US Military – Active and Reserve)• Provided support for Production, Development and Test databases• Created scripts to automate PeopleSoft / Database backup

• Managed a staff of three System/Network Administrators• Designed and implemented IT strategy to support dynamic Software / Hardware shop of up to 50 developers o Hardware / Software selection and acquisition o Network Security o Disaster Recovery o Budget and Inventory• Setup, configured, and maintained Solaris, HPUX, Linux and Windows servers providing web, file, ftp, DNS, mail, Samba, RRAS, firewall, VPN, NTP, NFS, mailing list, CVS services• Installed Redhat ES 3.0 on Dell Server using LVM on storage array • Provided systems support for Fissile Tracking System Project o Configured, installed and setup Sun Solaris 8 servers o Veritas Volume Manager, Cluster Server and Netbackup o Extended Veritas Cluster Server using PERL• Installed WAN / internet access and integrated network with Corporate networks• Installed NT 4.0 domain and migrated to Windows 2000 server / Active Directory • Installed and maintained Nortel Meridian PBX telephone system

Basking Ridge, Nj, Us

• Supported a network of several Production / Development Sun servers and 100 Sun workstations • Supported Oracle DBAs in development and production environments• Supported Software Development staff and development environment• Provided help desk support for internal and external production clients• Designed and implemented C/Oracle system to provide billing information from Pseudo-real time ATT 5E Switch interface to mainframe billing system• COBOL / DB2 Programmer on billing system for GSA/DOD phone systems (WITS, TEMPO contracts)

Cary, Nc, Us

• Rewrote and improved MRP system• Worked on Payroll, HR, shop floor, process control systems• Obtained CPIM (Certified Production Inventory Management)• COBOL, DB2 IBM UNISYS 1100

Master'S Degree, Computer Science

Bachelor'S Degree, Computer Science