Senior Databse Engineer - DBA

Onedirect; Bengaluru; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Onedirect, a pioneer in the customer experience domain, is looking for a Database Administrator. The role involves provisioning MySQL instances, ensuring performance and security, and performing database administration tasks.

The ideal candidate should have strong proficiency in MySQL and experience with automation and optimization. Knowledge of NoSQL databases and cloud platforms is a plus.

Qualifications

• Strong proficiency in MySQL database management.
• Decent experience with recent versions of MySQL.
• Understanding of MySQL's underlying storage engines.

Responsibilities

• Provision MySQL instances in clustered and non-clustered configurations.
• Ensure performance, security, and availability of databases.
• Perform database administration tasks.

Skills

MySQL database management

SQL statement optimization

Linux Administration

Tools

Git

AWS

MongoDB

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 performance, security, and availability of databases
• Perform database administration tasks, including automation, performance monitoring and tuning, and query optimization.
• Prepare documentation 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.

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

Job Location