Position description Last updated: Position name Database Administrator Main purpose of the position To install, configure, administer, maintain and support mulitiple databases and related applications both in production and test environemnts, and provide 2nd level support to the customer and technical support groups. Key responsibilities * maintain production, test, and internal (support) databases * monitor database performance and tune database management system as necessary * work closely with system administrators during software installation and upgrades * ensure availability of databases in accordance with service level agreements * correct problems in databases quickly and correctly * support and install the firm's software in the firm's production environments * support database replication system * offer assistance to developers in tuning database queries under development * produce reports as requested * assist in design of reports in co-operation with users Technical knowledge & skills required * experience with production-grade relational database management systems; PostgreSQL experience is strongly preferred. * previous experience with UNIX/Linux * ability to support a mission-critical database environment * familiarity with approaches to database backup and recovery * solid knowledge of SQL and alternative formulations of the same SQL statement * some experience with production-quality environment * ability to support replicated databases & related replication systems * familiarity with networking protocols and devices * knowledge of requirements for high availability * familiarity with UNIX shell scripting * familiarity with Perl or VB an asset * familiarity with MySQL or DB2 an asset Mental and physical demands * works daily on a personal computer * frequently carries a mobile phone during non-business hours * sometimes required to work extended periods Working conditions * standard open-plan office environment * sometimes required to work outside regular office hours * sometimes required to work from remote locations (remote offices, home) * required to concentrate under high stress and short deadlines Personal skills required * exceptionally thorough and efficient * excellent analytical ability * able to adapt to a constantly changing environment with potentially conflicting priorities * ability to take initiative * self-directed * good at working with others * excellent comprehension of written technical material * excellent verbal communication skills * good written communication skills