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
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
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.