AVAILABLE POSITIONS Senior Database Administrator

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

Careers region: North America

Careers Category: IT, Development Operations & Security

Careers location: Toronto, Canada

Careers Type: Full-Time