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

Intermediate Database Administrator

From: Tim Goodaire <tgoodair(at)ca(dot)afilias(dot)info>
To: pgsql-jobs(at)postgresql(dot)org
Subject: Intermediate Database Administrator
Date: 2010-09-10 17:06:52
Message-ID: 4C8A65AC.8070606@ca.afilias.info (view raw or flat)
Thread:
Lists: pgsql-jobs
*Intermediate Database Administrator (DBA) job description (*Toronto, ON*)*



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 
_careers(at)ca(dot)afilias(dot)info <mailto:careers(at)ca(dot)afilias(dot)info>_

-- 
Tim Goodaire    416-673-4126    tgoodair(at)ca(dot)afilias(dot)info
Database Team Lead, Afilias Canada Corp.


pgsql-jobs by date

Next:From: Barzin DaragahiDate: 2010-09-17 19:30:28
Subject: Sr. Postgres Lead DBA | Downtown Chicago | On-Line Advertising Company
Previous:From: Lamb, Mary (IMS)Date: 2010-09-09 18:29:03
Subject: Job posting

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