Oracle DBA/Architect (15+)

InnoSoul•Austin, TX

1d•Hybrid

About The Position

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.

Requirements

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.
15+ years of experience
AI/ML experience
Legacy modernization experience
Big data experience
RAC experience
DW experience
Data Guard/HA/DR experience
AWS experience
Cloud/PaaS experience
PL/SQL experience
DevOps experience
CI/CD experience
RMAN experience

Nice To Haves

Experience transforming monolithic, on-premises data structures to microservice-aligned schemas
Experience with structured Enterprise Architecture practices, hybrid cloud deployments, and on-premise-to-cloud migration deployments and roadmaps
Strong communication skills, with the ability to explain complex technical concepts to a non-technical audience.
Fundamental understanding of the Information Management principles, IT processes, SDLC, architecture and technologies adopted by an organization.
Customer-focused ability to communicate across all levels of the organization.
Proactive Leadership style; self-starter and strong attention to detail.
Proven experience within an integrated eligibility case management system.

Responsibilities

Develop and maintain enterprise data models, data warehouses, and data lakes to support analytics and reporting.
Evaluate and integrate emerging technologies such as AI, machine learning, and big data analytics in healthcare.
Ability to work in DevOps environments with CI/ML pipelines for database changes
Understand business objectives and problems, identify alternative solutions, perform studies and cost/benefit analysis of alternatives.
Analyze 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 programs.
Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within the existing system.
Optimizing database performance.
Maintaining secure deployments in the cloud.
Facilitating collaboration among cross-functional teams to enable agile delivery and uphold architectural governance.
Ensuring secure, accurate, and efficient management of data across both legacy and updated systems.