Oracle Database Administrator

Role: Oracle Database Administrator Exadata GIS

Duration: 12 months contract

Location: City of Industry, CA 91746 (Hybrid)

Roles & Responsibilities:

• Ability to manage Exadata databases in an Oracle Cloud Infrastructure.
• Ability to manage autonomous databases
• Ability to manage the provision of new autonomous databases, including VNC and network security configurations.
• Ability to manage database performance of a data warehouse in an Exadata database environment.
• Ability to manage Oracle APEX environments in an Oracle Cloud Infrastructure environment
• Ability to work on data integrations using ETL and ELT tools like Oracle Autonomous data warehouse tooling.
• Ability to work with OCI data integration tools.
• Ability to lead a Data Mart development project, including design, development, data modeling, implementation, and documentation.
• Knowledge of Oracle databases and data warehouse database design.
• Ability to design data warehouse schema objects for various Data Marts.
• Ability to use data warehouse designing software tools like Erwin, Visio, or others to document and communicate project goals effectively.
• Ability to build data warehouse fact tables and dimension tables applying slowly changing dimension concepts.
• Ability to design ETL jobs to integrate data from different sources into Oracle Exadata databases running on Oracle Cloud Infrastructure.
• Ability to build data pipelines to process terabytes of data while maintaining performance and proactively scaling resources as needed.
• Ability for query and Talend job optimization to ensure adequate performance.
• Ability to analyze visualization/reports requirements to design the corresponding database objects.
• Good communication skills to provide knowledge transfer sessions and the corresponding documentation.
• Ability to draft project documentation, including diagrams and project management documentation requirements.
• Knowledge of the Talend administration console to help maintain and configure new projects and jobs.

Experience Required:

• Three (3) years of experience within the last five (5) years managing Exadata databases running on Oracle Cloud Infrastructure (OCI).
• Three (3) years of experience within the last five (5) years deploying and managing autonomous databases running on Oracle Cloud Infrastructure (OCI).
• Three (3) years of experience within the last five (5) years leading data mart projects in Oracle Exadata Databases, Oracle Cloud Infrastructure (OCI).
• Three (3) years of experience within the last five (5) years as a data warehouse architect in Oracle Exadata Databases Oracle Cloud Infrastructure (OCI).
• This should include structuring and organizing databases specifically for data warehouses, expertise in data modeling techniques, optimizing query performance, understanding ETL processes, and designing database architecture to efficiently store and retrieve large volumes of data.
• Three (3) years of experience within the last five (5) years of Oracle SQL & PL/SQL programming as part of ETL solution implementations.
• Five (5) years of experience within the last seven (7) years in architecting and implementing ELT processes.