Intermediate Database Administrator

*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(at)ca(dot)afilias(dot)info <mailto:careers(at)ca(dot)afilias(dot)info>_

--
Tim Goodaire 416-673-4126 tgoodair(at)ca(dot)afilias(dot)info
Database Team Lead, Afilias Canada Corp.