Intermediate Database Administrator - Toronto

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@afilias.info


--
Tim Goodaire  
Data Services Team Lead
tgoodair@ca.afilias.info  
416-673-4126