Address
Form of work
SalarySenior level Database Administrator may also have experience as an architect, modeler or warehouse design for decision support.
This position is responsible for the majority of all Iowa Justice Data Warehouse (JDW) enhancement processes, monitor status of application development and environmental modifications. Migrate the JDW from Teradata to Google/Big Query, and prepare comprehensive and accurate test plans for migration pipelines to Google.
Required Skillset: Extensive experience with database administration, specialized knowledge of Teradata, ETL, and architecture. Knowledge and understanding of SQL and Teradata Utilities. Ability to integrate multiple system management processes and solve complex information technology system problems.
8-10 years of experience with database administration, or specialized knowledge of Teradata, ETL and architecture. Have knowledge and understanding of SQL and Teradata Utilities, have the ability to integrate multiple system management processes, and solve complex information technology system problems.
Teradata/Google Migration and Data Governance Activities
Project Description: Develop and provide Teradata documentation needed to initiate the migration to Google Enterprise Data Warehouse. Serve as primary contact for current Teradata Justice Data Warehouse (JDW) technical documentation, security, and flowcharts, including network and database details. Assist with migration tasks for the Enterprise Data Warehouse migration of databases, extraction, transformation, and load (ETL) processes and reporting. Find areas where the timeliness of current procedures can be reduced (to make the system more efficient).
Required Skillset: Extensive experience with database administration, specialized knowledge of Teradata, ETL, and architecture. Knowledge and understanding of SQL and Teradata Utilities. Ability to integrate multiple system management processes and solve complex information technology system problems.
8-10 years of experience with database administration, or specialized knowledge of Teradata, ETL and architecture. Have knowledge and understanding of SQL and Teradata Utilities, have the ability to integrate multiple system management processes, and solve complex information technology system problems.
Teradata/Google Migration and Data Governance Activities
Project Description: Develop and provide Teradata documentation needed to initiate the migration to Google Enterprise Data Warehouse. Serve as primary contact for current Teradata Justice Data Warehouse (JDW) technical documentation, security, and flowcharts, including network and database details. Assist with migration tasks for the Enterprise Data Warehouse migration of databases, extraction, transformation, and load (ETL) processes and reporting. Find areas where the timeliness of current procedures can be reduced (to make the system more efficient).
8-10 years of experience with database administration, or specialized knowledge of Teradata, ETL and architecture
Knowledge and understanding of SQL and Teradata Utilities.
