Description

Immediate Hiring.... Database Architect 2 in Texas

[Austin, TX, 78751] |   2024-01-30 11:26:11

Apply Now

Share Job 

Job Code : 2024-MY3TECH0199

Database Architect 2

Austin, TX 78751 (Remote within TX)

6 months Contract with possibility to extension

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

Roles and Responsibilities:

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

Level Description:

  • 4-7 years of experience in the field or in a related area.
  • Familiar with standard concepts, practices, and procedures within a particular field.
  • Relies on limited experience and judgment to plan and accomplish goals.
  • A certain degree of creativity and latitude is required.
  • Works under limited supervision with considerable latitude for the use of initiative and independent judgment.

Candidate Skills and Qualifications:

YearsRequired/PreferredExperience
6RequiredExperience with Oracle databases version 11x, 12x or later
6RequiredExperience in writing SQL for relational databases
6RequiredExperience designing, developing, and supporting Oracle databases
6RequiredExperience troubleshooting and performance tuning Oracle databases
6RequiredExperience creating new databases, writing stored procedures, writing views, managing databse security, developing reports and ad-hoc queries
5RequiredExperience documenting database design, processes, and interfaces
5RequiredExperience supporting application development on J2EE and WebSphere platform
5RequiredExperience working with project teams utilizing Agile project management principles/methodology
1PreferredExperience with Client or other State Agency

Key Skills
Education

Any Graduate

Back To Jobs