Skip site navigation (1) Skip section navigation (2)

Fwd: [pgsql-jobs] PostgrSQL DBA (Stanford, California)

From: decibel <decibel(at)decibel(dot)org>
To: PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Fwd: [pgsql-jobs] PostgrSQL DBA (Stanford, California)
Date: 2009-08-14 01:04:42
Message-ID: 6045943A-E2D9-4683-8E9E-73FB446F4356@decibel.org (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-jobs
Has anyone contacted Dr. Scherrer about doing a case study of this?

Begin forwarded message:

> From: Keh-Cheng Chu <kehcheng(at)sun(dot)Stanford(dot)EDU>
> Date: July 30, 2009 6:34:40 PM CDT
> To: pgsql-jobs(at)postgresql(dot)org
> Subject: [pgsql-jobs] PostgrSQL DBA (Stanford, California)
>
> PostgreSQL DBA
>
> The Hansen Experimental Physics Lab (HEPL) at Stanford University is
> developing the Joint Science Operations Center (JSOC) to support two
> key instruments on the upcoming NASA Solar Dynamics Observatory (SDO)
> mission.  Launch of SDO is expected within the next 18 months and may
> be as soon as 6 months.  The JSOC team has implemented a data  
> management
> system based on the PostgreSQL database system to support  
> management of
> an expected flow of several hundred million records per year.  The  
> JSOC
> system comprises a Database Record Management System (DRMS) containing
> image metadata and a Storage Unit Management System (SUMS) containing
> up to 1 PB/year of solar image data.  DRMS, in turn, comprises a C
> "wrapper" library that interfaces with a PostgreSQL server and  
> database.
> The library communicates with the server via libpq function calls.
> C and FORTRAN "modules" making use of the services provided by the
> DRMS library store and retrieve data from the PostgreSQL database and
> from SUMS via file pointers stored in the database.  Finally, scripts
> of various languages run these modules by submitting batch jobs to a
> queuing system that operates on a data cluster.
>
> For the final development stage prior to the launch of SDO the JSOC  
> team
> seeks a consultant/contractor who can who can perform a variety of  
> PostgreSQL
> design and DBA tasks; the level of effort is expected to be  
> variable as
> needed with the primary effort near the beginning and a supporting  
> role
> for up to a year.  The successful candidate will be fluent in  
> PostgreSQL
> backup, recovery, software installation and update/upgrade,  
> performance,
> and security.  She or he will have thorough knowledge of the tools  
> available
> to perform such PSQL administrative tasks.  A very good understanding
> of database design principles and how they can be used to enhance an
> existing database configuration is highly desirable.  The candidate  
> must
> have experience configuring hardware/software, and PostgreSQL server
> and clients so that the database performs optimally in our  
> environment.
>
> The JSOC team makes use of various technologies to duplicate database
> information.  It uses Slony-I, combined with administrative scripts,
> to replicate database information to offsite locations.  And it uses
> Unix snapshots and log shipping of write-ahead-logs to make regular
> database checkpoints and maintain standby machines.  The successful
> candidate must be knowledgeable with these and related technologies,
> and must be capable of designing and implementing such backup,  
> recovery,
> and transfer procedures.  The candidate should also be well-versed
> in associated tasks, such as managing fail over between standbys and
> database vacuuming, in the face of continual user queries.
>
> The JSOC Database Developer will assist in the identification of
> performance bottlenecks.  This includes analysis of table design/ 
> relations
> and database configuration.  But it also includes tracking down errant
> queries to specific processes.  As most SQL queries of the PostgreSQL
> databases will be generated by the DRMS library (C code), knowledge  
> of C
> and ability to rapidly master the JSOC interface between C and  
> PostgreSQL
> is also essential.
>
> As the team works exclusively in Unix environments (mostly Linux), the
> successful candidate will be a competent Unix user, and fluent with C,
> shell scripting, Perl scripting, etc.
>
> The JSOC Database Developer will document operating procedures and  
> plans.
> The JSOC Database Developer will also train other staff members in the
> maintenance and troubleshooting of the functioning system.   
> Accordingly,
> effective communication skills are a must, including communication of
> topics of a technical nature.
>
>
> Qualifications:
> * MS Degree or equivalent experience in Computer Science or related  
> field.
> * 3+ years experience working with PostgreSQL including Slony-I  
> experience
> * 3+ years experience administering databases
> * Proficiency in SQL programming, and some experience with PL/pgSQL.
> * Experience with PostgreSQL's libpq is highly desirable.
> * 3+ years experience with C programming in a UNIX/Linux environment.
> * Proficiency with shell scripting languages and Perl.
> * Ability to come up to speed on a fairly mature database  
> configuration in
>   a timely manner.
> * Strong technical and troubleshooting skills.
> * Ability to work independently.
>
>
> Please email your resume to pscherrer(at)solar(dot)stanford(dot)edu
>
> Philip H. Scherrer
> Professor of Physics, Stanford University
>
> -- 
> Sent via pgsql-jobs mailing list (pgsql-jobs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jobs
>

-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828



In response to

pgsql-jobs by date

Next:From: Colleen BlakelockDate: 2009-08-21 00:12:36
Subject: Postgres DBA needed in San Francisco Bay Area
Previous:From: Neel PhadnisDate: 2009-08-13 05:17:41
Subject: Senior Database Engineer/Architect (Postgres, Linux)

pgsql-advocacy by date

Next:From: Josh BerkusDate: 2009-08-18 22:45:48
Subject: First Community Survey Up
Previous:From: Dimitri FontaineDate: 2009-08-12 09:43:06
Subject: Re: Please help with list of features for Alpha1 Release

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group