DBA Engineer (Remote) #243

Kaleyra; Bengaluru; Hybrid; INR 800,000 - 1,200,000; Full time

Job summary

A global communications platform is looking for a DBA Engineer in Bangalore. You will manage and optimize MySQL and MongoDB databases, ensuring data integrity and performance. The ideal candidate has 2 to 4 years of experience in database management, strong knowledge of cloud environments, and is flexible to work in shifts. This full-time position offers remote work flexibility during the COVID-19 crisis.

Qualifications

• 2 to 4 years of experience managing MySQL/Maria services.
• 1 to 2 years of experience with MongoDB.
• Expertise in installation, configuration, and patch management.

Responsibilities

• Install and configure databases.
• Write SQL queries and maintain existing programs.
• Optimize and perform tuning of database systems.
• Monitor database performance and implement changes.
• Perform regular database maintenance and backups.

Skills

MySQL/Maria management

MongoDB

Cloud providers (AWS, GCP)

Database installation and configuration

Linux (CentOS, Redhat, Ubuntu)

Job description

Overview

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 Engineer. This position is full time and will be based in our Bangalore office (during COVID-19 crisis, the position will be remote-based).

Responsibilities

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.

Qualifications

• Over all 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

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.

Recruitment Privacy Notice

If you have submitted your profile to Kaleyra, be informed that we have processed your personal data in accordance with our internal hiring policies. Kaleyra understands the importance of protecting your personal data. Since, we are a GDPR complied company, we would want to invite your attention to our Privacy Policy and Recruitment Statement which is effective.

Kaleyra is committed in protecting your personal information and it will be used appropriately for evaluation of the candidature. The information collected will be used to serve hiring purpose as a part of Kaleyra’s recruitment process, including processing of the data by authorised third parties, as and when required. Your information will be held with Kaleyra only as long as necessary and for the purpose of hiring and will be available in the database for a period of one (1) year irrespective of the selection or rejection.

By proceeding and providing information asked herein, you agree that you have read Kaleyra’s privacy policy and fully understand your rights to access, correct, erase, object to processing, restrict to processing or withdraw your personal information anytime and seek a copy of the personal information.