[pgsql-jobs] Intermediate Database Administrator

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



*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@xxxxxxxxxxxxxxx <mailto:careers@xxxxxxxxxxxxxxx>_

--
Tim Goodaire    416-673-4126    tgoodair@xxxxxxxxxxxxxxx
Database Team Lead, Afilias Canada Corp.


--
Sent via pgsql-jobs mailing list (pgsql-jobs@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jobs


[Postgresql General]     [Postgresql Performance]     [Postgresql Admin]     [PHP Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]