Sr. Data Warehouse Database Administrator

DBA, Data warehouse, OBIEE, Oracle Enterprise Manager, PL/SQL, Oracle EBS, Oracle DBA, OBIA, Troubleshooting, Oracle RMAN, Business intelligence, BI, Cloud, SQL, SQL tuning, Oracle RAC, Oracle Cloud, Oracle GoldenGate, Linux, Oracle, Oracle ASM, RAC
Full Time
Depends on Experience
Travel not required

Job Description

The Senior Data Warehouse Database Administrator will implement best practices around design objectives to support Enterprise Data Warehouse development in collaboration with a team of Oracle DBAs. This role requires strong communication skills, both with team members and business contacts. A successful Senior Data Warehouse Database Administrator must be able to work with minimal supervision on multiple concurrent projects.

Core Requirements:

  • Oracle Business Intelligence Enterprise Edition & Business Intelligence (OBIEE) Application expertise (5 years) with recent hands-on experience with:
    • Oracle Database Administration of Data Warehouse environments.
    • Oracle Business Analytics Warehouse data models and Oracle EBS.
    • Oracle Managed Cloud Services / Oracle Cloud Infrastructure Hosted Solutions.
    • Oracle Business Intelligence Applications (OBIA)
  • Expert general Database performance tuning, optimization and trouble shooting skills.
  • Strong understanding of advanced Data Warehouse tuning techniques to optimize ELT jobs and complex SQL queries generated by the BI reporting front end.
  • Expert SQL performance tuning and trouble shooting skills.
  • Backup and recovery of databases using RMAN and/or Network Appliance Snapshots.
  • Security of database structures and corporate data held within databases.
  • Analytical SQL functions and PL SQL/SQL expertise
  • Required Qualifications:

    • Bachelor's degree in Computer Science, Engineering or related discipline required.
    • Minimum 5 years IT experience.
    • Minimum 5 years supporting of Oracle Business Intelligence Enterprise Editions (OBIEE) and Oracle Business Intelligence Application (OBIA) implementations integrated with Oracle E-Business Suite utilizing Oracle Databases.
    • Minimum 2 years of experience with Data Warehousing Kimball methodology.
    • Experience writing PL/SQL triggers and/or procedures.
    • Experience with Oracle GoldenGate is a plus.
    • Working knowledge of LINUX and shell scripting.
    • Experience configuring database network connectivity.
    • Experience in application design and implementation, distributed architecture and concepts, data manipulation and analysis using PL/SQL and SQL.
    • Proven analytical and technical problem-solving skills.
    • Proven track record of deploying large scale Data Warehouse/Business Intelligence systems.
    • Possess strong architectural leadership skills, and have a demonstrated ability to produce results in a large application environment
    • Excellent verbal and written communication skills for interaction with business users, solution owners, and team members.
    • Knowledge of Oracle EBS data model
    • Understanding or experience using Oracle Real Application Cluster s (RAC) and implementation best-practices is a plus.
    • Ability to analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, Disaster Recovery or high performance.
    • Experience setting up and managing Oracle ASM
    • Experience setting up and managing Oracle Enterprise Manager 12c/13c

    Posted By

    Tara Branham

    5 Concourse Parkway Atlanta, GA, 30328

    Dice Id : 10299702
    Position Id : 6422753
    Originally Posted : 5 months ago
    Have a Job? Post it

    Similar Positions

    Cloud DBA
    • Mindtree Limited
    • Atlanta, GA
    Database Administrator
    • Leidos
    • Atlanta, GA
    Senior Database Administrator
    • GreenSky, LLC.
    • Alpharetta, GA
    Lead Database Administrator
    • Perspecta
    • Atlanta, GA