SUMMARY:

• 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.

KEY SKILL:

• Data Architecture / Data Warehousing
• DB2 LUW (OS: Windows, AIX, SUN, Linux)
• Systems Lifecycle (Conceptual / Logical / Physical)
• Large Database (Average: 30+ terabytes / Range: 1 to 100+ terabytes)
• Data Replication using Confidential Q - Replication and MQ Series
• HADR implementation using Tivoli System Automation

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT/Fort Worth, TX

Senior Database Architect

Responsibilities:

• 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 Confidential experience.
• Creating and presenting decks for education to C-Level Management, Operations and Development staff explaining DB2 hardware and software environments and functionality.

Confidential, Fort Worth, TX

Lead Database Architect

Responsibilities:

• 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.

Confidential, Omaha, NE

Database Architect

Responsibilities:

• 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.

Confidential, Dallas, TX

Database and Systems Administrator

Responsibilities:

• 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.

Confidential, Dallas, TX

Database Administrator and Programmer

Responsibilities:

• 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.