Company: Aggregate Knowledge Location: San Mateo, CA Position: PostgreSQL Database Administrator Job Description: Aggregate Knowledge, a fast growing company backed by top-tier venture capital, is pioneering the new category discovery as an on-line service. As a result of our rapid growth, we are looking for senior engineers to join and help grow our world-operations team. Your responsibilities will focus on service delivery: designing, implementing, and maintaining a best-in-class infrastructure with strict availability and performance requirements. You'll be expected to work across functional boundaries, contribute to process development, and participate in an on-call rotation. The most important job requirement is the ability, experience, and desire to provide a computationally intensive service, non-stop. Your troubleshooting skills should be top-notch, and your communication skills should be strong. We'd like to see experience in at least a few key areas: performance analysis, advanced storage systems, network engineering, and infrastructure/support systems. Responsibilities: • Rotating 24x7 On-call support • Develop high performance relational databases to store content, user personalization information, and billing/tracking data, etc. Develop and implement maintenance and administration procedures for the database systems. • Ensures that backups are performed regularly on all databases. • Work closely with software engineers to develop and maintain stored procedures, compiled SQL, etc. Ensure that data access methods, database kernel patches, APIs, etc. are kept current. • Develop a system for gathering database performance metrics. Using these metrics, develop a plan to ensure that database systems are correctly configured for optimal performance. Manage and/or participate in implementation of database system tuning, to ensure optimal performance. • Ensure that database systems are adequately monitored. Develop and implement a plan to ensure maximum reliability and availability of database systems. Proactively monitor database system status to determine early warning signs of problems. • Author and maintain scripts to perform various aspects of administration. The DBA will document these scripts and maintain them in the source repository. Requirements: • 5 years experience as a DBA • 3 years experience of Postgres administration and tuning in a Linux environment • Must have strong knowledge of data relationships, data normalization • SQL, Perl, python, ruby, bash, C or other scripting experience • Understanding of LVM, SAN and RAID • Cacti, Nagios, or other monitoring and metrics tools • Ability to learn quickly and adapt to a fast paced growing and evolving service delivery system • Ability to manage projects through their entire life cycle • Excellent communication skills Candidate must be able to troubleshoot and resolve network, application, and systems issues expediently. Candidates must be flexible to work rotating shifts in a 24 x 7 environment. Candidate must possess excellent verbal and written communication skills. Occasional visits to our local data center will be needed, so transportation is a necessity. Local candidates only, please, as no relocation can be offered. Unsolicited resumes from agencies are not welcome; Aggregate Knowledge is not responsible for any fees associated with unsolicited resumes. For immediate consideration please send your resumes and salary goals to dbarrett@xxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
