Database Administrator

  • Bengaluru
  • Razorpay

The Role:

Database Administrator is critical to the project’s overall success, right from planning to supporting primary KPI as customer satisfaction and productivity.


Responsibilities

  • Ensure the reliability, performance, and scalability of our database infrastructure.
  • Work closely with application teams to ship solutions that integrate seamlessly with our database systems.
  • Analyzed solutions and implement best practices for supported datastores(Primarily MySQL , PostgreSQL).
  • Develop and enforce best practices for database security, backup, and recovery.
  • Work on the observability of relevant database metrics and make sure we reach our database objectives.
  • Provide database expertise to engineering teams (for example through reviews of database migrations, queries and performance optimization).
  • Work with peers(DevOps, Application Engineers) to roll out changes to our production environment and help mitigate database-related production incidents.
  • Work on automation of database infrastructure and help engineering succeed by providing self-service tools.
  • OnCall support on rotation with the team.
  • Support and debug database production issues across services and levels of the stack.
  • Document every action so your learnings turn 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.


Requirements

  • Have at least 2-4 years of experience running MySQL/PostgreSQL databases in large Environments.
  • Awareness of cloud infrastructure (AWS/GCP).
  • Have 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.


The Nice-to-Haves

  • Knowledge of caching (Redis / Elasticache)
  • Knowledge on scripting languages (Python)
  • Knowledge of infrastructure automation (Terraform/Ansible)
  • Familiarity with DevOps practices and CI/CD pipelines.