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

Intermediate Database Administrator - Toronto

From: Tim Goodaire <tgoodair(at)afilias(dot)info>
To: pgsql-jobs(at)postgresql(dot)org
Subject: Intermediate Database Administrator - Toronto
Date: 2011-09-19 18:31:12
Message-ID: CALqhZFy3v74U1vCi85L8qCMyn_uzC+hmmzra0JXZORyfUQ2-aQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jobs
Afilias is one of the highest profile deployments of PostgreSQL & Slony in
the world, but if you're the candidate we're looking for, you already knew
that...

Main Purpose of the position:

  *  To provide Technical Database Administration (DBA) services and
    support for Production, Development, and Testing databases, and
    for related systems

  *  To provide Development DBA support for Business Applications using
    these databases, and to customers and other support groups

  *  To provide Data Administration and Database Research & Development
    services for all of the above

Key Responsibilities:

  * Maintain Production, Development, and Test databases

  * On a rotational basis, provide 24x7 support for Production databases

  * Ensure availability of the databases in accordance with our
    service level agreements

  * Ensure recoverability of the databases in accordance with our set
    guidelines

  * Repair problems in the databases quickly and correctly

  * Work closely with other support groups during DBMS's software
    installation and upgrades

  * Work closely with other support groups during Business Application
    installation and upgrades

  * Monitor the databases' performance and tune them as necessary

  * Provide Database Analysis & Design service to developers and other
    support groups

  * Offer assistance to developers in designing and tuning database
    queries and procedures

  * Provide other Data Administration and Data Services as requested

Required Technical Knowledge and Skills:

  * Experience supporting production RDBMSs; PostgreSQL experience is
    strongly preferred

  * Solid knowledge of SQL, and ability to transfer this knowledge to
    others

  * Experience as a UNIX sysadmin and shell scripting ; AIX and LINUX
    is strongly preferred

  * Experience supporting a mission-critical database environment with
    24x7 support

  * Familiarity with replicated databases and replication systems;
    Slony experience is strongly preferred

  * Familiarity with approaches to database backup & recovery, and
    Disaster Recovery in general

  * Familiarity with additional DBMSs (other than PostgreSQL) is an asset

  * Familiarity with data storage devices is an asset

  * Programming experience is an asset

Required Non-Technical Skills:

  * Exceptionally thorough and efficient with good organisational skills

  * Excellent analytical abilities and problems solving skills

  * Self-directed and excellent ability to take initiative

  * Excellent comprehension of written technical material and ability
    to quickly learn new technology

  * Excellent interpersonal skills and cooperation with others

  * Excellent ability to adapt to a constantly changing environment
    with potentially conflicting priorities

  * Excellent verbal communication skills and good written
    communication skills


Mental and Physical Demands:

  * Work daily on a personal computer in a standard open-plan office
    environment

  * Sometimes require to concentrate under high stress and short
    deadlines

  * On a rotational basis carry a mobile phone during non-regular
    working hours

  * Sometimes require to work extended periods outside regular office
    hours

  * Sometimes require to work from remote locations (remote offices,
    home)

  * Sometimes require to travel between Toronto and other destinations
    in Canada and the USA



To apply, please send your cover letter and resume to
abull(at)afilias(dot)info<careers(at)ca(dot)afilias(dot)info>


-- 
Tim Goodaire
Data Services Team Lead
tgoodair(at)ca(dot)afilias(dot)info
416-673-4126

pgsql-jobs by date

Next:From: Alo Naelapea - ARISTADate: 2011-09-26 08:33:34
Subject: PostgreSQL DBA - Nordic Gaming Group, Tallinn, Estonia
Previous:From: Tim GoodaireDate: 2011-09-19 18:23:52
Subject: Data Services Team Leader - Toronto

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