*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@xxxxxxxxxxxxxxx <mailto:careers@xxxxxxxxxxxxxxx>_
--
Tim Goodaire 416-673-4126 tgoodair@xxxxxxxxxxxxxxx
Database Team Lead, Afilias Canada Corp.
--
Sent via pgsql-jobs mailing list (pgsql-jobs@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jobs
