MySQL DBA

US-NY-New York
Job ID
2017-1877
# of Openings
1
Category
Cognitive

Overview

We are looking for a MySQL DBA that can thrive in a challenging and rewarding environment. As a MySQL DBA, you understand the issues involved with administering and maintaining stand-alone and clustered database environments, including architecture, SQL scripting, troubleshooting, monitoring, etc. and you are comfortable interfacing with customers. In addition, the MySQL DBA will participate in the installation, monitoring, maintenance, support, and optimization of all Amelia MySQL instances, integrations, and tools needed. This individual will also analyze and resolve application database problems in a timely and accurate fashion, and provide training to colleagues where required.

Responsibilities

Strategy & Planning

  • Create and maintain documentation as it relates to MySQL database support, custom tools, processes, and standard operating procedures, using MS Office products like Word and Visio
  • Develop, implement and maintain policies, procedures, and associated training plans for MySQL database support, tools, and automation.

Acquisition & Deployment

  • Create tools and automations to facilitate the smooth operation of the Amelia database stack.
  • Conduct research on network products, services, protocols, and standards to remain abreast of developments in the database industry.

.

Operational Management

  • Develop tools to ensure smooth and reliable operation for fulfilling business objectives and processes.
  • Monitor database stability, availability and performance.
  • Identify, diagnose and resolve database and system problems as needed.
  • Oversee installation, configuration, maintenance, and troubleshooting of Amelia’s hardware and software.
  • Provide support for MySQL databases and on a lower level for systems, applications and networks.
  • Automate tasks as much as possible through the development of scripts and our proprietary IPautomata framework.
  • Identify, evaluate and recommend database related tools and emerging technologies.
  • Ensuring 24x7x365 operation of internal and client database systems.
  • Monitor and test database performance and provide performance statistics and reports.

Qualifications

  • Hands-on experience supporting MySQL database clusters (Percona/Galera).
  • 4+ years of MySQL database administration
  • Knowledge about - and experience with database performance tuning
  • Experience with MySQL replication and optimization
  • Experience estimating MySQL Database capacities and developing methods for monitoring database capacity and usage.
  • In depth knowledge of mechanisms for data backup and restoration.
  • Knowledge of methods used for physical design optimization .
  • Must have user-level experience with Linux systems
  • Excellent troubleshooting experience

 

Preferred

  • Knowledge of relational database physical design
  • Working knowledge of Percona/Galera clusters
  • Knowledge about ITIL
  • Perl
  • percona tools
  • Experience with scripting languages like Python and Bash

 

Personal Attributes

  • Strong interpersonal, written, and oral communication skills.
  • Able to conduct research into networking issues and products as required.
  • Highly self motivated and directed, with keen attention to detail.
  • Proven analytical and problem-solving abilities.
  • Able to effectively prioritize tasks in a high-pressure environment.
  • Strong customer service orientation.
  • Experience working in a team-oriented, collaborative environment.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.