Data warehouse (DBA) pgsql/greenplum S.F.

Поиск
Список
Период
Сортировка
От David O'Dell
Тема Data warehouse (DBA) pgsql/greenplum S.F.
Дата
Msg-id D0FB1A072021FC4B832114BEE5C7A24F05D813DC24@troca1.evlta.ad.videoegg.com
обсуждение исходный текст
Список pgsql-jobs

Location: San Francisco

 

Data Warehouse Administrator

We aren't looking for an exact fit as most of the technologies deployed are new to the market.
As the data warehouse administrator you will be responsible for the protection, growth, performance and health of our business data. Making use of the business intelligence is one of our biggest initiatives for 2008. The data warehouse was recently deployed and is already receiving 1/2 billion entries per week. We are looking for someone with several years experience as a DBA and the desire to own the data warehouse as it grows. Although we have 4 pairs of mySQL databases in production, this position will primarily focus on the data warehouse.

Responsibilities 

  • Act as principal database architect and as a primary technical resource for data warehouse reporting applications.
  • work with Business Intelligence Analyst  to turn questions into answers
  • Monitor and take appropriate action to maintain integrity of the data warehouse databases including security and privacy issues.
  • work with Engineering to develop ETL layer
  • Evaluate existing database structures and recommend improvements.
  • protect the integrity of the data, backups etc..
  • migrate schema changes from staging to production warehouse
  • suggest tuning and hardware changes to improve performance
  • work with sysadmins to monitor health and performance

Requirements

  • 2 years experience working as a DBA with any mainstream database(oracle,DB2,Sybase,PostgreSQL,MySQL,MS SQL, etc.....)
  • past experience working in a fast paced environment where you owned the data
  • solid understanding of the ETL layer

Core Technologies

  • parallel PostgreSQL (Greenplum)
  • mySQL
  • pentaho business intelligence for reporting
  • ETL layer is LAMP based

Additional Skills

  • database failure and recovery
  • high-availability service
  • database scalability
  • performance optimization
  • SQL
  • perl
  • java
  • eclipse
  • nagios
  • written communication
  • attention to detail

 

В списке pgsql-jobs по дате отправления:

Предыдущее
От: "Sproule, Emily A"
Дата:
Сообщение: Data Modeler at Fred Hutchinson
Следующее
От: Mike Saunt
Дата:
Сообщение: Immediate PostgreSQL opportunity Surrey, UK