Data Warehouse Architect

For more details, please connect with Gautmi Jain at 303-990-5305 or email at gautmij@vgroupinc.com

Summary

This project is to modernize aging Data Warehouse and Data Analytic systems utilizing new on-premises cloud- and container-based technologies

Required Skills:

• 84 months experience with a Government Taxation organization, which includes system design, development, maintenance and end user support of Tax & Revenue Accounting Systems and Tax Identification Systems.
• 84 months experience in design and administration for DB2 LUW on AIX including the use of PureXML and Database Partitioning Feature, traditional DBA tasks of design, tuning, storage management, memory/buffering, backup/recovery and object maintenance. The experience must be on both high-volume transactional systems and analytical systems and involve data purging and roll off, data movement and the shredding natively stored XML data to flattened structures.
• 84 months of database design and programming experience using Computer Associates IDMS database, programming for an IDMS database using its DMLO language as well as logical design, database navigation, analysis, writing application specifications, testing, documentation.
• 84 Months experience in administration and support of IBM’s InfoSphere Data Replication software to replicate data between databases on DB2 for z/OS and DB2 LUW on AIX (ver 9.5 or higher) including the setup, configuration and maintenance of IBM InfoSphere Data Replication Change Data Capture (CDC), in usage for 24/7 high volume transactional processing databases.
• 84 months experience with Application performance analysis and tuning
• 84 months experience with troubleshooting applications on an IBM Mainframe running DB2 z/OS and CICS/MQ