Senior Database Administrator
Zynga Inc
Toronto, Canada
7d ago

Position Title : Senior Database Administrator

Department : Data Management

Reports To : Manager, Database Administration

Position Summary :

You will be responsible for supporting, maintaining and further enhancing the use of MySQL, Aurora, Vertica and other databases including NoSQL solutions.

This position will help to provide a stable, high performing database platform to support a variety of large scale online social games and other applications.

A passion for gaming is desirable.

Responsibilities :

  • Manage database systems in cloud (AWS / GCP) and on premise environments
  • Maintain data integrity and high availability of database systems
  • Manage configurations for MySQL, Aurora / RDS, Vertica and other database systems
  • Triage, fix, or escalate system and database issues
  • Update and tune database systems in high volume environment loads
  • Work with Games and App teams for design, problem-solving and best practices
  • Work with Operations to manage database hardware infrastructure
  • Participate in on-call rotation
  • Document procedures
  • Use and write automation and reporting tools to manage databases
  • Identify and recommend tools and services for managing infrastructure
  • Automate systems and deployment procedures
  • Analyze and develop capacity planning for database growth
  • Required Skills :

  • 7+ years RDBMS experience working in a high volume production environment
  • At least 4+ years as a MySQL DBA in a LAMP environment (Centos / Redhat preferred)
  • Experience in AWS and / or GCP (Google Cloud)
  • Knowledge of NOSQL databases (Couchbase, Redis, MongoDB, etc.,)
  • Advanced level knowledge in various aspects of MySQL 5.x / Aurora / RDS and problem-solving skills
  • Experience with Nagios, Cacti, Sysdig, Datadog, Newrelic and / or Grafana
  • Solid knowledge of physical and logical database design
  • Solid knowledge in schema design principles with demonstrated aptitude to apply best practices for scalable designs and influence developers
  • Experience with Percona (or other) tools for query optimization and schema changes.
  • Proficiency in writing automation scripts in Perl , Shell, PHP or Python
  • Excellent verbal and written communication skills and team spirit
  • Other Preferred Skills :

  • I / O performance tuning
  • Understanding and troubleshooting TCP / IP networking services
  • Knowledge of Vertica or other data warehouse systems
  • Database sharding
  • Broad exposure to Open Source tools to including automation, monitoring, networking, clustering and database
  • Experience in online gaming environment
  • Knowledge of Subversion, Git or other source code version control and repository tools
  • Apply
    Add to favourites
    Remove from favourites
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form