HBITSSystems Architect-Expert

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

Day-to-Day Tasks:
Responsible for expert analysis support development reengineering and implementation of multiple business applications. Support is required for specific programming languages (COBOL SQL and Java) for specific database management systems (DB2 z/OS DB2 LUW IDMS SQL Server) and using specific technologies (MQ Series CICS Sort JCL VSAM Unix scripting DBI performance tools ERwin TSO/ISPF Data Studio z/OS AIX IBM Data Replication).
Provide performance analysis and tuning troubleshooting capacity planning benchmark design.
Implement backup and recovery strategies and phased implementation/conversion planning for new and converted applications.
Design methodologies for data synchronization from operational data stores to a data warehouse across multiple database platforms and varied DBMS.
Planning interfacing and usage between application databases data warehouse Cognos Identity Insight DataStage Finalist and HCL Commerce (formerly IBM Commerce).
Act as liaison between Data Management business customers and application development staff to ensure that recommended performance considerations are included in reviews designs development and implementation of applications.
Create cost effective and timely solutions to strategic business requirements utilizing database structures application methodologies and coding techniques.
Serve as a technical subject matter expert on agency applications.

Mandatory Qualification:
Systems Architect -
Defines the architecture of a computerized system (i.e. a system composed of software and hardware) in order to fulfill certain requirement including a breakdown of the system into components the component interactions and interfaces (including with the environment especially the user) and the technologies and resources to be used in the design.

Expert -
84 Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

Requested Qualifications:
- 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 IBMs 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.