MySQL Database Administrator

We are CMC, a rapidly-growing software start-up headquartered in Wilmington, Delaware, with offices in London and Sydney. Serving financial services companies globally, CMC delivers automated customer management solutions that help our clients operate more efficiently, seamlessly, and profitably across the full credit lifecycle. We are driven by the vision to power the revolution in customer engagement.

The CMC work environment is quite dynamic and fast paced but always exciting. We have assembled an insider team of industry thought leaders, cutting edge strategists, and “get it done” software specialists chosen for category intelligence, proven expertise, and breakthrough thinking. If you are interested in becoming part of this team dynamic, please inquire within.

Job Description

The MySQL Database Administrator is responsible for providing operational database services as well as project-level support to the organization. This DBA role requires a service-oriented mentality with a high sense of ownership of the problems and requests assigned, the ability to focus on managing and resolving issues within SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests and proactively escalating any issues that cannot be resolved within the established time frames.

Responsibilities

  • Perform day-to-day production MySQL database administration tasks in a Linux environment, including maintenance, troubleshooting, tuning, optimization, installation, upgrades, backup/recovery, and data migration across multiple data centers and multiple database server architectures/systems.
  • Troubleshoot and resolve production database issues
  • Ensure performance, security, and availability of databases
  • Profile server resource usage, optimize and tweak as necessary
  • Maintain database design/release documentation
  • Work closely with Engineering and DBA Team to design and implement optimal solutions

Skills and Qualifications

  • Bachelor’s degree in computer science or related IT field preferred
  • 3+ years’ hands on experience in designing and administering MySQL databases in a HA Environment.
  • Knowledge of de-facto standards and best practices in MySQL
  • Experience with replication configuration in MySQL
  • Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
  • Proficient in writing and optimizing SQL statements
  • Ability to plan resource requirements from high level specifications
  • Unix shell scripting and the ability to automate routine tasks
  • Familiarity with monitoring tools and how to apply to DB environment
  • Must be ready to support environments remotely while on on-call.

Preferred Qualifications

  • Experience supporting DB for application built with Java/Hibernate
  • Proficient understanding of code versioning tools such as git
  • Experience with ETL tools and data warehouse concepts
  • Experience with Percona Server