---------- Forwarded message ----------
From: Susan Schmidt <susans@infogroupnw.com>
Date: Wed, Aug 27, 2008 at 4:32 PM
Subject: [pgsql-jobs] Please post this position to your group
To: pgsql-jobs@postgresql.org
Direct hire position in Portland, OR
Salary is up to $100K
Position Summary
The Senior Database Administrator (DBA) leads and provides the
direction for database technology and administration for all database
environments. The DBA is the primary support for all development,
test and production database environments to ensure high availability,
reliability, appropriate capacity, scalability, backup, recoverability
and performance. In addition, the Senior DBA is expected to
participate in the 24x7 on-call support rotation.
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
- Design, implement and maintain archival and high availability strategies
- Provide advanced technical support for database developers
- Provide 24x7 database support as part of a rotation of DBAs
Needed 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 unacceptable
- Ability to communicate ideas and designs to all stakeholders,
including non-technical audiences
Needed Education and Experience
- Minimum bachelor's degree in Computer Science or related field;
equivalent combinations of education and experience will be considered
in lieu of a degree
- Minimum five years of progressive experience performing PostgreSQL
administration in a production environment; experience should include
three or more years of database
administration in an enterprise level environment with very large (> 1
terabyte) databases
Susan Schmidt
Sr. Recruiter
503-598-3182 Office
503-720-8677 Cell
503-968-3198 Fax
INFOGROUP NORTHWEST
2 Centerpointe Drive, Suite 105
Lake Oswego, OR 97035
--
Selena Deckelmann
PDXPUG - http://pugs.postgresql.org/pdx
Me - http://www.chesnok.com/daily
--
Sent via pdxpug mailing list (pdxpug@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pdxpug
No comments:
Post a Comment