Sr. Database Administrator at myYearbook.com - Mailing list pgsql-jobs

With over 31 million registered members and 9 million unique online members per month, myYearbook has become one of the fastest growing social networks on the Internet.

As a social media company, myYearbook strives to provide its members with content and applications which are new, fresh, and innovative; this requires that we remain in a state of ongoing development for many new Web 2.0 projects.  Given our rapid growth rate and desire to build some of the most dynamic and innovative social applications in the world, we are expanding our database team and looking for a top-notch DBA to help support ongoing development.

At myYearbook, our database administrators are instrumental in designing scalable systems and they work closely with developers to design efficient data access APIs.  Likewise, as one of the most trafficked sites in the United States, myYearbook offers a unique opportunity to work on applications that will be used by millions of people and at an almost unheard of scale.  So, if you enjoy a challenge and are interested in working on one of the largest and most complex PostgreSQL implementations in the world, this job may be perfect for you.

This is a full time permanent position located in New Hope, PA.   This is not a contractor or telecommute position.

In joining our team, you'll enjoy a fantastic office location, a creative and fast-paced work environment, and the exciting opportunity to be part of a fast-growing and profitable venture-backed company.

Core Responsibilities:

• Manage and maintain existing Postgres infrastructure
• Work with DBA team to ensure database performance and reliability
• Maintain monitoring and reporting systems for our large Postgres cluster
• Perform data retention, mining and maintenance tasks
• Work with engineering teams to create and enhance schema and database APIs

Requirements:

• 5+ years of database administration experience
• 2+ years of Postgres experience
• 5+ years of experience working in UNIX/Linux environments
• 2+ years of experience working with very large databases
• Availability to write advanced SQL queries
• Experience with operations related database tasks such as monitoring, performance tuning, backup and recovery.
• Ability to program in at least two of the following languages: C, PHP, Python, Perl, Java
• Strong knowledge of BASH scripting

Things we like to see:

• Significant Postgres experience (administration, hacking, or internals)
• A strong understanding of clustering methodologies and optimizations
• Experience in large scale OLTP environments
• Advanced knowledge of PL/pgSQL
• Experience with Skytools (specifically PgBouncer and PL/Proxy)
• Experience with various Postgres replication systems
• Postgres community activity
• A background in programming or computer science

We Offer:

• Competitive salary, title and job responsibilities commensurate with experience
• Comprehensive benefits including:
  • An open source friendly organization
  • A flexible, fun working environment
  • A great location