DB2 Database Architect

Description

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

Duties

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

• Experience (15+ Years)
• 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.

Requirements

• This is an 100% Onsite.
• 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.
• R sum
• Copy of Candidate Identification (i.e., Driver's License//Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)