SUMMARY:

Shelton is an information technology professional with over 20 years of experience and is therefore highly skilled.  He is a confident and committed leader with extensive formal education in Computer Science and industry certification in DB2. Certified as an IBM DB2 Expert in several disciplines (see Education & Certifications below), he has extensive experience with DB2 – both as Programmer and Administrator having worked with it for 15+ years. He has excellent communication skills and is very adept at working in a team environment.

§  A DB2 Certified Advanced Technical Expert (DRDA and Cluster/ESE) and a DB2 Certified Solutions Expert (Business Intelligence and Database Administration).

§  IBM Certified Solution Developer Web Services Development with Rational Application Developer

§  IBM Certified Solution Developer XML and Related Technologies

§  Extensive experience as a DB2 Database Administrator (10+ years) responsible for installation (using data partitioning – DPF facility), creating, monitoring, performance tuning, problem determination, backup/recovery, and maintenance of DB2 databases.  Environments include Linux, UNIX, AIX.

§  Extensive experience with DB2 Data Modeling, having using IBM’s Rational Data Architect e and CA’s ERwin Data Modeling Tools as well as DB2 Performance Expert.

§  Has performed Client/Server development utilizing DB2 UDB, SQL, COBOL, C/C++, Visual Basic, VBScript, ASP, and Oracle.

§  Experience as a DB2 Systems Programmer including physical and logical design of DB2 databases.   

§  Extensive experience with PeopleSoft and SAP projects providing DBA expertise.

§  Enterprise Data Warehouse Strategy, with Tools and Platform strategy (IBM’s GRID computing, ETL/ Enterprise Application Integration (EAI), Data Cleansing, Data Quality).

§  Extensive application experience with IMS, CICS and on the iSeries AS/400 DB2/400 .

§  Systems Programmer for CICS, Z/OS and for OS/390.

§  As a Web Developer, has been able to utilize wide array of skills to create comprehensive Web sites using Java, Java Script, EJB, JSP, Servlets, Applets, J++, HTML/DHTML, XML, ASP, ADO, COM/DCOM, WebSphere App Server, MQSeries Workflow and WebSphere MQ Integrator.

§  Extensive experience in implementation, Upgrading, Production support and benchmarking environments as an IBM DB2 UDB Database Administrator and Data Warehouse DBA for a wide range of applications.

§  Upgrade/migration experience from Databases 9.x, 8.x, to 7.x among different OS and hardware (IBM Aix, HP UX, Windows Server 2003/2008 and Linux)

§  Proficient in assessing and applying various FixPaks to DB2 UDB Databases.

§  Designed and Implemented Backup and Recovery Strategies for multiple environments on various platforms.

§  Implemented strategies for Log Archival including Log Shipping to TSM (Tivoli Storage Manager) with IBM support.

§  Experience in Designing and Implementing Guidelines for Database Development, Maintenance and Security Policies using Tivoli Access Manager for e-business (TAMeb)

§  Installation and troubleshooting experience of IBM DB2 Database using SQL based replication.

§  Strong troubleshooting, problem solving, analytical & design skills.

EDUCATION & CERTS:

University of Illinois

BS, Telecommunications and Computer Science

MS, Management Engineering and Computer Science

Certifications:

§  IBM DB2 Certified Advanced Technical Expert (DRDA and Cluster/EEE)

§  IBM DB2 Certified Solutions Expert (Business Intelligence and Database Administration)

§  IBM Certified Solutions Expert in DB2 UDB Database Administration

§  IBM Certified Solution Designer Service Oriented Architecture

§  IBM Certified Application Developer Rational Application Developer v6.0

TECHNICAL SKILLS:           

Relational Database Management Systems (RDBMS): DB2/UDB ESE, DB2 Connect, DB2 DPF/DB2PE, DB2 DWE, DB2 Utilities, HA/DR, QMF, Quest Software, ORACLE Enterprise Server (Financials, Forms, Reports, PL/SQL), MySQL, CA's Erwin, CA Database Command Center, Microsoft SQL Server 2K/2012.  

