Oracle Database Administrator

4 days ago

Apply Now

Receive Emails with Similar Jobs

Chickasaw Nation Industries, Inc.

WebsiteLinkedInAll Job Openings

Civilian • Defense • Filtration • Network Services • Research, Development, Test, and Evaluation

1001 - 5000

Description

• Supports software delivery by designing optimal solutions based on client requirements. • Responsibilities include integrating Oracle with other databases (e.g., SQL Server), developing data models and SQL procedures, and automating data transfer using WEB APIs. • The ideal candidate must have hands-on experience designing databases, data modeling, and writing in SQL queries, with working knowledge of Oracle, Data Warehouse, and ETL. • Proactively monitor the database's health and taking preventive or corrective action as required.

Requirements

• Must have a Public Trust Clearance. • Oracle Experience and Data Integrations with Agency Applications (Oracle PL/SQL, WCF, CRM, SOAP, API’s) and other relational databases like SQL Server. • Ability to integrate from MS SQL to Oracle SQL. • Proficient in data modeling and SQL, including PL/SQL for stored procedures, packages, functions, triggers, and views. • Integrate web applications with other websites using WEB APIs to automate data transfer. • Experience with Working Capital Funds. • Microsoft CRM Integration experience preferred. • Background with using SOAP programming language. • Skilled in designing data models and creating/managing database schemas. • Expertise in data migration, ETL, data marts, and data warehouses. • Adept at troubleshooting database issues, primarily in Oracle environments, with a focus on performance analysis and security. • Focused on leveraging reusable code modules for data preparation, transformation, export, and synchronization.

Benefits

• Medical • Dental • Vision • 401(k) • STD/LTD/AD&D • Employee Assistance Program (EAP) • Paid Time Off (PTO) • Training and Development Opportunities