MySQL Database Engineer

Careers at Bloomberg

New York

Posted Aug 31, 2017 - Requisition No. 61389

Our team:

The Bloomberg Database Engineering team maintains large-scale, high transactional databases with focus on high availability and performance. Our 25k plus database instances run MySQL, PostgreSQL, Oracle, Db2, and SQL Server. To manage these effectively, we operate a DBaaS (Databases-as-a-Service) platform which empowers our developers to manage their own databases.

What's in it for you:

On our team you will manage rapidly growing, complex and highly available MySQL server infrastructure. You will need to define best practices for automated procedures in deploying and scaling the environment. You will also serve as a lead technical resource in the implementation and oversight of the database system. We expect you to know MySQL database system inside and out and be a little bit obsessive about automation.

We'll trust you to:

  • Develop best practices and automate procedures for deploying and scaling databases
  • Ensure performance, security, and availability of MySQL databases
  • Troubleshoot database-related application performance issues
  • Educate application developers on writing efficient queries and database schemas
  • Be an expert in performance tuning, backup/recovery, and capacity planning
  • Participate in an on-call rotation
  • Write and maintain scripts to automate complex tasks

You need to have:

  • 5+ years of experience working with MySQL
  • Good scripting skills and working knowledge of Python
  • A deep understanding of MySQL internal architecture
  • Expert knowledge in MySQL and InnoDB configuration and tunables
  • Strong Linux systems and scripting proficiency
  • Familiarity with backup and recovery strategies

We'd love to see:

  • Familiarity with other databases, especially PostgreSQL
  • Previous exposure running Percona XtraDB Cluster DB
  • Experience with hardware benchmarking and performance optimization
Similar jobs