Job ID: TX-52919079 (916091210)5P
Oracle Architect with SQL, tuning, DBA, Java/WebSphere support, Agile and healthcare experience
Location: Austin TX (HHSC)
Duration: 7 Months
Minimum Requirements:
6RequiredExperience with Oracle 11x, 12x and later versions
6RequiredExperience in writing SQL for relational databases
6RequiredExperience designing, developing, and supporting Oracle databases
6RequiredExperience troubleshooting and performance tuning Oracle
6RequiredExperience creating new databases, writing stored procedures, writing views, managing database security, developing reports, and ad-hoc queries
4RequiredExperience documenting database design, processes, and interfaces
4RequiredExperience supporting application development on J2EE and WebSphere platform
4RequiredExperience working with project teams utilizing Agile project management principles/methodology
4RequiredExperience working with customers to document and implement data and reporting requirements
2PreferredExperience with Health and Human Services or other State Agency
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.