Job ID: TX-52990000DA1606 (910191219)
Informix Admin with Unix, shell scripting, data modeling, information architecture, Oracle/SQL Server and government experience
Location: Austin TX (HHSC)
Duration: 9 months
Minimum Requirements:
Years Skills/Experience
4Experience with database administration in Informix
4Experience with Informix Stored Procedures
4Experience with Unix, including shell scripting
4Experience in installation, upgrade, migration on Informix DB
4Experience with data modeling and design and/or information architecture
YesBachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience
StrongMulti-tasking skills involving the specific ability to work on multiple projects or project assignments.
StrongExcellent verbal, written communication, and presentation skills
Preferences:
Years Skills/Experience
3Preparing System documentation and training materials
3 Experience working with Oracle, SQL Server
Yes Experience working in a public-sector environment (State, Federal, county, city, or government funded private entities that work actively with government organizations)
HHSC is currently working on a project to migrate ReHabWorks from Texas Workforce Commission (TWC) and support it in-house. ReHabWorks is a custom business application used by HHSC to manage and maintain caseloads for the Rehabilitative and Independence Services programs within the Health, Developmental, and Independence Services (HDIS) organization. This system has multiple components and includes Informix Stored Procedures on a Unix file structure. The Informix Database Administrator will assist HHSC in migrating this application code, Informix procedures and the Informix database seamlessly into the HHSC controlled environment.
The Informix Database Administrator will perform the following services in support of the project:
•Define future state data management model with input from HHS business stakeholders.
•Support the development of integrated data models and artifacts identifying as-is, planned, and to-be mission data and supporting metadata.
•Employ data modeling tools and associated graphical methods to depict and analyze current and proposed conceptual, logical, and physical data schemas.
•Coordinate and approve corresponding database changes to support new and modified applications, and ensures new designs conform to data standards and guidelines, and are consistent, normalized, perform as required, and are secure from unauthorized access or update.
•Design and develop extract, transform and load (ETL) logic and code in support of data warehouse and analytics operations and maintains related data pipelines.
•Designs and develops data mapping and transformation scripts to support data warehouse development and data analytics efforts.
•Assist developers and application support team members.