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
resettingthe clock to east coast time (yes, we have done everything you would expect, something is wrong). After those
twoimmediate 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