Mainframe: CICS, IMS DB/DC, TSO/ISPF/Dialog Manager, JCL, CLIST, FOCUS, FORTRAN, BASIC, PL/1, SAS, BTS II, VS COBOL II, BMC Utilities, IDCAMS, RACF, Panvalet, LIBRARIAN, Easytrieve, InterTest, Xpediter, Intellect, DBRC, DFDSS, DFHSM, NetView, File-AID, Top Secret, TLMS, CA Dispatch, OS/390, Z/OS MQSeries

Client/Server: Visual Basic, VB Script, VBA, Visual Interdev, C, C++, MS Access, ODBC, Corba, Rational Rose, PowerBuilder, Crystal Reports, NetWare, REXX, FoxBASE, , MFC, LDAP, SQL Server, IIS, Windows, Solaris, Linux (Red Hat & SuSE), Unix/AIX, MQSeries, IBM Information Server (IA, DataStage) Data Federation with DB2/WebSphere Information Integrator, DB2 LUW

Practices: Data Center Builds and Moves, Automated Systems Administration, UNIX Infrastructure Architecture, High-Availability NFS, High-Availability Computing Clusters, Genetic Algorithms, Service Oriented Architecture (SOA) and Enterprise Service Bus (ESB), Data Warehouse Strategy

Internet/Web: Java, JavaScript, EJB, JSP, Servlets, Applets, JDK, JDBC, J2EE, JRUN Studio, J++, COM/DCOM, ADO, ASP, Struts HTML/DHTML, XML, WebSphere, Apache, MS FrontPage, J2EE: JSP, Servlet, Custom Tags, EJB, JDBC, JSTL, ETL/EAI, IBM BI,MQ,JMS

APIs: JMS (Java Message Service), JAI (Java Advanced Imaging), Java 3D, AWT, Swing, MIDP, J2ME  Struts, JSF (Java Server Faces) IBM DB2 Xquery,

XML, XSLT, XSD (XML Schema), DTD, XPath, XSL-FO, SVG

Web Services (WSDL, SOAP) (X)HTML, Dynamic HTML, CSS

AJAX (Asynchronous JavaScript And XML)

Operating Systems: Linux HP-UX, RedHat, AIX, SunOS, Solaris, UNIX, Windows 2003, Windows, Vista VM/CMS, OS/390, Z/OS

Languages: Perl, Python, Bourne/C/Korn Shell, HTML, XML, PHP, SQL, C, Java, Awk

Packages: HACMP, TSM, TCM, TWS, TIM, SQL*Plus, SQL*Loader, ERWIN, Sybase Power Designer, DB2 DPROP, Visual Source Safe (VSS), PVCS, EARS (Extended Action Resolver System), IBM DB2 Cube Views, Crystal Reports, Apache, httpd, Sendmail, Qmail, Mailman,  IBM Information Server

Protocols: Ssh, DNS, SMTP, IMAP, POP, HTTP, NFS, NTP, LDAP, SSL, SLIP, PPP, TCP/IP, UUCP, CGI, NNTP

Hardware: Intel, IBM pSeries, zSeries, IBM RS/6000, Sun Sparc, Sun Ultra, IBM ESA, TI 990/10, Ethernet, Switched Ethernet, Token Ring, SGI, Cray, F-15C/D, AC-130A

Other/Previous Languages, Applications, Operating Systems, Tools, Utilities, etc:

Bachman, TI's IEF/JMA's IEM, SQL/DS, XEDIT, AMSERV, CSP, CMS/XA/ESA, MVS/ESA, VM CMS, OS/MVS/SMP, PC/ASM, MS/PC DOS

Jan 2010 – Current

Xtivia Corporation, New York City, NY

DB2 UDB DBA Subcontractor / Consultant for Various Client Companies

Lead Data Warehouse DBA, Shawmut Corp,Providence,RI

§  Perform as Lead DBA in the development of a data warehouse and three data mart applications.

-   Responsible for the design and implementation of a Star Schema warehouse. Under AIX 6.1 on IBM P690 clustered servers, DB2 UDB 9.7. DWE., Cognos 8.2, WebSphere commerce for developers

