San Mateo Categories:
PostgreSQL Database Administrator Aggregate Knowledge
THIS JOB HAS EXPIRED
We?re looking for an experienced individual to help us continue to build the AK Platform, which is currently powering the top agencies and advertisers in the world.Our Postgres DBA is somebody with real-world experience administering highly available PostgreSQL databases in a Linux environment. You?ll have the opportunity to help shape the direction of our products, to solve problems involving massive datasets, and to branch out and become an expert on other data storage technologies along the way.
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, data warehousing, and/or infrastructure/support systems.
Responsibilities:
Rotating 24-7 on-call support.
Support 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.
Ensure 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 with Postgres administration and tuning in a Linux environment.
Strong knowledge of data relationships and data normalization.
SQL, Perl, python, ruby, bash, 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.
Desire and ability to increase personal skill set as business and technology needs dictate; we?re growing, and we want you to grow with us.
Excellent communication skills.
Other:
Must be able to troubleshoot and resolve network, application, and systems issues expediently.
Must be flexible to work rotating shifts in a 24 x 7 environment.
Must possess excellent verbal and written communication skills.
Occasional visits to our local data center will be needed, so transportation is a necessity.
| Location: | 1510 Fashion Island Boulevard Suite 350 San Mateo, CA 94404 United States |
|---|
THIS JOB HAS EXPIRED
Aggregate Knowledge
The Pique Discovery Network by Aggregate Knowledge is the internets first discovery network. The Pique Network delivers highly targeted products and content based on what is actually being purchased and viewed on the web in real time.Investors: First Round Capital, Kleiner Perkins Caufield & Byers
All Jobs: at Aggregate Knowledge
| Web Site: | www.aggregateknowledge.com |
|---|---|
| Headquarters: | 1510 Fashion Island Boulevard Suite 350 San Mateo, CA 94404 United States |
| 2005 | |
| Industry: | IT Services |
| Aggregate Knowledge provides the Pique Discovery Network. The Pique Discovery Network connects consumers to the hottest products, hidden content gems and coolest items from industry leading retailers and media companies. Pique Discovery Network companies improve engagement and sales conversions, create new revenue opportunities and deliver differentiated experiences on their web sites. The Aggregate Knowledge Pique Discovery Network is the Internet's first Discovery Network that emulates the way people naturally discover and shop for products and information offline. Built on top of a sophisticated super computing architecture, Pique technology harnesses the collective behavior of Internet users to drive the most relevant content and product placements on customers' web sites, across multiple network sites and through email and affiliate promotions. Pique offerings help companies improve engagement and conversions, create new revenue opportunities and deliver differentiated experiences on their web sites. Funded by premier venture capital firms Kleiner Perkins Caufield & Byers and DAG Ventures, the company's management team includes veterans from Blockbuster, IBM, Kodak, Mercury, Microsoft, Salesforce.com, Sun Microsystems and Tribe.net. Aggregate Knowledge was recently acknowledged as an AlwaysOn Media 100 winner, a Supernova Connected Innovator, and was selected as a Ones to Watch company by Dealmaker Media. |
Support Aggregate Knowledge with Social Media services
Find more PostgreSQL Database Administrator jobs
