Allied Consultants, Inc. is an Austin-based firm which has for 25 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced DB2 Data Architect to be a key resource on a technical services team.
Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.
Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check
Allied Consultants is an equal opportunities employer.
Allied Consultants seeks a Data Architect to evaluate, plan, and recommend data solutions for one of their Texas State Agency clients located in Huntsville Texas. Our client has a diverse technology architecture which includes a large mainframe application system written in COBOL and using the DB2 relational database and VSAM file structure. They also have server-based Java/DB2 applications, which interface with the mainframe application. These software applications are complex and with the many enhancements it has undergone, are in need of data review and refreshment.
The major responsibilities of the Data Architect include analysis of the existing VSAM and DB2 databases/data; development of plans for the efficient migration and validation of the data; design of efficient file structures to support enhancements and migration of application systems; and development and validation of target databases for the data.
Responsibilities include the usage of and oversight of scripts, stored procedures, and tools for data exchange between DB2 databases and the existing Mainframe and Web based application systems.
Performs advanced and/or supervisory (senior-level) database administration work. Work involves providing direction and guidance in strategic operations and planning; providing for the efficient and effective storage, retrieval, customization, and archiving of data to ensure integrated database systems; planning, developing, and implementing database policies and procedures; and maintaining and verifying data integrity. May assign and/or supervise the work of others. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.
Essential Job Duties:
Minimum Years of Experience
Participating in large scale information technology projects which includes extensive work in the design and development of complex databases on mainframe and web-based platforms
Leading data architecture activities on application development projects.
Creating logical and physical data models, evaluating relational database models, and reviewing physical data models created from logical data models.
Leading the migrations to new data management system software levels and ensures that migrations are appropriately tested and validated.
DB2 Relational Database System