Position- Data Architect (Government TAX)-
Location- Albany, NY (Hybrid)
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
Responsibilities:
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 stgic busineratess requirements utilizing database structures, application methodologies, and coding techniques.
Serve as a technical subject matter expert on agency applications
Location- Albany, NY (Hybrid)
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
Responsibilities:
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 stgic busineratess requirements utilizing database structures, application methodologies, and coding techniques.
Serve as a technical subject matter expert on agency applications
—
