Dutech’s Job

Database Architect

Austin,TX

DatePosted : 3/13/2024 7:16:06 AM

JobNumber : DTS101765835
JobType : Contract
Skills: Oracle databases version 11x, 12x or later, writing SQL for relational databases, designing, developing, and supporting Oracle databases, J2EE and WebSphere platform
Job Description

Job Description

Designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Must be able to design, develop and manipulate database management systems, data warehouses and multidimensional databases. Requires a depth and breadth of database knowledge that shall help with formal design of relational databases and provides insight into strategic data manipulation. Responsible for making sure an organization's strategic goals are optimized through the use of enterprise data standards. This frequently involves creating and maintaining a centralized registry of metadata. Has working knowledge of EIR Accessibility standards and assistive technologies. Ensures that all user interfaces for database administration and inputting, viewing, outputting data(via reports) are compliant with accessibility standards.

 

Additional job details and special considerations

The Information Technology (IT) Applications, Medicaid/CHIP Systems (IT-MCS) team has initiated the MCS – SAVERR to TOA Remediation – PPS & TMTS project. This project will remediate SAVERR code in the Premiums Payable System (PPS) and Texas Medical Transportation System (TMTS) by replacing SAVERR code with TOA code and business logic. Requires knowledge and experience in Oracle database design, development, performance optimization, reporting, testing, defect root cause analysis, troubleshooting, Agile development methodology, and systems architecture documentation utilizing Oracle version 11x and/or 12x. Available for on-call support as needed. Other duties as assigned and required by the unit operations.

 

 

  1. CANDIDATE SKILLS AND QUALIFICATIONS

 

Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

6

Required

Experience with Oracle databases version 11x, 12x or later

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 databases

6

Required

Experience creating new databases, writing stored procedures, writing views, managing databse security, developing reports and ad-hoc queries

5

Required

Experience documenting database design, processes, and interfaces

5

Required

Experience supporting application development on J2EE and WebSphere platform

5

Required

Experience working with project teams utilizing Agile project management principles/methodology

1

Preferred

Experience with Texas Health and Human Services or other State Agency

 

SHARE THIS JOB

;