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@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