[pgsql-jobs] Intermediate Database Administrator - Toronto

[Tim Goodaire <tgoodair@xxxxxxxxxxxx>]

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@xxxxxxxxxxxx 


-- 
Tim Goodaire   
Data Services Team Lead
tgoodair@xxxxxxxxxxxxxxx   
416-673-4126