Database Engineer - DBA

Company 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