• Data Warehouse DBA

    Posted Date 3 months ago(2/20/2018 4:02 PM)
    # of Openings
    Work Site - City
    Consulting Technical Services - Analytics
    Work Site - State
    Security Clearance Level
    None Required
    Maximum Expected Travel
    Regular Full-Time
    Remote/Telecommute Available?
    No - Applicants Must be Local to Work Site
  • Job Overview & Responsibilities

    Mythics is looking for a Data Warehouse DBA who will work at our client site in Brooklyn, NY.  As the Data Warehouse DBA you will have a range of experience in architecting data warehouse implementation solutions.  The target for the warehouse will include Oracle 12c Database as well as Oracle Big Data Appliance (BDA). 


    Reponsible for the following:


    • Design, delivery, and implementation of the data models and physical data warehouse structures that are the basis for the data warehouse
    • Work with the business users, other team Architects and Developers to design the actual dimensional data model structure (data warehouse)
    • Implement and modify the physical database schema
    • Work in conjunction with the OBIEE Architect to create the RPD in OBIEE
    • Work with the ETL Development team to provide guidance on loading the data into the physical data structures of the data warehouse
    • Implement and test any security configuration and requirements to include user/group setup, permissions setup and validation


    • Minimum of a Bachelor's Degree and/or equivalent work experience required
    Must be a US Citizen to obtain necessary clearance

    • 4+ years of Oracle PL/SQL experience
    • 1+ years of OBIEE experience including building the RPD layers desired
    • 1+ year of ODI desired
    • 4+ years of Data Architecture
    • 5+ Oracle DBA experience in a data warehouse environment
    • 1+ years of Oracle MDM desired
    • 1+ years of Big Data Experience specifically Cloudera and the Oracle Big Data Appliance stack
    • Experience with OBIEE migration through the life cycle desired
    • Work with BI team to Implement and Design the OBIEE RPD physical, business and presentation layers
    • Strong Oracle DBA skills in a Data Warehouse environment
    • Excellent Data Warehouse tuning skills, including configuration, implementations and understanding of specific Oracle database techniques
    • Strong understanding of dimensional data models
    • Understanding of the underlying technology including setup, tuning and administration
    • Oracle BI Stack (OBIEE, BI Publisher, ODI, etc.)
    • Experience collecting, analyzing and documenting user requirements
    • Golden Gate experience is a plus
    • Test the entire solution
    • Project Leadership skills including understanding, designing, and implementing the technical solution as well as leading the entire technical team to ensure they follow the approach and meet deadlines.
    • Ability to work as a collaborative team, mentoring and training the client and other Mythics staff on the various tools and techniques to build a complete Analytics solution
    • Excellent communications skills to interact with client and other developers, including training and mentoring of team members

    Company Overview

    Why work at Mythics?

    Because at Mythics, YOU count!  
    At Mythics, we have an environment that fosters creative thinking, respects your contributions, and accepts nothing less than excellence in serving our customers.  We demonstrate these core principles daily through our corporate Values of Respect – Empathy – Excellence – Fun (REEF). Our REEF values are the foundation of everything we do.

    • Comprehensive Health, Dental, and Vision plans available for you and your family
    • Premier 401k retirement plan with corporate matching and a 529 college saving plan
    • Tax-advantaged Health Savings Accounts and Flexible Spending Account options
    • Generous PTO bank and paid holidays
    • Fitness/gym membership reimbursement and other wellness activities
    • Tuition reimbursement for continuing education
    • Engaging company events such as quarterly awards, annual kick off parties, and FUN Friday’s (early release once a month)
    • Free gourmet coffee, tea, fresh fruits and healthy snacking alternatives
    • Community Service activities and charitable giving programs
    • Our GREEN approach – tracking energy consumption for reduction and purchasing only environmentally friendly products for our offices

    Founded in 2000, Mythics is an award-winning Oracle systems integrator, consulting firm, managed services provider and elite Oracle platinum resale partner. Our business model is all about deep knowledge of Oracle technologies and business processes. We offer procurement and Oracle systems integration expertise across the full range of Oracle cloud, software, support, hardware, engineered systems, and appliances.  It’s a focus that gives us the critical business experience and the Oracle technology advantage you need to succeed.


    Mythics, Inc. is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity, age, marital status, medical condition, veteran status, or any other factor determined to be unlawful by federal, state, or local statutes. Mythics, Inc. will treat all employees equally with respect to compensation; opportunities for advancement, including upgrading, promotion and transfer, and all other terms and conditions of employment. This company is a VEVRAA Federal Contractor, and has designed and agreed to implement an Affirmative Action Program in accordance with Executive Order 11246 and VEVRAA Final Rule.  Mythics, Inc. is able to provide alternative methods of application for those who are unable to complete an online form.  Please contact accommodationrequests@mythics.com to arrange reasonable accommodations.  To read more about your rights, please visit the Department of Labor Disability Rights Fact Sheet here. For more information about Federal laws prohibiting job discrimination, please view the “EEO is the Law” Poster here.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us!

    Don't see any positions that match your skillset? Not ready to apply? You can still Connect with us for future consideration!