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
