Lead Database Administrator

Overview

Lead Database Administrator at Razorpay responsible for managing and maintaining databases, ensuring the integrity, security, and performance of the databases that store and retrieve data critical to the organization's operations.

What you'll do

• Ensure the reliability, performance, and scalability of the database infrastructure.
• Work closely with application teams to ship solutions that integrate seamlessly with database systems.
• Analyze solutions and implement best practices for supported data stores (primarily MySQL and PostgreSQL).
• Develop and enforce best practices for database security, backup, and recovery.
• Work on the observability of relevant database metrics and make sure database objectives are met.
• Provide database expertise to engineering teams, for example through reviews of database migrations, queries, and performance optimizations.
• Work with peers (DevOps, Application Engineers) to roll out changes to the production environment and help mitigate database-related production incidents.
• Work on automation of database infrastructure and help engineering succeed by providing self-service tools.
• Support on-call rotation with the team.
• Support and debug database production issues across services and levels of the stack.
• Document every action so learning turns into repeatable actions and then into automation.
• Perform regular system monitoring, troubleshooting, and capacity planning to ensure scalability.
• Create and maintain documentation on database configurations, processes, and procedures.

What you'll need

• At least 6+ years of experience running MySQL/PostgreSQL databases in large environments.
• Awareness of cloud infrastructure (AWS/GCP).
• Knowledge of the internals of MySQL/PostgreSQL.
• Knowledge of load balancing solutions such as ProxySQL to distribute database traffic efficiently across multiple servers.
• Knowledge of tools and methods for monitoring database performance.
• Strong problem-solving skills and ability to work in a fast-paced environment.
• Excellent communication and collaboration skills to work effectively within cross-functional teams.
• Knowledge of caching (Redis / Elasticache).
• Knowledge of scripting languages (Python).
• Knowledge of infrastructure automation (Terraform/Ansible).
• Familiarity with DevOps practices and CI/CD pipelines.

Details

• Location: Bangalore.