Pet360, Inc. is the largest and fastest growing integrated media & ecommerce company dedicated to the U.S. consumer pet industry. We are headquartered in the Philadelphia area with offices in NYC, Miami, Colorado and Louisville and have distribution centers on both coasts. We are redefining the pet parenting experience by providing pet owners easy access to the tools and resources they need – trusted information from a team of experts, connections to other pet parents, and convenient online ordering solutions for pet food, meds and supplies.

As the company continues to grow, we’re looking to expand the Pet360 Pack by adding talented individuals who enjoy an innovative, fast-paced and entrepreneurial environment where change is encouraged and your impact is instantly visible. The company is backed by leading private equity and venture capital firms and is well capitalized to continue our exceptional growth.

Our family of premium brands includes Pet360.com – the most comprehensive online resource for pet parents; petMD.com – the world’s largest digital resource for pet health information; PetFoodDirect.com – the leading online retailer of pet food, medications and supplies; BlogPaws – the largest professional network of pet bloggers and social media enthusiasts; and Only Natural Pet – a complete line of natural pet supplies specifically formulated to be biologically appropriate for cats and dogs. Today, our network reaches more than 12 million pet parents each month!

We are looking for a MySQL Developer/DBA whose primary responsibility is to make sure that our MySQL databases are brilliantly designed, and are performing like a well-oiled machine.  This position will be a part of the team that analyzes (and fixes) our schema to make sure it’s well-designed, optimized for performance and scalability, and meets all of the standards that we will help to set.  Additionally this position is expected to help set policy, monitor, prioritize, develop standards, as well as maintain service levels for the production environment This position will also be gathering data and building a data warehouse/high-performance reporting solution with that data, so an understanding of how transactional data becomes analytical data would be extremely useful. 

We're looking for an individual that can handle working in a fast-paced Agile environment, the ideal candidate will have a strong dedication to process, standardization, and documentation. Such an individual should view producing good documentation and maintaining tight configuration management as mission critical activities, because as any good database person knows: database designs are a lot harder to change than software designs once they make it in to production. This position needs to exercise independent judgment in developing methods, techniques, and evaluation criterion for obtaining results. This position requires a self starter, willing to take on large and small challenges while operating under general supervision. 

• Design, deploy and maintain all aspects of MySQL databases.

• Work with development teams to make the best schema designs that balance feature requests with performance concerns.

• Analyze and make decisions about optimization of existing schema and queries for all database instances.

• Monitor, tune and report on the performance of MySQL database servers.

• Troubleshoot, perform problem isolation, and correct problems discovered in production databases.

• Design maintainable databases for high availability/performance and scalability to meet service levels.

• Follow change management procedures and help to create policies and best practices for all database environments.

• Perform regular DR drills to ensure system can be recovered from any incidents.

• Ensure the development and use of an effective preventive maintenance program suitable to meet the operation objective of "99.9% availability".

• Coordinate with the team that responds to all system problems in order reduce or eliminate production problems by analyzing production usage information and using that information to come up with better designs.

• Problem solving skills and the ability and desire to learn new technologies rapidly.

• Able to deal effectively with internal and external groups including development teams and vendors.

• Experience in database performance analysis, tuning and capacity planning.

• Ability to analyze and change schema design and articulate performance impacts.

• Automation of jobs and tasks with scripting languages such as bash, perl or python

• Experience working in a SaaS environment.

• Knowledge of database scalability principles.

• Ability to work with development teams in an Agile environment to develop new features, modify existing features with a “design for the future” mentality for the schema.

• Knowledge of database administration in a high-volume, highly-available Linux based environment.

• Hands-on database troubleshooting experience, including tracking down problematic queries and configurations.

• MySQL specific implementation experience.  While SQL is fairly standardized, knowledge of the specificities of MySQL is preferred.

• Firm grasp of Linux system administration fundamentals in relation to applications and databases.

• Ongoing effort to maintain skills and knowledge at the state of the art level.

• Proven ability to work independently or in a team environment.

• Excellent interpersonal and communication (verbal and written) skills.

• Knowledge of Big Data, Hadoop, and Business Intelligence a plus

This is a full time, salaried position with a full benefits package, including paid time off after 90 days, medical, dental,  and a generous product discount. Lots of other fun company perks too!