Shopclues is hiring a MySQL DBA who has the ability to work with other groups to design and implement distributed MySQL architecture that will support performance and scalability needs.
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 other 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.
ShopClues is an online marketplace owned by Clues Network Pvt. Ltd. It was established in July 2011 in Silicon Valley by Sanjay Sethi, Sandeep Aggarwal and Radhika Aggarwal. Based in Gurgaon, India, the company claims to have over 6 lakh merchants and 2.8 crore products on its platform, serving over 32,000 pincodes across the country.
Valued at USD 1.1 billion, ShopClues has Tiger Global, Helion Ventures, and Nexus Venture Partners as major investors.
ShopClues focuses on unstructured categories of home and kitchen, fashion, electronics and daily utility items. Across various categories, the company highly promotes local as well as regional brands. Around 70% of its Gross Merchandising Value (GMV) is received from Tier - II and Tier - III cities.
In June 2016, the online marketplace reached half a million sellers on its platform, claimed to be the highest in the Indian e-commerce industry. The employee strength as of 2017 is more than 11,000 people.