Thread: PostgreSQL Database Developer and Architect (UPDATED)

PostgreSQL Database Developer and Architect (UPDATED)

From
Tim Goodaire
Date:
This is an updated posting with details about location and
telecommuting. (See the "Working Conditions and Travel Expectations"
section below)

Afilias is seeking to fill the position of Database Developer and
Architect.

Candidates should send their resume to
ynevebar(at)ca(dot)afilias(dot)info.


Database Developer and Architect (job description)


The Main Purpose of this position


As part of Afilias' strategic investment in PostgreSQL and Slony, and in
order to maximize service delivery to Afilias' business as well as for
the benefit of the PostgreSQL/Slony community at large, the individual
in this role will research design and implement, efficient
high-performance reliable and scalable DBMS technology solutions for our
DBMS and Replication systems, PostgreSQL and Slony.


The incumbent, who should be a well recognized member of the PostgreSQL
community, will work closely with Afilias' Product Development, Registry
& Application Services, Data Services, and Infrastructure groups. His or
her three main duties will be to deliver top quality DBMS technology
solutions to the Data Services department, to provide “Development DBA”
services to the Application Development departments, and to participate
in other Data Services projects as required.


Key Responsibilities

Database Developer - DBMS technology development

- Provide direct support to Afilias' sponsored community efforts for
products such as PostgreSQL and Slony
- Develop new or improve the existing database replication system
features for current and future versions
- Review the database architecture with particular emphasis on the
following concerns:
      * System performance and capacity trending
      * Anticipating and accommodating future changes
      * Analysis of the impact on maintenance, upgrade, and disaster
        recovery strategies
- Improve the database architecture, features, or utilities to answer
the above concerns
- Develop new or improve the existing database features or utilities for
current and future systems


“Development DBA” services

Work with the Application Development departments to:

- Establish standards for logical & physical database schema & table
design and database optimization
- Perform data & database analysis & design to develop logical &
physical data & database schema models
- Establish database programming standards as it relates to application
quality & efficiency
- Assist project teams and business users in data relating issues and
data analysis concepts


“Data Services” and generic DBA work

- Provide support and operational level assistance to the Data Services
team
- Design or improve the database infrastructure to support Afilias’
business objectives and systems
- Create and maintain relevant documentation


Knowledge and Skills Requirements


- Minimum of 9 year experience programming in both traditional and new
computer languages
- Minimum of 7 years experience working with UNIX systems, preferably as
a DBA or a SysAdmin
- Minimum of 5 years experience working with RDBMSs and Replication
(PostgreSQL/Slony preferred)
- Minimum of 3 years experience developing DBMS or OS system level
utilities
- Bachelor of Science, Mathematics, or Computer Science Degree, or
equivalent
- Strong technical skills with extensive hands on experience in
implementing database solutions
- Exceptionally thorough and efficient, attention to detail, and a
commitment to quality work
- Ability to adapt to a constantly changing environment with potentially
conflicting priorities
- Self-directed and able to take initiative, excellent in innovation and
analytical ability
- Excellent written and verbal communication and technical presentation
skills
- Exceptionally team oriented with excellent interpersonal skills


Working Conditions and Travel Expectations

This position is reporting to the manager of the Data Services
department, and working under the supervision of both the Data Services
Team Leader and the Senior Database Architect.

- The usual working condition is daily work on a personal computer in a
normal office environment
- Our offices are located in Toronto ON, and Horsham PA, however,
telecommute is possible as well
- Sometimes it is required to work outside of the normal working hours
or outside of the office
- Must be able to travel to, or between, the United States and Canada
(for about 1 week out of 6-8)
- Occasional travel to overseas (for about 1 week once or twice per
year) is expected as well


--
Tim Goodaire    416-673-4126    tgoodair@ca.afilias.info
Database Team Lead, Afilias Canada Corp.