Database Analyst

Staffactory LLC; San Bernardino (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

Staffactory LLC in San Bernardino, CA is seeking an experienced Database Analyst contractor to participate in systems analysis, systems design, and database design, including creation of an Autonomous Database (ADB) in Oracle Cloud Infrastructure (OCI).

The role requires Oracle database experience, Windows operating environments, strong problem solving, organizational and communication skills, and keeping abreast of emerging technologies.

Qualifications

• At least 5 years' experience with HCM, Oracle databases, SQL and Windows environments.
• Experience creating an Autonomous Database (ADB) in OCI.
• Strong problem solving, organizational and communication skills.
• Knowledge of RMAN backup and recovery (preferably with Commvault).

Responsibilities

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

Skills

OCI Cloud Database Services

Oracle Database 19c+

Windows OS

Automation & IaC

Cloud Networking

Oracle GoldenGate

RMAN backup & recovery

Data Migration

Education

Information Management / Computer Science

Tools

OCI CLI

Terraform

Data Pump

GoldenGate

Job description

Position: Database Analyst

Location: San Bernardino, CA 92415

Work Environment: On-site

Duration: 6 months 1 year

Note: This role includes participation in systems analysis, systems design, database design, and the creation of an Autonomous Database (ADB) environment in Oracle Cloud Infrastructure (OCI). Candidates must have experience working with Oracle databases, Windows operating environments, and demonstrate strong problem solving, organizational, and communication skills. Keeping abreast of emerging technologies is essential.

HCM Database Analyst (Contract)

Job Specs

The 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.

Key skills and experience required include:

• Provisioning and managing Oracle Cloud Database Services (Autonomous Database, Exadata, and Base DB Services).

• Strong understanding of OCI cloud architecture, including VCNs, IAM policies, Security Lists, and Network Security Groups.

• Experience migrating legacy or on premises databases using Data Pump, Oracle Zero Downtime Migration (ZDM), or GoldenGate.

• Hands on skills in automation using OCI CLI, SDKs, Terraform, or OCI Resource Manager.

• Proficiency with Oracle 19c or higher.

• Knowledge of RMAN backup and recovery, preferably with Commvault.

• Ability to collaborate with developers to build schema objects and resolve technical issue

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.