Description
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