Qualifications
- Proven expertise in MySQL database management with a strong focus on recent versions of MySQL.- In-depth understanding of MySQL's storage engines, including InnoDB and MyISAM.- Experience configuring replication in MySQL (Master-slave and Master-Master setups).- Ability to create and manage MySQL users with appropriate permissions.- Proficient in writing and optimizing SQL statements for performance.- Experience automating routine tasks.- Strong knowledge of MySQL Binlog and point-in-time recovery processes.- Familiarity with Linux administration is essential.- Understanding of limitations within MySQL and potential workarounds compared to other popular relational databases.
About the job
As a MySQL Database Engineer at OneDirect, you will be instrumental in provisioning and managing MySQL instances in both clustered and non-clustered configurations. Your responsibilities will include ensuring the performance, security, and availability of our databases. You will be tasked with performing essential database administration duties, including automation, performance monitoring, tuning, and query optimization. Your role will also involve preparing comprehensive documentation and specifications, handling common database procedures like upgrades, backups, recovery, and migration. Additionally, you will profile server resource usage, optimizing and tweaking as necessary, while collaborating with team members and stakeholders to achieve our goals.
About OneDirect
OneDirect is a leading Enterprise SaaS startup revolutionizing the customer experience landscape. We have established ourselves as pioneers in the Customer Experience Management (CEM) space, offering a suite of industry-leading products utilized by prestigious market leaders. Our partnerships with over 200 large enterprises, including Indigo, McDonald's, Indian Railways, IFB, Voltas, Daikin, and MakeMyTrip, have solidified our position as frontrunners in enhancing customer experiences. Our key product lines focus on Service Management, Feedback, and Messaging solutions (including WhatsApp, Bots, etc.).