Database Architecture

OCAL candidates Only for this position

DESCRIPTION OF SERVICES

Client requires the services of 1 Systems Analyst 3, hereafter referred to as Candidate(s), who meets the general qualifications of Systems Analyst 3, Applications/Software Development and the specifications outlined in this document for the Client .

All work products resulting from the project shall be considered "works made for hire" and are the property of the Client and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Client will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).

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

• 8 Years-Required-Experience in data architecture, data modeling, and data warehousing.
• 8 Years-Required-Proficient in Oracle Database architecture, administration, and performance tuning
• 8 Years-Required-Hands-on experience with Oracle RAC (Real Application Clusters) configuration and management
• 8 Years-Required-Strong knowledge of data architecture principles and best practices.
• 8 Years-Required-Proficient in writing complex SQL, PL/SQL, procedures, and performance-optimized queries
• 8 Years-Required-Strong knowledge of Oracle Data Guard and high availability/disaster recovery strategies
• 8 Years-Required-Familiarity with cloud-native database services and PaaS offerings
• 8 Years-Required-Experience in database backup, restore, and recovery operations using RMAN
• 8 Years-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 Years-Required-Develop and maintain enterprise data models, data warehouses, and data lakes to support analytics and reporting.
• 8 Years-Required-Evaluate and integrate emerging technologies such as AI, machine learning, and big data analytics in healthcare.
• 8 Years-Required-Ability to work 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-Preferred-Experience with structured Enterprise Architecture practices, hybrid cloud deployments, and on-premise-to-cloud migration deployments and roadmaps
• 8 Years-Preferred-Strong communication skills, with the ability to explain complex technical concepts to a non-technical audience.
• 8 Years-Preferred-Fundamental understanding of the Information Management principles, IT processes, SDLC, architecture and technologies adopted by an organization.
• 8 Years-Preferred-Customer-focused ability to communicate across all levels of the organization.
• 8 Years-Preferred-Proactive Leadership style; self-starter and strong attention to detail.
• 3 Years-Preferred-Proven experience within an integrated eligibility case management system.