-   Data marts developed for loan servicing, product cross sell and refinance campaigning.

-   Client access accomplished through Financial Fusion E-Business Intelligence server, utilizing numerous aggregate tables.

-   Java development largely accomplished with sophisticated SQL, Java programming for stored procedures / user defined functions.

§  Database design and development tasks for Analytical and Business Intelligence

§  Database software upgrades and testing 8.2 ESE to 9.7 DWE on POWER7 770P.

§  Development of a test system migrating from AIX 6.1 to RedHat (RHEL5) adjusting for issues with filesystems and software packages. 

§  Database performance and tuning.

§  Review and enhancement of database auditing and monitoring tools.

§  Demonstrate understanding of data warehouse concepts and applications.

§  Communication of recommendations in written documents and presentations.

§  Provide Websphere (WAS,Virtural Enterprise) support via DB2.

§  Support the AS/400 legacy data model read-only database with performance tuning.

§  Perform DB2 z/OS performance tuning. 

§  Executed security procedures, including the use of Guardium for hardware-based encrypt of data.

Sept 2008 – Dec 2009

Accenture, SAP Consulting Services, New York City, NY

AIG CFP-GIFT SAP Implementation Project
SAP DB2 Administrator/Programmer on Solaris and Z/OS

SAP DB2 Database Administrator / Systems Programmer

§  Prepared the IBM DB2 for z/OS platform to run SAP Net Weaver (ECC, BI, Portal and PI)

§  Programmed and executed a daily DBA System Checks for SAP

§  Programmed REXX exec to do DB2 Performance Monitoring & Tuning

§  Developed a number of DB2 Stored Procedures; WLM Application Environments

§  Developed a DB2 mainframe backup and recovery strategy to support SAP

§  Setup JCL to run DB2 mainframe utilities (REORG/RUNSTATS/COPY/DSN1COMP/MODIFY/QUIESCE)

§  Performed general technical trouble shooting

§  Setup a number of test to check the SAP Application performance monitoring

§  Reviewed Statement Cache statistics to identify poorly performing SQL; and was able to take appropriate action to remedy.

§  Work with DataStage developers to ensure efficient SQL code.  Ran traces as necessary to assist in problem determination.

§  Use DBACOCKPIT transaction to identify problem jobs (long running UR’s, deadlocks, timeouts)

§  Created new indexes in SAP as required for performance

§  Monitored object sizes and setup a method to perform table partitioning as object size or application would dictate.

§  Buffer pool tuning.  Used DB2B transaction to evaluate bufferpool assignments and re-assign as necessary. 

§  Evaluate bufferpool parameters to ensure efficient usage. VPSIZE, VPSEQT, Deferred thresholds

§  Evaluated objects for compression using DSN1COMP utility.

§  Created, scheduled and monitored DBA utility jobs via DB13 or available mainframe tools.

§  Identify maintenance needs for objects not handled by SAP GUI (Java schema;Portal)

§  Set up and configure DB2 connections to unix, zlinux. Selected fields for encryption through Guardium.

§  Set up of new/upgrade DB2 application (CATMAINT)

§  Diagnosed and resolved problems related on both DB2 z/OS 390 and DB2 LUW platform

§  I performed Job scheduling , database security Grants, database optimizer, buffer pool, use of indexes , CPU utilization, paging rates, disk , network I/O and SQL statement tuning

§  Database maintenance & utility tasks such as runstats and reorgs.

§  Developed copy processes & strategy (ie: homogenous system copy using Tivoli System Automation for Multiplatforms)

§  Developed cloning process for DB2 subsystems using CA Database Command Center

§  Interfaced with AIG-GS staff for support as needed.

§  Oracle DBA tasks I performed:

o    Programming utilizing Perl and  Unix korn shell scripting for monitoring oracle

o    Oracle backup and recovery using RMAN and BRTOOLS.

o    Oracle performance tuning.

o    Oracle installs and upgrades - SAP patching.

o    Oracle proactive monitoring.

