MySQL Database Engineer

Job Overview -
Dhwani is looking for an experienced (5-10 years) MySQL database
administrator who will be responsible for ensuring the performance,
availability, and security of clusters of MySQL instances. The person will also be responsible for orchestrating upgrades, backups, and provisioning database instances. He/She will also work in tandem with the other teams, preparing documentation and specifications as required.
Job Responsibilities

• Provision MySQL instances, both in clustered and non-clustered
  

configurations

• Ensure performance, security, and availability of databases
• Prepare documentation and specifications
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
  
• Profile server resource usage, optimize and tweak as necessary
• Collaborate with other team members and stakeholders
• Writing queries and generating a report
  

Required Skills

• Strong proficiency in MySQL database management, decent experience with recent versions of MySQL.
• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
• Experience with replication configuration in MySQL
• Knowledge of de-facto standards and best practices in MySQL
• Proficient in writing and optimizing SQL statements
• Knowledge of MySQL features, such as its event scheduler

  Looking to get Placed? Try our Placement Guarantee Plan

  Get Hired
• Ability to plan resource requirements from high-level specifications
• Familiarity with other SQL/NoSQL databases along with monitoring
  

tools. maxscale and Proxy SQL.

• Working in a Linux environment is a must.
• Knowledge of Docker is an advantage.
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases.
• Should hand on writing complex queries and generating reports as per requirement
• Experience in handling multi-location databases
  

Education
Bachelor’s degree in an analytical related field, including information
technology, science, and engineering discipline. Skills:- undefined and undefined