Job Description

Are you passionate about solving roadblocks & challenges faced by MSMEs in India?MSMEs contribute significantly to Indiaxe2x80x99s total GDP. 90% of Indiaxe2x80x99s ~$1 Trillion Retail Market is controlled by Micro, Small & Medium Enterprises (MSMEs). Which means ~$900B worth of commerce flows through these ~60M MSMEs in the form of shops/kiosks/homes, scattered all over the country. We at Khatabook, have a vision to empower MSMEs and help them increase their incomes. We have built a product that brings efficiency in MSME operations by providing them easy to use tools to manage their receivables, inventory and billing which creates transparency in their cash flow. Within the Khatabook platform, we have also enabled the facility to take loans for their short term working capital needs for select Khatabook users that are displaying good credit behavior. Our app has been downloaded over 100 Million times with a monthly active user base of 8 Million+ which are adding 220 Million+ transactions with a transaction value of $18 Billion.Why work with usPeople are our biggest asset! At Khatabook, every one of us is a dynamic superstar. We have carefully bred an ecosystem which hires nothing but incredibly and exceptionally talented people who can dream, collaborate, experiment, and break new ground. Wexe2x80x99re a strong team that looks out for each other.Your roleWe, at Khatabook are looking to hire a Database Administrator . If you want to tackle hard and interesting problems at scale and create an impact within an entrepreneurial environment, this is the place for you.What would you do at Khatabook?

• Manage and maintain database systems, ensuring their availability, performance, and security.
• Work with variety of AWS hosted and self hosted databases like PostgreSQL, MongoDB, Redis, AWS DynamoDB, etc.
• Migrate large AWS hosted PostgreSQL to self hosted with complex querying patterns
• Implement and maintain database security measures, access controls, and backup/recovery strategies.
• Collaborate with development teams to design, implement, and optimize database schemas and queries.
• Monitor database performance, identify bottlenecks, and implement solutions to optimize database performance.
• Troubleshoot database-related issues, working with internal teams and external vendors as needed.
• Participate in on-call rotation for 24x7 database support.
• Stay up-to-date with new database technologies, and methodologies, and share knowledge with the team.
• Implement new technologies and improve processes.

• Good knowledge of SQL queries and writing optimized queries
• Experience debugging SQL queries for performance issues
• Optimizing DB configurations and SQL queries for best performance to cost tradeoffs
• Experience with Cloud Computing and AWS.
• Knowledge of data security, access controls, and backup/recovery strategies.
• Strong troubleshooting and problem-solving skills.
• Excellent communication and collaboration skills.
• Ability to work independently as well as part of a team.
• Experience with database administration, specifically with PostgreSQL.

• Experience with MongoDB, DynamoDB
• Experience working in an Agile/Scrum development process.
• Familiarity with Kubernetes
• Experience with InfoSec audits
• Experience with performance and/or security testing
• 3+ years work experience in Database management and optimization

Khatabook