Senior Databse Engineer - DBA

One Direct is an Enterprise SaaS startup working in the customer experience domain. We have evolved as a pioneer in the CEM space with a suite of world‑class products that have been implemented by revered market leaders. This validation has strengthened our position as front runners in customer experience. We work with over 200 large enterprises like Indigo, McD, Indian Railways, IFB, Voltas, Daikin, Make My Trip  and many more.

One Direct has three key product lines around Service Management, Feedback and Messaging (WA, BOT, etc.)

• Provision MySQL instances, both in clustered and non-clustered configurations
• Ensure performance, security, and availability of databases
• Perform database administration tasks, including automation, performance monitoring and tuning, and query optimization.
• Prepare documentations and specifications
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary
• Collaborate with other team members and stakeholders
• Acts as a Team Lead.

• Strong proficiency in MySQL database management
• Decent experience with recent versions of MySQL
• Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM
• Experience with replication configuration in MySQL (Master‑slave, Master‑Master)
• Create and Manage MySQL users with proper permissions.
• Proficient in writing and optimizing SQL statements.
• Automate day to day regular tasks.
• Strong knowledge in MySQL Binlog and point in time recovery.
• Decent experience in Linux Administration.
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases

Good to have:

• Knowledge on No
  
  SQL
• Knowledge on Cassandra, Mongo
  
  DB and Elastic Search
• Knowledge on public cloud platform like AWS/Azure/GCP
• Python/Shell scripting
• Familiarity with other SQL/No
  
  SQL databases such as Postgre
  
  SQL, Mongo
  
  DB, etc.
• Proficient understanding of code versioning tools such as Git / Mercurial / SVN