Stashfin is a dynamic and fast-growing Fintech company focused on revolutionizing the lending and payments landscape. We leverage cutting-edge technology to provide innovative financial solutions to our customers. We are committed to building a robust and scalable platform, and our database infrastructure is a critical component of our success.
Job Summary
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
Database Administration :
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.
Database Design And Architecture
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.
High Availability And Disaster Recovery
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.
AWS Cloud Expertise
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.
Problem Solving And Ownership
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.