o    Oracle database design to improved performance.

o    Oracle utilities like export / import for complicated database refreshes.

Mar 2008 – Aug 2008

Blue Cross Blue Shield Association, Dover, DE

DB2/ERP Upgrade Initiative Project
DB2 UDB Database Administrator on AIX/DataStage/DWE (Subcontractor)

Senior DB2 DBA

§  Installed DB2 UDB 9.1 FixPak 4a on AIX. Created new instances and databases. Worked with Unix team.

§  Tuned database and completed database manager configuration for optimum performance. Configured bufferpool and tablespace page size to improve time taken by ETL to build data marts.

§  Designed, Developed and Administered Health Business Intelligence Data Warehouse.

§  Designed Developed and Administered Data Marts for BI DataStage Applications and reporting.          

§  Database Performance Tuning and Stored Procedure Troubleshooting.

§  Designed and Implemented Maintenance Strategies to execute DB2 Utilities like Reorg, Runstats and Reorgchk and Load.

§  Significant experience in all phases of PeopleSoft DBA Support, PeopleSoft Release upgrades, etc.

§  Designed Guidelines for Data Security and implemented the same using Views and Materialized Query Tables.

§  Designed and Implemented Backup Strategies working for Development and Production environments.

§  Transitioned and Supported Implementation of the Data Warehouse and Data Marts into Production.

§  Maintained various Database environments in development for User Acceptance testing, Operational Acceptance testing and Product testing.

§  Created and Maintained Data Models and Data Dictionaries using ERWIN.

§  Change Tracking and Release Management from Development into Production.

§  Mentored and Trained Junior DBA’s to work on day to day activities.

§  Developed new tools for performance metrics data gathering. Analyzed effects of iterative changes on performance via these metrics.

§  Worked with DataStage developers to improve their SQL reports through analysis of access paths. Supported developers in the development of very large SQL statements involving in some cases ten or more table joins with left outer joins, nested SQL, and other high performance features. Worked with them on indexes, database configuration, and SQL rewrites. Used db2audit to develop reports on kinds of SQL run on the database.

§  Supported SQL  including large joins, global temporary session tables, mass updates, left and full outer joins, nested queries, insert triggers, sub queries, common table expressions, materialized query tables (summary tables), mass updates, case expressions, high volume IMPORT INSERT and LOAD.

§  Worked heavily with the data movement utilities IMPORT, LOAD, and EXPORT under high volume conditions.

§  Work to validate the new data model for Internal Data Mart.

§  Developed and implemented BACKUP and RECOVERY strategy for Data Marts. Also designed and implemented database monitoring to alert DBAs via email to potential errors such as instance crash, log directory out of space, and tablespace containers out of space.

§  Supported and administered ETL interface between data marts and main data warehouse.

§  Opened and resolved PMR's on multiple database problems including tablespace checksum errors, database crashes, and lost connection states. Supported 24/7 troubleshooting and problem resolution for the databases.

§  Responsible for mirroring development database to production to support development efforts. Supported backup and recovery of development environments. Responsible for moving development database objects to production.

§  The technical environment included:

o    IBM p690 with scalable DB2 shared-nothing architecture to provide linear scaling up to 67TB per DS4500. 2 Gbps Fibre Channel storage area network connects the DS4500 to the p5-690 14 LVD SCSI physical disk drives, an assortment of both 146 Gbytes and 74 Gbytes, all mirrored.

o    DB2 UDB 9.1, AIX 5.3, Windows 2003 Server, Also utilized DB2 Query patroller, DB2 performance expert 3.1x and Korn/awk/sed script programming with DB2 command line processor (CLP) automation with FTP scripts for file transfer; and cron for scheduling. IBM’s Information Server for QS, DS and IA.  

Apr 2007 – Mar 2008

Publix Supermarkets, Inc., Lakeland, FL

SAP ERP Upgrade Initiative Project
DB2 UDB Database Administrator on AIX/SAP/EEE (Subcontractor)

Senior SAP DB2 DBA

