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

PostgreSQL DBA Opening

From: Dbarrett <dbjester(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL DBA Opening
Date: 2010-05-28 10:32:26
Message-ID: a2d575b0-71c4-4a22-9d49-e946c90b7f81@40g2000pry.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-general
Company:   Aggregate Knowledge
Location:  San Mateo, CA
Position:  PostgreSQL Database Administrator

Job Description:

Aggregate Knowledge, a fast growing company backed by top-tier venture
capital, is pioneering the new category discovery as an on-line
service. As a result of our rapid growth, we are looking for senior
engineers to join and help grow our world-operations team.

Your responsibilities will focus on service delivery: designing,
implementing, and maintaining a best-in-class infrastructure with
strict availability and performance requirements. You'll be expected
to work across functional boundaries, contribute to process
development, and participate in an on-call rotation.

The most important job requirement is the ability, experience, and
desire to provide a computationally intensive service, non-stop. Your
troubleshooting skills should be top-notch, and your communication
skills should be strong. We'd like to see experience in at least a few
key areas: performance analysis, advanced storage systems, network
engineering, and infrastructure/support systems.

Responsibilities:

•        Rotating 24x7 On-call support
•        Develop high performance relational databases to store
content, user personalization information, and billing/tracking data,
etc. Develop and implement maintenance and administration procedures
for the database systems.
•        Ensures that backups are performed regularly on all
databases.
•        Work closely with software engineers to develop and maintain
stored procedures, compiled SQL, etc. Ensure that data access methods,
database kernel patches, APIs, etc. are kept current.
•        Develop a system for gathering database performance metrics.
Using these metrics, develop a plan to ensure that database systems
are correctly configured for optimal performance. Manage and/or
participate in implementation of database system tuning, to ensure
optimal performance.
•        Ensure that database systems are adequately monitored.
Develop and implement a plan to ensure maximum reliability and
availability of database systems. Proactively monitor database system
status to determine early warning signs of problems.
•        Author and maintain scripts to perform various aspects of
administration. The DBA will document these scripts and maintain them
in the source repository.


Requirements:

•        5 years experience as a DBA
•        3 years experience of Postgres administration and tuning in a
Linux environment
•        Must have strong knowledge of data relationships, data
normalization
•        SQL, Perl, python, ruby, bash, C or other scripting
experience
•        Understanding of LVM, SAN and RAID
•        Cacti, Nagios, or other monitoring and metrics tools
•        Ability to learn quickly and adapt to a fast paced growing
and evolving service delivery system
•        Ability to manage projects through their entire life cycle
•        Excellent communication skills

Candidate must be able to troubleshoot and resolve network,
application, and systems issues expediently. Candidates must be
flexible to work rotating shifts in a 24 x 7 environment. Candidate
must possess excellent verbal and written communication skills.
Occasional visits to our local data center will be needed, so
transportation is a necessity.
Local candidates only, please, as no relocation can be offered.
Unsolicited resumes from agencies are not welcome; Aggregate Knowledge
is not responsible for any fees associated with unsolicited resumes.

For immediate consideration please send your resumes and salary goals
to dbarrett(at)maximumhr(dot)com

Responses

pgsql-general by date

Next:From: Daniel BauschDate: 2010-05-28 11:24:43
Subject: Searching for paper about pg's optimizer cost model
Previous:From: Jamie Lawrence-JennerDate: 2010-05-28 10:26:35
Subject: Merge data from two databases

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