PostgreSQL DBA

["Patry, Philip" <Phillip(dot)Patry(at)sullivancogliano(dot)com>]

PostgreSQL DBA

We have a need for a postgreSQL DBA in Washington, DC. The initial contact is 1 month, this would probably be extended however.

One very experienced with PostgreSQL.  Two of the major issues we have right now is tuning the auto-vacuum and resetting the clock to east coast time (yes, we have done everything you would expect, something is wrong).  After those two immediate needs we then have a plan to help us support the current database:
 
Step1 - Separate out tables:
 - Dump and restore tables to new DB on same server
 - Drop tables on vidb05
 - Create views on vidb05 to point to the secondary DBs
 
Step2 - Replication:
 - Replication with pgCluster or sloney or some other application
 - Setup mirrored environment for testing
 
Step3 - More Enhancements:
 - Physical partitioning of line_items table
 - Line_items on its own hard drive
 - Materialized Views
 
Secondary skills in Oracle db or MS SQL db would be helpful.

Contact Philip Patry from Sullivan and Cogliano for more information. 888-785-2641 ext 239 or email phil.patry(at)sulcog(dot)com