Senior Software Engineer - NoSQL DBA

Senior Software Engineering - DBA                           

About Team

Database Engineering team is responsible for the end to end management of Myntra's hundreds of production databases hosted on NoSQL , Mongo and Cassandra stacks . The volume of data managed is of the order of thousands of TBs with peak loads at millions of read/writes per min at peaks .The team  is responsible for the entire change management  , high availability , continuous performance for all these databases. The ownership starts right  from the server provisioning , Database installation  , application integration, production support  and peak performance preparations . DBE team is also  responsible  for Database tech enhancements , futuristic  needs , capacity management both in terms of volume and velocity . This team also takes care of different internal and external audits like SOX , ISO , PCI  etc from the database perspective.  Ensuring timely  Database recovery from potential local or Global disasters is another key function under the DBE team . The team comprises Engineers with vast experience on  different SQL and NOSQL databases popular globally.

Roles and Responsibilities

• Installation and configuration of NoSQL instances on single or multiple ports. ∙
• Hands on experience of production on medium to big sized NoSQL databases
• Setting up and maintaining users and privileges management systems and Troubleshooting relevant access issues.
• Understand the transaction flowsand ACID compliance.
• Performing on-call support and should be able to provide the first level support .
• Configure and setup NOSQL databases like mongodb and Cassandra.
• Automation of repetitive tasks.

Qualifications & Experience

• 3-6 years of Hands-on experience of working with NoSQL DBA .
• Some exposure to external tools like Percona , ProxySQL , HAP etc.
• Understanding of networking concepts .
• verbal and written communication skills.
• Experience in tools like shell , python . perl etc for automation.
• fundamentals on the linux system side and monitoring tools like top , iostats , sar etc.
• Clear understanding of NoSQL Replication process flows , threads , setting up multi node clusters and basic troubleshooting.
• Understanding of at least one of the backup and recovery methods for MySQL, fundamentals of SQL. Understand and tune complex SQL queries when needed.