Database Administrator (LA)

LOCATION: Rubicon Project HQ (West LA)

Do you have a passion for solving problems? Do you strive to make things work better, faster and with greater impact? If so become a member of a dynamic team committed to making The Rubicon Project the industry leader in online publisher advertising. You will work closely with both business and technology teams to support new and existing analytical and reporting products throughout the execution cycle.

The Rubicon Project is comprised of digital publisher ad products, technology, operations, and sales groups focused on monetizing publisher media. We are seeking professionals to join our Business Intelligence and Data Services team to manage the definition, development and rollout of shared technologies across all of our teams and products. Projects include leveraging optimization technologies to provide relevant ads and consumer-facing analytic tools to enhance interaction and improve ad performance.
We are looking for a Database Administrator with both conceptual and hands-on experience working on both proprietary and Open Source DBMS as well as large scale (full cycle multi-billion row) data warehouse environment.

Job Summary:

As a member of our DBA team you will be a principle member of a product group responsible for continuing organizational expansion of our data platforms including architecting, developing, testing, query tuning, debugging and administrating source integrations, data movement, and downstream processes. Additionally you will participate in technical discussions, evaluating, conceptualizing, designing and executing development plans for transaction database components. Your input will directly influence decisions and outcomes related to the products strategic and operational direction. This individual contributor is responsible for tasks and projects that are often not routine or structured, requiring self-reliant and creative problem solver. Flexibility is an asset as from time to time; you may be tasked to work on special data driven projects that will contribute towards team, department, and company goals.

Responsibilities:

• Database administration – Managing and development of new data processes as required; enhancing existing systems to support new requirements.
• Transactional Database Conceptualization –Programming and implementing best logical and physical modeling practices on various data platforms to cleanly integrate into existing enterprise data models; executing data model components to achieve efficient storage utilization and best query performance.
• Support - User interaction and requirements gathering from internal customers and consulting them on best practices to effectively use the platforms as a data resource; providing management best recommendations and follow on solutions to support programming maintenance and growth to achieve strategic and operational goals.

Job Requirements:

• Proficiency with hands-on programming for MySQL environments; knowledge of UNIX scripting (shell, PERL), and SQL required; Experience with PostgreSQL and Oracle a major plus.
• Experience with SQL in association with data transformation, custom reporting & analysis, and data investigation desired.
• In-depth conceptual knowledge of software development especially within production applications and large Enterprise Data warehousing environments (i.e. principles of Star or Snowflake schemas, normalized vs. dimensional, bottom-up/top-down, etc.) in order to effectively execute programming responsibilities; Experience with massively-parallel database platform such as GreenPlum, Aster, Teradata, Netezza, Vertica a plus.
• Experience with MapReduce technologies such as Hadoop, Hive, and Pig is also a plus.
• Ability to follow standard development and engineering practices and understand basic to complex concepts related to computer architecture, data structures and programming practices a must.
• Experience developing and executing testing/debugging, data quality, and performance tuning applications preferred.
• Ability to communicate effectively to end users and work within a team environment required.

Interaction:

• This individual must work effectively with staff at all levels, including but not limited to the technical team on assigned projects. There will be communication with employees in other functions as required.
• Limited management direction is provided to employee on new projects or assignments; general guidance is provided on new assignments.
• The ideal candidate will balance being an individual proactive contributor and subject matter expert on assigned projects with the ability to work collaboratively within the team environment of other engineers to meet aggressive goals and high quality standards.

Education & Experience:

• A minimum of 2 years of Database Administrator (DBA) experience is required with 5 to 7 years of experience preferred.
• A Bachelor of Science Degree in Electrical Engineering or Computer Science, a Master Degree, or a PhD; or equivalent experience is required. Strong aptitude for learning new technologies.
• 1+ years experience gathering requirements for, designing and implementing multi-dimensional reporting systems and data warehouses; exposure to multiple databases and DW tools is an added advantage. Should be updated with the latest trends in DW technology, i.e. various releases of tools and enhancements
• 1+ years experience in an online advertising company or a data-intensive business (such as financial services) would be a huge plus.
• Strong analytical and quantitative skills must be very comfortable working with large amounts of complex data.
• Excellent written and verbal communication skills
• Strong technical background, ideally BSCS/EE or demonstrated track record working closely with technology teams. MBA is a big plus.

Print Share This