§  Completed regular day-to-day administrative tasks, supporting developers, production support, database design and modeling for SAP Internal and External Data Marts.

§  Installed DB2 UDB 9.1 with FixPak on AIX. Created new instances and databases. Worked with Unix team to upgrade AIX release level.

§  Tuned database and completed database manager configuration for optimum performance. Configured bufferpool and tablespace page size to improve time taken by ETL to build data marts. Experimented with indexes, and employed Index Advisor and Visual Explain, to both improve user report performance and speed ETL run times. Employed DB2DART, REORGCHK, REORG TABLE and RUNSTATS to further performance goals. Developed new tools for performance metrics data gathering. Analyzed effects of iterative changes on performance via these metrics.

§  Worked with SAP developers to improve their SQL reports through analysis of access paths. Supported developers in the development of very large SQL statements involving in some cases ten or more table joins with left outer joins, nested SQL, and other high performance features. Worked with them on indexes, database configuration, and SQL rewrites. Used db2audit to develop reports on kinds of SQL run on the database.

§  Supported SQL  including large joins, global temporary session tables, mass updates, left and full outer joins, nested queries, insert triggers, sub queries, common table expressions, materialized query tables (summary tables), mass updates, case expressions, high volume IMPORT INSERT and LOAD.

§  Worked heavily with the data movement utilities IMPORT, LOAD, and EXPORT under high volume conditions.

§  Developed groups of VIEWs organized by multiple table schema which allow different sets of users to selectively access different subsets of data by different naming conventions, but allow all users access to the same underlying physical data. Supported this on the security level by developing GRANT scripts to allow only appropriate users access to certain VIEWs.

§  Developed new data model for Internal Data Mart. Developed specifications for ETL interface to new Internal Data Mart.

§  Developed and implemented BACKUP and RECOVERY strategy for Data Marts. (HADR) Also designed and implemented database monitoring to alert DBAs via email to potential errors such as instance crash, log directory out of space, and tablespace containers out of space.

§  Supported and administered ETL interface between SAP data marts and both Z/OS DB2 database and main SAP Data Management and data warehouse.

§  Opened and resolved PMR's on multiple database problems including tablespace checksum errors, database crashes, and lost connection states. Supported 24/7 troubleshooting and problem resolution for the databases.

§  Responsible for mirroring development database to production to support development efforts. Supported backup and recovery of development environments. Responsible for moving development database objects to production.

§  The technical environment included:

o    Specialty data marts comprised of 32 databases on 16 instances sharing eight machines. Production and development databases share 64 80 Gbyte disks with the four production databases consuming a total of about 20 Tbytes of tablespace container space. Databases use SMS tablespaces defined with 32K, 16K, 8K and 4K pages.

o    IBM p690 FastT, 4-processor machines running with 8 Gbytes of physical memory. The 3281 has 14 LVD SCSI physical disk drives, an assortment of both 146 Gbytes and 74 Gbytes, all mirrored.

o    DB2 UDB 9.1, AIX 5.3, Windows 2003 Server, Linux(RHEL). Also utilized Korn/awk/sed script programming with DB2 command line processor (CLP) automation with FTP scripts for file transfer; cron and ca7 for scheduling. IBM Tivoli System Automation for Multiplatforms

Sep 2006 – Mar 2007

IBM Global Business Consulting Services, Phoenix, AZ

American Express Data Warehouse Restructuring Project
DB2 DBA Subcontractor

Lead AmEx Project DB2 DBA

§  Assigned as the lead DB2 DBA resource for the American Express Data Warehouse Restructuring Project.

§  American Express contracted with IBM Global Services to host its Web site, network servers, data storage, and help-desk support.  This is a utility-based service delivery project. The job of the Data Warehouse Project was to calculate payments based on actual usage of IT services rather than a charge-back fee. The project saves American Express "hundreds of millions of dollars" in IT savings over the life of the contract.

§  Installed and configured the DB2 database systems in multiple environments (z/OS and AIX). Also responsible for creating, maintaining, tuning, and backup/recovery of the databases (very large scale databases, e.g., 12 terabytes in size for the entire American Express enterprise). In the AIX environment, established the development, testing (sandbox), and production database systems for applications being built.

