PostgreSQL Database Administrator

PostgreSQL Database Administrator - Toronto, Ontario.

We run parts of the core of the Internet infrastructure, and are seeking an experienced PostgreSQL DBA in Toronto to join our Data Services team.

Do you want to work with the world's most advanced open-source database (PostgreSQL)?
Do you have a passion for running clusters of replicated databases (using SLONY) in a 24x7 environment?
Did you go to school with little Bobby tables?

Experience with Oracle, DB2, Sybase, or MS-SQL is an asset, but if you have been using PostgreSQL for the past few years, and are looking to expand your experience - then this position is for you..!

You will be part of a team of databases administrators responsible for 100+ production, QA, and development PostgreSQL databases running on Linux and AIX.
You will provide day-to-day support during normal working hours, perform database maintenance (occasionally after hours and on weekends), and participate in a 24x7 on-call rotation.
You will also work on development and technical projects with developers, system administrators, and other teams.

You should be comfortable working with open-source software. We have a track record of contributing back to the open-source products we use. You will be encouraged to contribute to these products, and your assistance in helping us to build better open-source software will be welcomed.

You should be comfortable explaining the principals of good database schema design to non-database people, and must have some experience with most of the following technologies:
- RDBMS & Replication s/w (PostgreSQL & Slony are highly desired).
- SQL queries, triggers, and stored procedures' coding and improvements.
- Puppet or another deployment automation tool (cfengine, chef, etc.).
- Unix shell scripting, and basic Unix/Linux system administration skills.
- A major scripting language (Perl, Ruby, Python, etc.).
- Database performance & capacity monitoring tools (Hyperic, Zenoss, pgstatspack, pgfouine).

Knowledge and experience with Data Administration concepts and tools (Metadata Repository, etc.) is highly desired.

If you are interested to join an exiting team in a dynamic company send you resume to abull@afilias.info