OCI Oracle Cloud DB Analyst — Hybrid & Migrations

CAI Computer Aid, Inc.; United States; Hybrid; USD 83,000 - 88,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401k retirement account access

Paid sick leave / PTO

Job summary

CAI Computer Aid, Inc. is seeking an Oracle Database Analyst to support OCI-based database services and a new HCM system. Hybrid in San Bernardino, CA with contract terms. Strong focus on migration, automation, and RMAN recovery is required; direct employment with CAI only, no visa sponsorship.

The role emphasizes database design, performance tuning, and collaboration with IT, HR, and Oracle teams to deploy the new HCM platform using OCI, GoldenGate, and Data Pump.

Qualifications

• Experience provisioning and managing Oracle Cloud Database Services, including Autonomous Database, Exadata Database Service, and Base Database Services
• Strong understanding of OCI architecture (VCNs, IAM, Security Lists, Compartments, NSGs)
• Experience migrating databases to Oracle Cloud using ZDM, Data Pump, and/or GoldenGate
• Hands-on IaC using OCI CLI, SDKs, Terraform, or OCI Resource Manager
• Strong knowledge of Oracle Database 19c or later
• Experience administering Oracle databases in Windows environments
• Knowledge of RMAN backup/recovery methodologies
• Ability to collaborate with developers, stakeholders, and Oracle support teams

Responsibilities

• Participate in systems analysis, systems design, database design, and creating an Autonomous Database environment in OCI
• Collaborate with IT, HR, and Oracle teams to deploy the new HCM platform
• Provision, configure, and manage Oracle Cloud Database Services including Autonomous Database, Exadata, and Base Database Services
• Ensure database performance, security, integrity, and availability in OCI environments
• Support migrations from legacy/on‑prem environments using Data Pump, ZDM, and GoldenGate
• Develop and maintain automation using OCI CLI, SDKs, Terraform, or OCI Resource Manager
• Work with developers to design database schema objects and storage structures
• Perform database maintenance, troubleshooting, updates, backup, recovery, and tuning
• Manage RMAN backup/recovery, preferably with Commvault
• Resolve issues with developers and Oracle support teams

Skills

Troubleshooting

Collaboration

Communication

Problem solving

Education

Information Management or Computer Science related field

Tools

Oracle Cloud Infrastructure (OCI)

Oracle Database

Autonomous Database

Exadata Database Service

Base Database Services

Oracle Data Pump

ZDM

GoldenGate

OCI CLI

SDKs

Terraform

OCI Resource Manager

RMAN

Commvault

PeopleSoft

SQL

SQR

JavaScript

Job description

CAI Computer Aid, Inc. is seeking an Oracle Database Analyst to support OCI-based database services and a new HCM system. Hybrid in San Bernardino, CA with contract terms. Strong focus on migration, automation, and RMAN recovery is required; direct employment with CAI only, no visa sponsorship.

The role emphasizes database design, performance tuning, and collaboration with IT, HR, and Oracle teams to deploy the new HCM platform using OCI, GoldenGate, and Data Pump.