14242 - Oracle Data Architect (onsite) – Austin, TX

Start Date: ASAP
Type: Temporary Project
Estimated Duration: 10 months with possible extensions
Work Setting: Hybrid, with 2 days (Mondays and Thursdays) required onsite. Residing in Texas and local to the Austin area.

Required:
• Availability to work 100% of the time at the Client’s site in Austin, TX (required);
• Experience in data architecture, data modeling, and data warehousing (8 years);
• Experience in Oracle Database architecture, administration, and performance tuning (8 years);
• Hands-on experience with Oracle RAC (Real Application Clusters) configuration and management (8 years);
• Experience with data architecture principles and best practices (8 years);
• Experience in writing complex SQL, PL/SQL, procedures, and performance-optimized queries (8 years);
• Experience with Oracle Data Guard and high availability/disaster recovery strategies (8 years);
• Experience with cloud-native database services and PaaS offerings (8 years);
• Experience in database backup, restore, and recovery operations using RMAN (8 years);
• Experience with cloud infrastructure management, including understanding of cloud-based data storage options, cloud security considerations, and best practices for deploying applications in the cloud (8 years);
• Experience developing and maintaining enterprise data models, data warehouses, and data lakes to support analytics and reporting (8 years);
• Experience evaluating and integrating emerging technologies such as AI, machine learning, and big data analytics in healthcare (8 years);
• Experience working in DevOps environments with CI/CD pipelines for database changes (8 years);

Preferred:
• Experience transforming monolithic, on-premises data structures to microservice-aligned schemas (8 years);
• Experience with structured Enterprise Architecture practices, hybrid cloud deployments, and on-premise-to-cloud migration deployments and roadmaps (8 years);
• Experience with the Information Management principles, IT processes, SDLC, architecture and technologies adopted by an organization (8 years);
• Proven experience within an integrated eligibility case management system (8 years)

Responsibilities:
• Serve as a data administrator modernizing legacy systems, implementing modular and scalable data solutions, and supporting HHSC transformation objectives.
• Optimize database performance, maintain secure deployments in the cloud, and facilitate collaboration among cross-functional teams to enable agile delivery and uphold architectural governance.
• Ensure secure, accurate, and efficient management of data across both legacy and updated systems.
• Understand business objectives and problems, identify alternative solutions, and perform studies and cost/benefit analysis.
• Analyze user requirements and procedures, confer with personnel to identify problems, and learn input and output requirements.
• Write detailed descriptions of user needs, program functions, and steps required to develop or modify a computer program.
• Review computer system capabilities, specifications, and scheduling limitations to determine if a requested program or change is possible.