DirectClient: Texas Health and Human Services Commission(HHSC)/DSHS
Solicitation#529310136C
Title: Oracle Database Architect
Location: 4601 W. Guadalupe St., Winters Bldg. C, Austin, TX
Duration: Until 8/31/2023 with possible extension
Last date for submission: August 10, 2022 (2.00 PM-CST)
DESCRIPTION OF SERVICES:
The Information Technology (IT) Applications, Medicaid/CHIP Systems (IT-MCS) team has initiated the MCS – Contract Administration & Provider Monitoring (CAPM) Tool Replacement project. This project will develop a database driven web portal application, replacing a series of Microsoft Excel workbooks to enhance contract monitoring and reporting Provider performance. Knowledge and experience in Oracle database design, development, performance optimization, reporting, testing, defect root cause analysis, troubleshooting, Agile development methodology, and systems architecture documentation. Support a web portal application development team utilizing Oracle versions 11x and 12x. Available for on-call support as needed. Other duties as assigned and required by the unit operations.
CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Required/Preferred Experience
6 Required Experience with Oracle 11x, 12x and later versions
6 Required Experience in writing SQL for relational databases
6 Required Experience designing, developing, and supporting Oracle databases
6 Required Experience troubleshooting and performance tuning Oracle
6 Required Experience creating new databases, writing stored procedures, writing views, managing database security, developing reports, and ad-hoc queries
4 Required Experience documenting database design, processes, and interfaces
4 Required Experience supporting application development on J2EE and WebSphere platform
4 Required Experience working with project teams utilizing Agile project management principles/methodology
4 Required Experience working with customers to document and implement data and reporting requirements
2 Preferred Experience with Texas Health and Human Services or other State Agency