Database Engineer - DBA

Onedirect; Bengaluru; On-site; INR 400,000 - 800,000; Full time

Job summary

Onedirect is a pioneering Enterprise SaaS startup located in Bengaluru, India, seeking a skilled Database Administrator to manage MySQL instances and ensure database performance. The ideal candidate will have strong proficiency in MySQL, as well as experience with Linux Administration.

Join a collaborative environment working on cutting-edge customer experience products. Good to have skills include knowledge of NoSQL databases and cloud platforms like AWS.

Qualifications

• Strong proficiency in MySQL database management.
• Understanding of MySQL's underlying storage engines.
• Decent experience in Linux Administration.

Responsibilities

• Provision MySQL instances in clustered and non-clustered configurations.
• Ensure the performance, security, and availability of databases.
• Handle common database procedures such as upgrade, backup, recovery.

Skills

MySQL database management

Linux Administration

SQL statement optimization

Database automation

Tools

AWS

Python

Cassandra

MongoDB

ElasticSearch

Job description

OneDirect 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, MakeMyTrip and many more.

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

Job Description

• Provision MySQL instances, both in clustered and non-clustered configurations
• Ensure the 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

Qualifications

• 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

Additional Information

Good to have:

• Knowledge on NoSQL
• Knowledge on Cassandra, MongoDB and ElasticSearch
• Knowledge on public cloud platform like AWS/Azure/GCP
• Python/Shell scripting
• Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.
• Proficient understanding of code versioning tools such as Git / Mercurial / SVN