Job Description

Justin.tv/TwitchTV is hiring a talented Database Administrator with strong PostgreSQL skills to work on database administration including backups, scripting and processing data, data warehousing, redundancy, replication, and high availability strategies. You will investigate problems, implement solutions, achieve efficiency gains, and automate repetitive tasks. You must have a strong work ethic, the ability to keep complex tasks organized, and an amazing attention to detail with innovative problem solving skills.

Responsibilities:

• Perform database backup and recovery duties; establish standards and schedules for database backups; develop and routinely test recovery procedures for each database; ensure that backup schedules meet the recovery requirements and conforms to all database and data quality policies and standards
• Install, configure, and test new databases, perform version upgrades of existing databases
• Perform DB profiling and optimization; analyze and propose schema changes to databases as needed
• Proactively monitor activity, utilization, propose and deploy appropriate improvements; automate repetitive tasks
• Collaborate with System Admin and sometimes act as a backup System Admin
• Be part of a fun, fast-paced and highly collaborative team that delivers new platform functionality, stability and performance improvements

Requirements:

• 6 years as a Database Administrator and 4 years in PostgreSQL
• Experience in coding / scripting using Python or Shell
• Expertise in configuring, implementing and supporting high availability strategies with database systems including clustering, and replication   
• Working experience with Linux
• Solution focused and methodical, careful attention to detail
• Consistently learning about trends and features in DB solutions, able to bring best practices to bear at solving DB and overall application problems
• Ability to work in a high availability production environment where unplanned downtime is not acceptable; on-call duties

Benefits:
Competitive salary including equity, full medical & dental, catered lunch & dinner, fully stocked snack closet, onsite massages, onsite haircuts, gym membership, public transportation assistance, whatever tools you desire, and many more!

Justin.tv/TwitchTV is a Y-Combinator company. We're based out of San Francisco, CA.

For consideration, please send resume to margie@justin.tv.