DARRELL DILLARD

**** *** ******

Fort Worth, Texas 76117

817-***-****

ac5vpq@r.postjobfree.com

Key Skill

Experience

Last Used

Data Architecture / Data Warehousing

20+ years

Current

DB2 LUW (OS: Windows, AIX, SUN, Linux)

20+ years

Current

Systems Lifecycle (Conceptual / Logical / Physical)

20+ years

Current

Large Database (Average: 30+ terabytes / Range: 1 to 100+ terabytes)

20+ years

Current

Data Replication using IBM Q-Replication and MQ Series

5+ years

Current

HADR implementation using Tivoli System Automation

5+ years

Current

PROFILE:

IT Architect with heavy emphasis on designing complete, reliable, resilient, high performance enterprise database systems. Heavily involved in server, storage, RDBMS and middleware selection and integration. Worked with a variety of customers in a multitude of situations, from installation to health check to critical system failures. Heavy emphasis on troubleshooting and design of systems to meet mission critical criteria. Provided customers with solutions that are flexible for future requirements.

Optum, Hartford, CT/Fort Worth, TX 06/06 – Present

Senior Database Architect

Involved in all aspects of Database Administration (backup/recovery, performance tuning, upgrades, etc.) for large Data Warehouse and related databases.

Physical and logical redesign of Data Warehouse for new hardware platform including underlying DB2 structures and physical hardware configuration.

Implemented a DB2 HADR/TSA Q-Replication system from ground up, establishing best practices and communication protocols between disparate technical groups.

Evaluation of software for monitoring and performance tuning.

Classroom and hands on training of co-workers for DB2 internals based on previous IBM experience.

Creating and presenting decks for education to C-Level Management, Operations and Development staff explaining DB2 hardware and software environments and functionality.

IBM, Fort Worth, TX 01/99 – 06/06

Lead Database Architect

Involved in the entire Systems Development Lifecycle (conceptual, logical and physical)

Interface directly and indirectly with customers to conduct data analysis and conceptualize the direction of the logical and physical development.

Work closely with the customers to conceptualize the functionality of the data architecture, infrastructure design and future direction.

Conducted additional, in-depth, analysis to determine if the requests of the customers are realistic.

Suggested directions and solutions that might provide more efficient resolutions to the customers needs.

Utilize the outlined requirements to formulate a logical architectural design.

Design, create and architect the database and infrastructure at an Enterprise-level.

Installed, administered, performance tuned and monitored client/server connectivity.

Logically and physically designed, developed and architected DB2 application support.

Designed, created, architected and developed Dimensional Data Modeling / Data Warehousing, Data Marts and Operational environments.

Utilized a variety of Operating Systems (Windows 95/98/2000, Windows NT, Sun Solaris and AIX)

Involved in Data Movement, Data Sharing, Data Placement, Storage Choices, Platform and Database designs and performance tuning.

Utilized DB2 UDB for Windows 95/98/2000, Windows NT and Enterprise Server Edition with Data Partitioning Feature for AIX.

Designed Backup and Recovery, High Availability and Disaster Recovery scenarios and solutions.

Architected solutions that allowed for ongoing capacity planning and flexible future growth.

Suggested viable training paths for customer employees, as well as personally mentoring said individuals.

Problem determination and resolution of complete database system.

Worked with SearchSpace IEF AML (Anti-Money Laundering) software implementing and tuned DB2 EEE on AIX and Solaris for that environment.

Conceptualizations were initiated due to a need for a stronger anti-fraud and anti-money laundering system.

Aligned with the requirements of the Patriot Act to ensure that all laws and regulations were clearly followed.

Inacom, Omaha, NE 07/97 – 01/99

Database Architect

Database Architect using DB2 on AIX and SQL Server Windows.

Architected and implemented new solutions for hardware and software.

Performance tuning of AIX and DB2.

Backup and recovery design, testing and implementation.

Involved in the entire Systems Development Lifecycle (conceptual, logical and physical).

Provided guidance to programmers for SQL usage and established enterprise level standards.

Interfaced with internal customers to aid in understanding database capabilities and best practices.

Administered Data Replicator for moving data from legacy DB2/AS400 databases to DB2 AIX Enterprise Data Warehouse.

Pillowtex, Dallas, TX 08/95 – 07/97

Database and Systems Administrator

Database and Systems Administrator for Oracle database and Data General UNIX.

Provided guidance to programmers for SQL usage.

Designed and implemented Web pages for company.

Responsible for designing backup, recovery and disaster recovery scenarios.

Performance tuning for Oracle database with Oracle Financials software

Performance of Data General UNIX system, hardware and software.

J.C. Penney, Dallas, TX 10/93 – 08/95

Database Administrator and Programmer

Database Administrator and COBOL programmer for the Retail Merchandising group.

Administered DB2 OS/390 databases for development, test and production environments.

Physical implementation of database structures.

Performance tuning of DB2 and utilities.

Evaluated, tested and implemented utilities for database functions.

Responsible for coding modules accessing DB2 databases.

Conversion of IMS databases to DB2.

Responsible for keeping three Remote Data Center databases synchronized with System of Record database.

Contact this candidate