Senior Database Administrator
Noida
Technology – Technology Infrastructure & Security /
Permanent /
Hybrid
We think you also hate when travel app is giving you a headache, right? A slight misinformation can ruin the trip.
That is exactly what we are tackling as t-fam! Making sure that our 50+ million users have the best experience in crafting their own adventure.
Your main duties in flying with us:
- Design and Architect: design and architecture of MySQL, MongoDB, and PostgreSQL databases to meet scalability and performance requirements for complex applications.
- Advanced Troubleshooting: Utilize advanced troubleshooting skills to resolve database issues, including performance bottlenecks and data integrity problems.
- High Availability: Implement and manage high-availability and disaster recovery solutions for MySQL, MongoDB, and PostgreSQL, including replication, clustering, and failover strategies.
- Capacity Planning: Conduct in-depth capacity planning and forecasting to ensure database resources meet future growth and performance demands.
- Automation: Develop and maintain automation scripts and tools for database management tasks, including backups, monitoring, and provisioning.
- Performance Tuning: Perform comprehensive performance tuning, including query optimization, indexing strategies, and resource utilization adjustments.
- Security Management: Oversee database security, including access controls, encryption, and vulnerability assessments, ensuring compliance with industry standards and regulations.
- Documentation: Maintain detailed documentation for database configurations, procedures, and troubleshooting guides to support operational excellence.
- Collaboration: Collaborate with application developers, system administrators, and other stakeholders to ensure seamless integration and performance of databases.
- Mentorship: Provide guidance and mentorship to junior DBAs and other team members, sharing expertise and best practices for database management.
Mandatory belongings that you must prepare:
- A Bachelor's degree in Computer Science, IT, or a related field; a Master’s degree is highly desirable.
- 6+ years of experience working with databases, including MySQL, MongoDB, and PostgreSQL, with a proven track record in a senior or lead DBA role.
- Expertise in advanced SQL query writing, performance tuning, and database optimization techniques for MySQL and PostgreSQL.
- In-depth experience with cloud environments (Google Cloud) and database services such Google Cloud SQL etc.
- Proficiency in a programming language such as Bash and Python, with the ability to develop custom scripts and automation tools.
- Extensive experience with MySQL, MongoDB, PostgreSQL, and familiarity with other NoSQL databases like Redis, Apache Cassandra is a plus.
- Demonstrated leadership skills, including the ability to manage complex projects, drive initiatives, and mentor junior staff.
- Excellent communication skills with the ability to articulate technical concepts to non-technical stakeholders and lead cross-functional teams.
- Strong analytical and problem-solving abilities to address complex database challenges.
- A proactive approach to adopting new technologies and methodologies to improve database management practices.
- A reliable team player with a collaborative mindset and a strong desire to contribute to the team’s success and continuous improvement.
