Oracle Database Analyst

About The Company

CAI is a renowned global services firm with a rich history spanning over 40 years, dedicated to uniting talent and technology to deliver innovative solutions for clients across various sectors. With a workforce of over 9,000 associates worldwide and annual revenues exceeding $1.3 billion, CAI prides itself on its commitment to excellence, integrity, and social responsibility. As a privately held organization, CAI maintains the flexibility to prioritize doing what is right, focusing on creating lasting impacts through tailored solutions that address both public and private sector needs. The company is also recognized as a trailblazer in fostering neurodiversity within the enterprise, promoting an inclusive environment that values diverse perspectives and talents.

About The Role

We are seeking a highly skilled and motivated Oracle Database Analyst to join our team in a hybrid work environment based in San Bernardino, CA. This role is pivotal in supporting the deployment and management of Oracle Cloud Infrastructure (OCI) and database systems, particularly in the context of implementing a new Human Capital Management (HCM) system. The successful candidate will collaborate closely with IT, Human Resources, and Oracle implementation teams to ensure seamless migration, configuration, and operation of Oracle databases within cloud environments. This is a contract position offering an opportunity to work on challenging projects that require technical expertise, problem-solving skills, and a proactive approach to database management and cloud migration strategies.

Qualifications

• Proven experience in provisioning and managing Oracle Cloud Database Services such as Autonomous Database, Exadata, and Base Database Services.
• Strong understanding of OCI architecture, including Virtual Cloud Networks (VCNs), Identity and Access Management (IAM), Security Lists, Compartments, and Network Security Groups (NSGs).
• Hands-on experience with migrating databases to Oracle Cloud using tools like Oracle Zero Downtime Migration (ZDM), Oracle Data Pump, and Oracle GoldenGate.
• Proficiency in automation and Infrastructure as Code (IaC) using OCI CLI, SDKs, Terraform, or OCI Resource Manager.
• Deep knowledge of Oracle Database 19c or later versions, with experience in database administration within Windows environments.
• Experience with Oracle RMAN backup and recovery methodologies, preferably leveraging Commvault.
• Strong troubleshooting, analytical, organizational, and communication skills, with the ability to collaborate effectively with diverse teams and stakeholders.
• Ability to adapt to emerging cloud and database technologies, staying current with industry best practices.

Responsibilities

• Participating in systems analysis, design, and the creation of Autonomous Database (ADB) environments within OCI.
• Partnering with IT, HR, and Oracle implementation teams to support the deployment of the new HCM platform.
• Provisioning, configuring, and managing Oracle Cloud Database Services, ensuring optimal performance, security, and availability.
• Supporting database migrations from legacy or on-premises systems to OCI using tools such as Oracle Data Pump, ZDM, and GoldenGate.
• Developing automation solutions leveraging OCI CLI, SDKs, Terraform, or OCI Resource Manager to streamline database operations.
• Collaborating with application developers to design and optimize database schemas, objects, and storage structures.
• Performing routine database maintenance activities, including software updates, backups, recovery, and performance tuning.
• Managing Oracle RMAN backup and recovery processes, ideally utilizing Commvault for data protection.
• Resolving technical issues by working closely with developers, business stakeholders, and Oracle support teams to ensure minimal downtime and optimal system performance.

Benefits

CAI offers competitive compensation packages, with hourly rates ranging from $60 to $64, commensurate with experience and qualifications. CAI values its employees’ well-being and professional growth, fostering an inclusive environment that encourages continuous learning and development.

• Medical, dental, and vision insurance
• 401(k) retirement plan options
• Paid sick leave
• Other paid time off in accordance with applicable laws