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(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