We are seeking a highly skilled and motivated Senior Database Administrator (DBA) to join our team in Gurgaon. The ideal candidate will have 4-6 years of experience managing and optimizing MySQL databases in a production environment, with a strong focus on AWS RDS and Aurora. You will be responsible for ensuring the availability, performance, and security of our critical database systems. You will collaborate with development and operations teams to design, implement, and maintain scalable and efficient database solutions.
Responsibilities:
- Install, configure, and maintain MySQL databases on AWS RDS and Aurora.
- Monitor database performance and proactively identify and resolve performance bottlenecks.
- Implement and manage database backup, restore, and recovery procedures.
- Perform database upgrades and patching.
- Implement and maintain database security best practices.
- Perform database housekeeping tasks, including archiving and data retention.
- Performance Tuning and Optimization:
- Analyze and optimize complex SQL queries for performance.
- Tune database parameters and configurations for optimal performance.
- Implement and manage database partitioning and sharding strategies.
- Conduct performance testing and capacity planning.
- Participate in database design and schema reviews.
- Assist in developing and implementing database standards and best practices.
- Collaborate with development teams to ensure efficient database usage.
- Basic understanding of ETL processes.
- Implement and manage database replication and high availability solutions (Master-Slave, etc.).
- Develop and maintain disaster recovery plans.
- Ensure business continuity through effective database management.
- Manage and maintain databases on AWS RDS and Aurora.
- Utilize AWS monitoring and management tools (CloudWatch, etc.).
- Implement and manage database security groups and IAM roles.
- Collaboration and Communication:
- Work closely with development, operations, and other teams to ensure seamless database operations.
- Communicate effectively with technical and non-technical stakeholders.
- Document database configurations and procedures.
- Troubleshoot and resolve complex database issues.
- Take ownership of database-related tasks and projects.
- Demonstrate a proactive and analytical approach to problem-solving.
- Participate in on call rotation.
Required Skills and Experience:
- 4-6 years of experience as a MySQL DBA in a production environment.
- Strong experience with AWS RDS and Aurora.
- Deep understanding of database concepts, including sharding, partitioning, high availability, and master-slave replication.
- Expertise in database performance tuning and query optimization.
- Experience with database backup, restore, and disaster recovery procedures.
- Knowledge of database security best practices.
- Experience with database monitoring and management tools.
- Understanding of ETL processes.
- Strong SQL skills.
- Excellent communication and interpersonal skills.
- Strong analytical and problem-solving abilities.
- Ability to work independently and as part of a team.
- High level of ownership and accountability.
- Experience with Linux operating systems.
- BE in Engineering, preferably Computer Science.
- Experience working in companies that have run large-scale database environments.
- Knowledge of scripting languages like Bash or Python is a plus.
Preferred Qualifications:
- Experience in the Fintech industry, particularly lending and payments.
- AWS certifications (e.g., AWS Certified Database - Specialty).
- Experience with other database technologies (e.g., PostgreSQL).
- Exposure to NoSQL and OLAP data stores.
- Experience with Infrastructure as Code tools like Terraform or Cloudformation.
What We Offer:
- Competitive salary and benefits package.
- Opportunity to work on cutting-edge Fintech technologies.
- Dynamic and collaborative work environment.
- Career growth and development opportunities.
- A chance to make a significant impact on a rapidly growing company.
Work Location: In person
