UDB/DB2 DBA (#8662054) in Boston, MA

1) Develop materialized views of the underlying UDB database.2) Modify underlying physical model when necessitated by poor performance characteristics. 3) Create/Enhance ETL scripts as needed to implement modifications to the ODS and data warehouse using Korn Shell, SQL and C in a 64 bit partitioned UDB (on AIX) environment. 4) Provide technical support to User Acceptance and Integration testing environments by researching suspected anomalies and periodically refreshing the environments.Project 2: Contracted resource will to assist in implementing modifications to a large relational data mart and it's associated ETL processes and integrated data feeds.

Requirements:

1) Develop materialized views of the underlying UDB database.2) Modify underlying physical model when necessitated by poor performance characteristics. 3) Create/Enhance ETL scripts as needed to implement modifications to the ODS and data warehouse using Korn Shell, SQL and C in a 64 bit partitioned UDB (on AIX) environment. 4) Provide technical support to User Acceptance and Integration testing environments by researching suspected anomalies and periodically refreshing the environments.Project 2: Contracted resource will to assist in implementing modifications to a large relational data mart and it's associated ETL processes and integrated data feeds. Specifically the resource will:1) modify physical data models/ETL processes to accommodate changes to the Rating Data Mart or the associated feeds to the application. 2) Enhance ETL scripts to support the data mart using Korn Shell and SQL and C in a 64 bit partitioned UDB (on AIX) environment.


To Apply to this job go to http://www.GadBall.com or click here