Job Description
Razorpay was founded by Shashank Kumar and Harshil Mathur in 2014. Razorpay is building a new-age digital banking hub (Neobank) for businesses in India with the mission is to enable frictionless banking and payments experiences for businesses of all shapes and sizes. What started as a B2B payments company is processing billions of dollars of payments for lakhs of businesses across India.
We are a full-stack financial services organisation, committed to helping Indian businesses with comprehensive and innovative payment and business banking solutions built over robust technology to address the entire length and breadth of the payment and banking journey for any business. Over the past year, we've disbursed loans worth millions of dollars in loans to thousands of businesses. In parallel, Razorpay is reimagining how businesses manage money by simplifying business banking (via Razorpay X ) and enabling capital availability for businesses (via Razorpay Capital ).
The Role
Database Engineer creates and manages databases for a company or organization. This involves designing and building databases to suit a purpose. The database engineer must also install and configure the database. The database engineer must make sure that the databases are secure and that they function properly.
Roles And Responsibilities
- As the Database Engineer, you will be responsible for monitoring day to day database systems in terms of operations and management.
- Proactively respond to production infrastructure alerts and warnings, mitigate production issues as they arise and transform incident lessons into automation, documentation and monitoring Diagnose any database issues and employ measures to prevent recurrence.
- Work with the engineering and operations team in building tooling to drive scalability, reliability and performance.
- Research and develop new technologies and approaches for building highly available data persistence systems.
- Perform code reviews and answer datastore related infrastructure questions.
- Automate the daily task and complex problem to build the team proficiency.
- Proficient working knowledge on percona toolkit.
Mandatory Qualifications
- 3 - 5 years of experience in the Database reliability domain with installation, management, upgrades, backup and restore of large MySQL & PostgreSQL
- Exceptional knowledge of both MySQL and PostgreSQL Internals.
- Be a wizard with databases and associated technical configurations.
- Knowledgeable about performance tuning, query optimization, & index tuning.
- Strong hands-on experience on MySQL database engines is must, good to have understanding on PostgreSQL.
- Experience working with flavors of RDS and Elasticache.
- Experience benchmarking, Good understanding of NoSQL datastores or data structure databases is definitely a plus.
- Experience in troubleshooting and resolving database integrity, performance, blocking and deadlocking, connectivity, security issues, etc.
- Experience with Performance Tuning and Optimization using native monitoring and troubleshooting tools
- Ability to detect and troubleshoot database servers related CPU, memory, I/O, disk space, and other resource contention.
- Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
- Cloud Services such as AWS and RDS, Azure, GCP
- Proficient working knowledge of the Percona toolkit.