[job] DBA position in San Mateo

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: [job] DBA position in San Mateo
Date: 2009-12-16 23:42:38
Message-ID: 4B29706E.3070907@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

If you are interested in this position, please contact:

jigar(at)aggregateknowledge(dot)com

Do NOT contact me, or the mailing list.

The contact says he also has 2 sysadmin positions.

===============

PostgreSQL Database Administrator

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.

Key Strengths:

* Able to troubleshoot and resolve network, application, and systems
issues expediently.
* Be flexible to work rotating shifts in a 24 x 7 environment.
* Possess excellent verbal and written communication skills.
* Occasional visits to our local data center will be needed, so
transportation is a necessity.

Browse sfpug by date

  From Date Subject
Next Message Christophe Pettus 2009-12-23 06:08:06 11/10 SFPUG meeting, "Continuent Tungsten with PostgreSQL, " video now available
Previous Message Josh Berkus 2009-12-15 23:59:18 Re: Recommended/Not Recommended Hosts?