HCM and Oracle Database Administrator,$50/Hr on C2C, Rancho Cucamonga, CA, Hybrid Project.

FASTRA LLC; Rancho Cucamonga (CA); On-site; USD 111,000 - 166,000; Part time

Job summary

FASTRA LLC, on behalf of a government client, seeks an experienced contract Database Analyst to support OCI Oracle Autonomous Database development and HRIS integration.

The role covers Oracle DB management on Windows, data integrity, GoldenGate, migrations, automation with Terraform/OCI tools, and collaboration with HR and Oracle to implement the new HCM system.

Qualifications

• 5+ years of experience with HCM systems, PeopleSoft, SQL and SQR.
• Strong Oracle database expertise (19c+), including ADW/ATP.
• Experience with OCI Cloud Database Services and Windows environments.
• Familiarity with Oracle GoldenGate and data migration frameworks.
• Ability to collaborate with HR and Oracle teams on HCM implementation.

Responsibilities

• Create Autonomous Database (ADB) in OCI and ensure data integrity.
• Help manage GoldenGate and data migration workflows.
• Collaborate with developers to design primary storage structures and schema objects.
• Maintain and support Oracle databases and coordinate with Oracle support for issue resolution.
• Automate deployment and operations using Terraform and OCI CLI.

Skills

OCI Cloud Database Services

Cloud Architecture

Windows OS

GoldenGate

Terraform

OCI CLI

SQL

Data Migration

JavaScript libraries

Education

Bachelor's degree in Information Technology/Computer Science or related field

Tools

Terraform

OCI CLI

Oracle GoldenGate

Data Pump

ZDM

Job description

Our Government client is seeking an experienced contract 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 County 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.