Oracle HCM Database Analyst

ZealHire Inc.; San Bernardino, Northern (CA, KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

ZealHire Inc. in San Bernardino, CA is seeking an experienced Oracle HCM Database Analyst for a contract role to support HCM implementation on OCI.

The ideal candidate will design and create an Autonomous Database (ADB) in OCI, manage data integrity, and collaborate with HR and Oracle teams.

Qualifications include 5+ years with Oracle databases, Windows, GoldenGate, RMAN, and experience with Zero Downtime Migration; onsite locals preferred.

Qualifications

• OCI cloud databases and Oracle Base Database Services provisioning.
• OCI cloud configurations: VCNs, security lists, IAM policies.
• Migration using ZDM, Data Pump, or GoldenGate for cloud transition.
• Automation with Terraform, OCI CLI, IaC approaches.
• Strong Windows operating system knowledge.
• Oracle DB versions 19c or higher management.
• Collaborate with developers to design storage structures and schema objects.
• Maintenance tasks and software updates with Oracle support.
• Backup and recovery using RMAN and Commvault.

Responsibilities

• Create Autonomous Database (ADB) in OCI.
• Ensure data integrity in Autonomous Database.
• Help create and manage GoldenGate.

Skills

OCI Cloud DB

Cloud Architecture

Migration Frameworks

Automation & Orchestration

Windows OS

Oracle DB mgmt

Developer Collaboration

Maintenance & Support

Backup & Recovery

Education

Information Management / Computer Science degree

Tools

Terraform

OCI CLI

GoldenGate

RMAN

Job description

ZealHire. San Bernardino, California, United States Contract Deadline: Oct 25, 2026

USC/GC/GC-EAD/H4-EADNeed LinkedIn, VISA DLseeking a Oracle HCM Database Analyst for a Contract job with a client in San Bernardino, CA. Ideally looking for applicants with a solid background in the Oracle HCM and Autonomous Database(ADB)Locals who can work onsite

Our Direct client is seeking an experienced contract Oracle HCM Database Analyst. The candidate will participate in systems analysis, systems design, database design, and creation of an Autonomous Database (ADB) in the Oracle Cloud Infrastructure (OCI). Contractor will be assigned to ITD’s Human Capital Management (EMACS) team to partner with Human Resources and Oracle supporting the implementation of a new Human Capital Management (HCM) system.

The position requires experience with Oracle databases and Windows operating environments. Candidates should possess excellent problem solving, organizational and communication skills, and keep abreast with emerging technologies.

Responsibilities

• Work with the Clients resources and Oracle implementation team to create Autonomous Database (ADB) in the Oracle Cloud.
• Ensure data integrity in Autonomous Database.
• Help create and manage Golden Gate.

Skills and Qualifications

• OCI Cloud Database Services: Comprehensive knowledge of provisioning and managing Oracle Base Database Services (VMs/Bare Metal), Oracle Exadata Database Service, and Oracle Autonomous Database (ATP and ADW).
• Cloud Architecture & Networking: Mastery over OCI-specific cloud configurations like Virtual Cloud Networks (VCNs), Security Lists, Network Security Groups (NSGs), Compartments, and Identity & Access Management (IAM) cloud policies.
• Migration Frameworks: Expertise in transitioning legacy or on-premises databases to the cloud using Oracle Zero Downtime Migration (ZDM), Oracle Data Pump, or real-time replication via Oracle GoldenGate.
• Automation & Orchestration: Proven capabilities in automation using Cloud SDKs, OCI CLI, and Infrastructure as Code (IaC) utilizing Terraform or OCI Resource Manager.
• Operating System: Strong knowledge of Windows environment.
• Oracle Database Management: Proficiency in maintaining Oracle database versions 19c or higher.
• Developer Collaboration: Work alongside application developers to construct primary storage structures and schema objects based on application design. Resolve technical conflicts as required.
• Maintenance and Support: Manage maintenance tasks, handle software updates and interface with developers or Oracle support to resolve technical issues.
• Backup and Recovery: Strong knowledge of Oracle RMAN backup and recovery using Commvault.

Experience and Education:

Information Management, Computer Science, or any closely related field with at least 5 years’ working experience using HCM, PeopleSoft, JavaScript libraries, SQL and SQR. An equivalent combination of experience, education and training will be considered.

Salary Range:

$000,000 – $000,000 Salary range is not shown on the candidate portal