Skip site navigation (1) Skip section navigation (2)

PostgreSQL Database Administrator

From: Steve Singer <ssinger_pg(at)sympatico(dot)ca>
To: torontopug(at)postgresql(dot)org
Subject: PostgreSQL Database Administrator
Date: 2011-09-20 14:54:08
Message-ID: BLU0-SMTP3801C9DDCAFD985D182FC78E0A0@phx.gbl (view raw or flat)
Thread:
Lists: torontopug
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


torontopug by date

Next:From: Steve SingerDate: 2011-09-20 14:58:30
Subject: Data Services Team Leader Job Position
Previous:From: Mike MacEachernDate: 2010-12-13 14:24:08
Subject: DBA Job opportunity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group