Sr. PostgreSQL DBA | Full-Time role | Pandora - Mailing list pgsql-jobs

Hello Everyone, 

Pandora currently has an opening in the San Francisco Bay Area for a talented PostgreSQL DBA. As the old saying goes,
“Nobodyreally knows what a DBA does, but every company needs to hire one, because no one can afford to hire two.”
Pleasesee details below. 
 

A little about Pandora:

At Pandora, we're a unique collection of engineers, musicians, designers, marketers, and world-class sellers with a
commongoal: to enrich lives by delivering effortless personalized music enjoyment and discovery. People—the listeners,
theartists, and our employees—are at the center of our mission and everything we do. Actually, employees at Pandora are
alot like the service itself: bright, eclectic, and innovative. Collaboration is the foundation of our workforce, and
we’relooking for smart individuals who are self-motivated and passionate to join us. Be a part of the engine that
createsthe soundtrack to life. Discover your future at Pandora.
 

We have terrific opportunities in Database Administration for innovative, inspired problem solvers who are enthusiastic
aboutscaling Pandora's storage platforms to support our rapidly expanding community of listeners.  With the right
skillsand experience, you will be managing Pandora's 24x7 PostgreSQL clusters. You’ll get the chance to take on complex
andinteresting problems as part of a fast-paced, highly collaborative team.
 

 

We've built a complex cluster around PostgreSQL for scalability and high availability. It's imperative that you
approachadministration with an emphasis on repeatability, testability and consistency. The demands on this system are
increasingrapidly as we grow the userbase and add more functionality.
 

We're looking for individuals who can help us continue to scale our queries, our systems and our hardware to meet our
growingneeds. Someone who has shown talent at tuning database systems. A person that enjoys being exposed to different
situationsand finds pleasure in finding creative (or practical) solutions when when many thought it couldn’t be done.
 
 
Requirements
 
-  A deep understanding of database systems and the factors that affect distributed system performance-strong
preferencefor folks with PostgreSQL experience or MySQL
 
- Minimum 5 years’ experience developing and administering database infrastructure for mission critical applications.
- Strong SQL skills and deep experience writing stored procedures.
- Experience maintaining large databases(>1TB)
- Experience developing stored procedures (PL/pgSQL)
- Experience supporting redundant systems with 24X7 availability requirement
- A deep understanding of database design principals
- Thorough knowledge of current hardware systems, RAID and disk subsystems commonly used in fault tolerant production
environments+ Ability to proactively identify, troubleshoot and resolve live database systems issues
 
- Strong scripting and automation skills (Shell, Python, etc.) (Shell and Bash are the same thing)
- BS or better in Computer Science or a related field.
- Hadoop or other NoSQL administration experience a plus
 

Core Technologies
 
- Linux
- PostgreSQL
- Slony
- Database Administration
- Python
- Hadoop (not so much)
- Distributed System

If you’d like to speak to me about this role, what life at Pandora is like, or you just have a recommendation on a
featureyou'd like to see Pandora implement in the future, I'm open to hearing from you. 
 
To be efficient with your time and to save you from sending 3 or 4 emails you don’t want so send, feel free to use this
link:http://meetme.so/thumbsup and grab a time that works best for you.
 

Play it loud,
Joseph 


-- 
Joseph Warren | Opportunity Matchmaker 
O: 510-740-1340 | E: jwarren@pandora.com