CTC Undisclosed Job Location Gurgaon Experience 5 - 8 yrs
Job Description for MySQL DBA Position: MySQL DBA Department: Technology Location: Gurgaon Roles and Responsibilities As Data Base Administrator (MySQL), you will be responsible for monitoring, managing, and scaling Shopclues.com production databases, implement sharding, clustering, load balancing to deliver world class scalability, performance and reliability. You will be working with engineers, architects, infrastructure teams, testing teams and senior management. Skill Set Required: 5 years of experience supporting MySQL (version higher than 5.1) on Linux.
Ability to work with others groups to design and implement distributed MySQL architecture that will support performance and scalability needs.
Actively administered several production MySQL servers in a high-traffic and distributed OLTP environment, with a mix of masters and slaves replication.
Strong knowledge and experiences in setting up and administering MySQL replication.
Strong knowledge of MySQL backup, recovery and upgrade procedures.
Help identify slow queries and suggesting alternatives.
Basic knowledge of MySQL performance tuning at the MySQL server configuration level as well as SQL tuning.
Have written moderately complex Linux/Unix shell scripts utilizing bult-in shell variables, regular expressions, conditional expressions, functions.
Working knowledge of Linux/Unix tools.
Engineering Graduate or Equivalent Qualification.
Experience setting up and managing No-SQL databases like MongoDB.
Experience with MySQL monitoring tools.