[JOB] Fwd: PostgreSQL DBA job - contract to hire

This just in. Contact me if you're interested. Via a recruiter, and I don't
know which company this actually is.

---------- Forwarded message ----------
Date: Tue, Sep 23, 2008 at 3:27 PM
Subject: PostgreSQL DBA job - contract to hire
To: selenamarie(at)gmail(dot)com

Here is a copy of the job description:

*Job Description: *

Title: PostgreSQL DBA

Duration: 6 Months - FTE

Location: Lake Oswego, OR

Minimum 5 years of progressive experience performing PostgreSQL
administration production environment; experience should include three or
more years of database administration in an enterprise level environment
with very large (> 1 terabyte) databases

Responsibilities:

Collaborate with others to determine and deploy database solutions to
business prioritized requirements, including business continuance and
information security along with functional requirements

Install, configure, and test new PostgreSQL databases, perform version
upgrades of existing databases

Install, upgrade and maintain all PostgreSQL-related server and
administration software

Perform DB profiling and optimization; analyze and propose schema changes to
PostgreSQL databases as needed

Proactively monitor activity, utilization, exceptions and database health;
propose and deploy appropriate improvements; automate repetitive tasks

Collaborate with team members to create, publish and maintain database
deployment methods and procedures for PostgreSQL databases

Collaborate with the Infrastructure Architect to create and maintain
database technology roadmaps and deployment plans

Perform database backup and recovery duties; establish standards and
schedules for database backups; develop and routinely test recovery
procedures for each database; ensure that backup

schedules meet the recovery requirements and conforms to all database and
data quality policies and standards

Work closely with project teams to ensure project success; coordinate
product releases, data structure evolution, and manage and synchronize data
promotions between development, test and production environments

Act as the final point of escalation and resolution for data related issues

Provide advanced technical support for database developers

Provide 24x7 database support as part of a rotation of DBAs

Design, implement and maintain archival and high availability strategies

Skills and abilities

Exceptional knowledge of the PostgreSQL database platform

Mastery of physical database design

Expertise in configuring, implementing and supporting high availability
strategies with database systems including clustering, and replication

Mastery of ANSI SQL and/or PL-SQL

Experience in software development using Perl, Shell, or other scripting
languages

Solution focused and methodical, careful attention to detail

Solid background using UNIX operating systems – Ubuntu Linux administration
a plus

Experience with SQL Server and/or Oracle database platforms is desirable

Ability to perform capacity planning which supports the forecasting and
purchasing processes

Ability to implement Database security safeguards and audit them

Consistently learning about trends and features in DB solutions, able to
bring best practices to bear at solving DB and overall application problems

Ability to work in a high availability production environment where
unplanned downtime is not acceptable

Ability to communicate ideas and designs to all stakeholders, including
non-technical audiences

--
Selena Deckelmann
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily