Systems Analyst 3 - Oracle Database architecture

Overview

Remote
On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 08 Month(s)
No Travel Required
Unable to Provide Sponsorship

Skills

cloud-native architecture
data architecture
data warehousing
Oracle Database architecture
Oracle RAC
Oracle Data Guard
RMAN
PaaS
DevOps environments
Enterprise Architecture

Job Details

Solicitation Reference Number: 529601541
Direct Client: Texas Health and Human Services Commission
Working Title: Systems Analyst 3 - Oracle Database architecture
Work Location: Austin, Tx - Position will be 3 days remote with 2 days (Mondays and Thursdays) required to be onsite
Interview Mode: Inperson and Microsoft Teams 
 
JD: 
 
Understands business objectives and problems, identifies alternative solutions, performs studies and cost/benefit analysis of alternatives. Analyzes user requirements, procedures, and problems to automate processing or to improve existing computer system: Confers with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be; summarized, and formats for reports. Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system.

The data administrator is required to possess comprehensive expertise in Oracle, AWS, and cloud-native architecture. This position is dedicated to modernizing legacy systems, implementing modular and scalable data solutions, and supporting HHSC transformation objectives. Responsibilities include optimizing database performance, maintaining secure deployments in the cloud, and facilitating collaboration among cross-functional teams to enable agile delivery and uphold architectural governance. Furthermore, the data administrator plays a critical role in ensuring secure, accurate, and efficient management of data across both legacy and updated systems. 

 

 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

8

Required

Experience in data architecture, data modeling, and data warehousing.

8

Required

Proficient in Oracle Database architecture, administration, and performance tuning

8

Required

Hands-on experience with Oracle RAC (Real Application Clusters) configuration and management

8

Required

Strong knowledge of data architecture principles and best practices.

8

Required

Proficient in writing complex SQL, PL/SQL, procedures, and performance-optimized queries

8

Required

Strong knowledge of Oracle Data Guard and high availability/disaster recovery strategies

8

Required

Familiarity with cloud-native database services and PaaS offerings

8

Required

Experience in database backup, restore, and recovery operations using RMAN

8

Required

Proficiency in cloud infrastructure management, including understanding of cloud-based data storage options, cloud security considerations, and best practices for deploying applications in the cloud.

8

Required

Develop and maintain enterprise data models, data warehouses, and data lakes to support analytics and reporting.

8

Required

Evaluate and integrate emerging technologies such as AI, machine learning, and big data analytics in healthcare.

8

Required

Ability to work in DevOps environments with CI/CD pipelines for database changes

8

Preferred

Experience transforming monolithic, on-premises data structures to microservice-aligned schemas

8

Preferred

Experience with structured Enterprise Architecture practices, hybrid cloud deployments, and on-premise-to-cloud migration deployments and roadmaps

8

Preferred

Strong communication skills, with the ability to explain complex technical concepts to a non-technical audience.

8

Preferred

Fundamental understanding of the Information Management principles, IT processes, SDLC, architecture and technologies adopted by an organization.

8

Preferred

Customer-focused ability to communicate across all levels of the organization.

8

Preferred

Proactive Leadership style; self-starter and strong attention to detail.

3

Preferred

Proven experience within an integrated eligibility case management system

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.