MySQL Database Engineer at Dhwani Rural Information Systems · Gurugram · 5 - 10 years · ₹8L - ₹14L / yr · Bootstrapped · Posted 15 Jun 2022

Dhwani is looking for an experienced (5-10 years) MySQL database
administrator who will be responsible for ensuring the performance,
availability, and security of clusters of MySQL instances. The person will also be responsible for orchestrating upgrades, backups, and provisioning database instances. He/She will also work in tandem with the other teams, preparing documentation and specifications as required.
Job Responsibilities
1. Provision MySQL instances, both in clustered and non-clustered
configurations
2. Ensure performance, security, and availability of databases
3. Prepare documentation and specifications
4. Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
5. Profile server resource usage, optimize and tweak as necessary
6. Collaborate with other team members and stakeholders
7. Writing queries and generating a report
Required Skills
1. Strong proficiency in MySQL database management, decent experience with recent versions of MySQL.
2. Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
3. Experience with replication configuration in MySQL
4. Knowledge of de-facto standards and best practices in MySQL
5. Proficient in writing and optimizing SQL statements
6. Knowledge of MySQL features, such as its event scheduler
7. Ability to plan resource requirements from high-level specifications
8. Familiarity with other SQL/NoSQL databases along with monitoring
tools. maxscale and Proxy SQL.
9. Working in a Linux environment is a must.
10. Knowledge of Docker is an advantage.
11. Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases.
12. Should hand on writing complex queries and generating reports as per requirement
13. Experience in handling multi-location databases
Education
Bachelor’s degree in an analytical related field, including information
technology, science, and engineering discipline.

About Dhwani Rural Information Systems
About
Dhwani RIS's journey began in 2012, fueled by a passion for leveraging technology to drive social change. It all started during an internship at the Institute of Rural Management Anand (IRMA), where our founders, Sunandan Madan and Swapnil Agarwal, worked closely with rural NGOs and grassroots organizations. They quickly recognized a significant gap—many of these organizations struggled to integrate technology into their work.
This realization became a mission. They saw the need for a unique approach—one that combined a deep understanding of both technology and the development sector. A one-size-fits-all solution wouldn't work; each organization faced unique challenges. So, they set out to create tailored, context-specific tech solutions to empower these groups, bridging the gap between technology and social impact. This vision became the foundation of Dhwani RIS, where we continue to innovate and drive change.
Candid answers by the company
Gurugram
Connect with the team
Similar jobs (1)
Job Description (JD) for the MySQL Database Administrator role
Experience: 4-8 Years
Location : Mumbai
Job Title: MySQL Database Administrator
Responsibilities
- Provision and configure MySQL database instances in clustered and non-clustered environments.
- Ensure database performance, security, availability, and reliability.
- Prepare and maintain database documentation, technical specifications, and operational procedures.
- Perform database upgrades, backups, restoration, recovery, and migrations.
- Monitor database and server resource utilization and perform performance tuning and optimization.
- Manage database users, access privileges, periodic access reviews, audits, and documentation.
- Configure, monitor, and troubleshoot MySQL replication.
- Collaborate with application, infrastructure, development, and other stakeholder teams to resolve database-related issues.
- Provide database and application deployment support, as required.
- Perform database backup and restoration validation, data integrity checks, and post-migration validations.
- Follow database change management, security, and operational best practices.
Skills and Qualifications
- Strong hands-on experience in MySQL database administration.
- Good working knowledge of recent MySQL versions, preferably MySQL 8.x.
- Understanding of MySQL storage engines, including InnoDB and MyISAM.
- Practical experience in configuring, monitoring, and troubleshooting MySQL replication.
- Knowledge of MySQL administration best practices, security, and high availability.
- Proficiency in writing, analyzing, and optimising SQL queries.
- Experience with MySQL features such as the Event Scheduler, audit logging, and performance monitoring.
- Ability to assess database resource requirements based on application workloads and technical specifications.
- Familiarity with other SQL and NoSQL databases, such as PostgreSQL and MongoDB.
- Understanding of MySQL limitations compared with other relational database platforms and the ability to identify suitable workarounds.
- Working knowledge of version control tools such as Git, SVN, or CVS.
- Graduate degree in a relevant discipline and good verbal and written communication skills.
Good to Have
- Basic Linux administration, command-line troubleshooting, and Bash scripting skills.
- Familiarity with application server frameworks such as JBoss, GlassFish, and WildFly.






