Sr. MySQL Database Engineer Viggle
The History of Viggle
Media entrepreneur Robert F.X. Sillerman founded Viggle after pioneering a number of successful television, radio and live entertainment ventures. Mr. Sillerman created the company in June 2010 to develop businesses, products and services that encourage consumers to engage with different types of entertainment content such as TV, movies, games and music.
Launched in January 2012, Viggle is a free second screen media platform that rewards its members for watching their favorite TV shows. Viggle enhances TV with interactive games like Viggle LIVE and the first ever real-time fantasy sports game MyGuy. Viggle members get rewarded for their TV time from places like Best Buy, Papa John?s, Fandango, Hulu Plus and Groupon, among others. Viggle also allows like-minded fans of their favorite shows to connect through Viggle Chatter features. Viggle?s audio verification technology recognizes shows on TV and allows members to check into live and DVR?d TV content from more than 170 of the most popular broadcast and cable channels.
Why work at Viggle?
Our workspace is open, the team is small, and collaboration is encouraged. You?ll have the ability to connect directly with other teams to share knowledge and affect the decision-making process
You get direct exposure to the public at a massive scale. Everything you do will affect millions of people who love using our app!
Viggle is an open-minded company and we love to experiment with technology. You?ll get the chance to implement cutting-edge tools and techniques if they are the right tool for the job
Viggle is looking for a Sr. Database Engineer to join our Engineering Infrastructure team.
The Viggle mobile iOS and Android application utilizes hundreds of servers and dozens of technologies to power a mobile application used by millions of people daily.
The Viggle Engineering Infrastructure team is responsible for all of the backend server development in the Viggle development and production environments. As a member of our Infrastructure team, you?ll help design, build and maintain Viggle?s growing infrastructure that supports our mobile and web-based business.
Both colo- and cloud-based, Viggle's infrastructure spans mobile application supporting infrastructure, real-time Audio/Video content ingestion and processing, data warehousing and analytics, geo-distributed services infrastructure, and more!
This includes the following responsibilities:
Selecting, specifying, installing and optimizing all Database and Data Services related hardware and software to accommodate both current and future intended design goals.
Defining and executing all operations DBA policies and procedures for dev, integration and production database and data warehouse system implementations.
Reviewing and optimizing database changes prior to production deployment.
Monitoring and maintaining implemented Database and Data Services solutions.
Designing, implementing, and executing database backup/restore strategy in a high availability environment.
Troubleshooting database issues, maintaining database systems availability and scalability.
Resolving all development related DBA technical issues.
Supporting the operational DBA needs of internal groups such as operations teams, development teams, product teams and customer service teams.
Using multiple technologies to architect new solutions and solve problems with innovative, scalable and robust designs.
Representing Engineering on projects that introduce new applications, services and technologies that yield visible and measurable change in Viggle applications.
Responding to escalations to address new business needs or ongoing high impact issues.
Managing SQL cluster resources and troubleshoot errors.
Planning and coordinating of the database utilization, conduct growth analysis and capacity/security planning.
Identifying performance bottlenecks and recommend corrective course of action.
Participating in planning and execution of recovery activities.
Planning and implementing database security policy.
Maintaining a broad knowledge of state-of-the-art technology, equipment, and/or systems.
Working closely with Development, Operations and the IT services teams in evaluating current systems
Develop and support replication of MySQL databases.
Advising software developers on best practices for improving performance, scalability and operational manageability of production databases.
Technical Job Requirements:
We are looking for someone with 8+ years professional experience in supporting, and at least 2 years professional experience acting as the final escalation point in the following skills:
Deep expertise with the Linux operating system and its operation in a large scale production environment
5+ years of experience as a Development DBA or Production DBA with development skills or equivalent for MySQL or Postgres
3 years developing for and tuning MySQL or Postgres databases
Demonstrated experience with MySQL and/or Postgres database design, implementation, performance tuning, and capacity planning
Experience managing large scale database system spread over multiple servers with 500+ GB of Data
Working knowledge of operating system internals (Shell scripting, monitoring, debugging) in Linux environments is required
Must be competent with converting logical data models into high performance physical designs
Participation in large projects/deployments that require understanding of software development life cycle
Experience defining and executing database and system maintenance procedures
Practical scripting experience in shell and Perl or Python
Basic ability to interpret Java Stack Traces
Robust troubleshooting and analytical skills
Experience with system resource management utilities to evaluate system performance
Excellent communication, documentation and presentation skills for technical and business audiences; this includes creating spreadsheets, presentations and technical diagrams as needed
Extensive knowledge of server hardware and related technologies from major vendors like Dell, IBM, HP, including: CPU Performance, RAID, DRAC, iLO, bare-metal restores, backup methodologies
Virtualization platforms such as VMWare and VirtualBox
Experience implementing data warehouse using MySQL, Postgres, Hadoop is a plus
Non-technical Job Requirements:
Able to translate high level discussions and designs into discrete tasks with time estimations required for successful implementations
Able to work both independently and collaboratively within and across functional groups as required while utilizing other resources with good judgment
Able to demonstrate high initiative and ownership of issues and assignments
Able to make both internal and external customers feel great about their support experience regardless of the outcome via high level, polished customer and relationship management skills
Able to follow internal engineering procedures and reliably perform real-time ticket documentation
Able to work according to project plan schedules, identifying and escalating risks as soon as they are detected and providing possible mitigations and solutions
Able to provide estimations on all stages of project design, specification, implementation, test and deploy
Possesses strong leadership skills and a willingness to work through tough situations and solve challenging problems
Possesses excellent written, verbal and interpersonal skills
Demonstrated continuous education, certification and self-improvement
Willing to undergo a technical skills assessment test during the interview process
Able to keep to our official office hours of 8:30am to 5:30pm, as well as any late workdays that are typical with IT positions from time to time
Education and Certification Requirements:
Bachelor or Master's Degree in Information Technology or Computer Science Preferred
RHCE or equivalent technical ability and experience
MySQL, Oracle or other equivalent industry certification preferred
||New York, NY |