Database Administrator - Mysql / Maria & Mongo #232 (Remote)

Kaleyra; Bengaluru; Remote; INR 600,000 - 1,000,000; Full time

Job summary

A leading CPaaS provider in Bengaluru is seeking a DBA for MySQL/Maria and MongoDB management. The role involves installation, performance optimization, troubleshooting, and data management. Candidates should have 2-4 years of experience and familiarity with cloud environments like AWS/GCP. Join a dynamic team focused on delivering innovative communication solutions.

Qualifications

• 2 to 4 years of experience managing MySQL/Maria services.
• 1 to 2 years of experience with MongoDB.
• Experience in cloud environments is a plus.

Responsibilities

• Install and configure databases.
• Optimize database performance and tuning.
• Troubleshoot and resolve database issues.

Skills

MySQL/MariaDB

MongoDB

Cloud Services (AWS, GCP)

Database Optimization

Linux Systems

Job description

We are Kaleyra! A global CPaaS listed at the New York Stock Exchange.

We power communications via cloud and APIs (through messaging, voice, and chatbots) for the largest companies in the world, including the social networks you use every day, the largest automotive producers, top banks and credit card issuers, various airlines and travel companies, and the most widely-used e-commerces and retailers out there.

We have customers in all continents (except Antarctica!) and our vision is to be the world’s most Trusted, Secure and Innovative communication platform to enable real-time conversations between brands and their users.

We are a diverse team of 330+ individuals from different parts of the world working hard (playing hard) and caring for each other. Our fast growing team is spread across 12 locations around the globe, including Italy, India, Germany, United Arab Emirates, the United States, and Singapore.

We’re now looking for someone that is ready for new exciting challenges and willing to enter our family as “DBA- MySQL / Maria & Mongo”. This position is full time and will be based in our Bangalore office (during COVID-19 crisis, the position will be remote-based).

Here’s what you will do:

• Installation and configuration of databases
• Write new database programs, such as SQL queries, and maintain existing programs to ensure data traffic is enhanced and be able to manage the data stored in the application / backend / server.
• Optimizing and perf tuning of database systems.
• Debugging/refining automation scripts to debug existing database scripts.
• Automation of redundant/regular needs and process.
• New database design based on company requirement / customer requirement.
• Schema changes in the data tables.
• Monitoring the database's performance, implementing changes, and applying new patches / versions as required.
• Data replication across different resources to ensure data redundancy.
• Troubleshoot database code, check for potential problems that affect database functionality and related database programs.
• Review the log files for root cause analysis.
• Regular periodic database maintenance.
• Manage, monitor performance, capacity and security of database systems.
• Test database systems and perform bug fixes.
• Security hardening for databases.
• Perform data back-up and archival on a regular basis.
• Data extraction, transformation and loading on a regular basis.
• Resolve technical issues / queries related to performance, capacity, data storage, data access.
• User access management.
• Support within the teams on call.
• Minimising the risks by knowing potential weaknesses of the database software.
• Retrieval of data on need basis.
• Reports generation.

Expected skill-set and competencies

• Overall 2 to 4 years of production experience in managing Mysql/Maria services under any of the public/private cloud.
• 1 to 2 years of production experience with MongoDB is required.
• Having basic expertise with cloud providers like AWS, GCP is an added advantage for Mongo/Mysql/Maria.
• Should have created, maintained and managed multiple databases.
• Is capable of monitoring, maintaining database services and troubleshooting production issues.
• Should have an expertise with Installation, configuration and upgradation and patch management for MySQL / Maria, Mongo.
• Should have expertise in maintaining data integrity and security
• Proficiency with Replication / Cluster for HA set-up.
• Proven experience with back-up and restoration of databases.
• Strong knowledge or prove expertise on archiving and shrinking databases data.
• Added advantage for automations using any one scripting language (Bash, Perl, Python etc..,).
• Should have a good working knowledge of linux (Centos, Redhat, Ubuntu, Amazon Linux etc..,).
• Flexible to work on rotational shifts & handling of on-call on rotation basis

Equal Employment Opportunity Statement:

Kaleyra is committed to create a diverse and inclusive workplace and is proud to be an equal opportunity employer. All qualified candidates will be considered without any regard to their race, colour, religion, gender, gender identity or expression, sexual orientation, nationality disability, or age.