PostgreSQL Database Administrator

The below job position might be of interest to some on the list.

----------------------------------------------------

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... Afilias is a global registry service company that is
specialising in running Internet domain names registries, including
.INFO, .ORG, and others. Our Data Services team consists of 8 highly
technical and very capable DBAs, and we are involved in all the aspects
of supporting our business applications from the development stage to
the production implementation. As such, we are participating in
application development, performing database analysis and design, and
supporting the applications in production on a 24x7 basis.

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

* Programming experience and familiarity with data storage devices are
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