§  Designed and created the physical data warehouse databases employing data architect skills; responsible for performance and tuning of the databases and provided support for the data warehouse products such as Query Patrol, CubeView, and Alphablox.

§  Utilized data modeling techniques extensively with IBM’s Rational Rose Data Modeler and the Unified Modeling Language. Performed data engineering between the data model, object model and defined data language (DDL) file / database management system (DBMS). Also used CA’s ERwin Data Modeling Tool.

§  Skills utilized: GS Methodology and Work Products; Database Design; Data Warehouse Structure Design; Database Performance Management; Physical Database Design and Tuning; Database Maintenance.

§  Built Web front-ends for J2EE and SOA applications using AJAX, JavaScript, XSL, CSS, XHTML, and SVG.

§  Software utilized: DB2 V8.2.13 and DB2 V9.1; DB2 UDB Warehouse Manager; DB2 OLAP Server; DB2 AIX; DB2 for z/OS; DB2 Utilities; DB2 SQL; DB2 Performance Expert; AlphaBlox; CubeView; WebSphere Data Integration Suite (ProfileStage, QualityStage, DataStage, MetaStage)

Jul 2005 - Sep 2006

Blue Cross Blue Shield of Illinois, Chicago, IL

DB2 UDB DBA Subcontractor

Lead MedStat Project DB2 DBA

§  Assigned as the Lead DB2 Database Administrator to the MedStat Project.

§  Created, maintained and supported the DB2 database(s) using DB2 UDB ESE (the Data Partitioning feature) on both the UNIX (AIX environment) with TSM Storage Manager and z/OS environment. 

§  Position Scope: Duties as the Lead MedStat Project DB2 DBA included the following: Installed DB2 with the Data Partitioning; worked with Thomson Software (the vendor) to configure the database for performance based on 39 months of data; created and implemented backup/recovery scenarios and strategies (including disaster recovery); reviewed, recommended and enforced database standards and procedures; provided technical assistance to the project team.

§  Major Accountabilities: Installed DB2 software on four servers (IL, TX, NM and the development server), configuring it to use Data Partitioning across six nodes; created databases for the project on development and production servers; ensured on-going backup and recovery (including disaster recovery); worked with project team and vendor to ensure database performance and reliability; managed database distribution, security and access requirements.

§  Z/OS DB2 Features Utilized: (1) High availability - By way of online schema updates, added partitions and made about 20 changes with ALTER. Also, used the new backup and recovery utilities for disaster recovery. (2) Scalability for very large databases - Used separate partitioning and clustering allowing for two dimensional clustering. Also, used index options to provide efficient access and was able to reconfigure the maximum number of partitions, thus the ability to use more memory effectively, which was key for scalability. (3) Java and the web - Used Web Sphere SQLJ and JDBC support with Unicode support for integration with Java and web applications. (4) Queries and data warehouses - Provided optimization changes to enhance performance of DB2 V8. Faster response and reduced processing time resulted from improved optimization and better information for the optimizer.  Also, used the new database design options for indexes, clustering and materialized query tables; the warehouses needed to have the new rotate partition capability. (5) SQL enhancements - Used many SQL enhancements to provide better compatibility with DB2 the family for successful porting of applications.

§  Application Packages Used: SAP, PeopleSoft and Siebel.  The key vendor packages are SAP R/3 4.6, PeopleSoft PeopleTools 8.45, and Siebel 7.8, all on DB2 Version 8.

§  Technical Skills Utilized: DB2 DBA (DB2 UDB Version 8.2 & 9 Beta) on AIX (Version 5.3), DB2 ESE (Data Partitioning Feature), DB2 II (Information Integrator/Data Propagator), Korn Shell Programming.

Jun 2004 - Jul 2005

IBM Corporation, Menasha, WI

DB2 UDB DBA Subcontractor / Consultant for IBM's Client Company, Banta Corp.

Lead PeopleSoft DB2 DBA, Banta Corporation

§<span styl