Job Description :
DirectClient: Texas Health and Human Services Commission(HHSC)
Solicitation#52919080
Title: Database Architect
Location: 8317 Cross Park Drive, Austin TX
Duration: Until 8/31/2021 with possible extension
Last date for submission: December 11, 2020 (2.00 PM-CST)
DESCRIPTION OF SERVICES:
The Health and Human Services Commission (HHSC) requires the services of one (1ea) Data Architect hereafter referred to as Worker, who meets the general qualification of Data Architect and the specifications outlined in this document for Texas Health and Human Services.
The Data Architect is an Information Technology (IT) position and will provide database development and systems analysis in the implementation of the Managed Care Organization (MCO) Non-Risk Payment System (MCNPS
Job Description – Plan, design, develop, enhance, maintain and support databases underlying IT-MCS applications portfolio. Support the Oracle versions 11x and 12x database development, reporting, transformation, migration, and performance tuning needs of application developers utilizing JAVA/J2EE, Spring Frameworks, Spring MVC, JSPs, jQuery, Bootstrap, and IBM WebSphere. Responsible for performing advanced logical database development, performance monitoring and tuning, and providing database related support to the application development teams. Supports the database / applications enhancements and defect corrections in maintenance mode. Supports applications in multiple environments with coding testing, peer reviews, documentation, defect root cause analysis, and troubleshooting as required. 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 Health and Human Services or other State Agency