Database Engineer

Summary

Database Engineer at OpenLM in Kolkata who manages production AWS RDS and MongoDB Atlas environments day to day — backups, migrations, disaster recovery, query tuning, indexing, security audits, and incident resolution. Core technologies include AWS RDS, MongoDB Atlas, SQL, Kafka pipelines, and Pentaho ETL.

  • Manage, monitor, and maintain production database environments, with a strong focus on AWS RDS and MongoDB Atlas clusters, ensuring high availability and reliability.

  • Execute database backup and restore procedures, manage migrations, and handle Disaster Recovery operations when necessary.

  • Analyze and optimize database performance through query tuning, implementing efficient indexing strategies, and troubleshooting locking, blocking, and deadlocks.

  • Collaborate closely with development teams to design efficient schemas and data models.

  • Review database changes (DDL/DML scripts) and ensure adherence to best practices in SQL and data architecture.

  • Manage database access, roles, and permissions, ensuring compliance with security best practices and data protection standards.

  • Regularly audit and address security vulnerabilities.

  • Support, maintain, and optimize ETL processes using tools like Pentaho.

  • Ensure reliable data flow and data quality across systems, including integration with Kafka pipelines.

  • Investigate and resolve complex database issues and production incidents with a focus on minimizing downtime.

  • Support client environments and assist with database migrations across different database engines.

Qualifications

1. Kafka
2. Relational databases
3. Document databases


Benefits

    What we offer :

    Competitive salary commensurate with experience.

    Strong results are well rewarded.

    Ongoing professional development training.

    Visible, exciting work with cutting-edge solutions.


    Perks that you will enjoy:

    • Working with some of the global business leaders and tech pioneers.

    • Challenging projects to lead and boost your career growth.

    • Work with global teams and clients.

    • No overtime policy.


About OpenLM

OpenLM is among the most trusted global engineering and specialty software license management vendors (source: Gartner). Founded in 2007, today OpenLM has more than 1000 global customers. Almost 10% of these customers belong to the ‘Fortune 1000’ club, and 400 of them are from the US.

Serving across 15+ industries – Aerospace, Automotive, Engineering Services, Defense, Industrial Manufacturing, Healthcare, Semiconductors, Energy, Power & Utility, Gaming, Government, Telecommunication, Mining, Electronics, Construction, and more, OpenLM boasts an NPS (Net Promoter Score) of 4.6.

  • Founded in Pardesia, Israel, in 2007.

  • Branches in the USA, Moldova, Japan, France, and India.

  • Focusing on all geographies, including North America, Europe, India, Australia, Malaysia, China, Thailand, Singapore, LATAM, and others.

  • GSA Contract holder.


OpenLM India is a subsidiary of OpenLM, Israel. This branch will be focused on enhancing OpenLM’s services and products across Asia and other continents. The R&D center in India will be responsible for bringing innovative products, services, and solutions to the global engineering and specialty software market.



See also

DevOps jobs by country — openings, pay and top skills →

Tailor your CV for this role?

We couldn't check your fit for this role — add a CV to your profile to see it next time.

A new version of freehire is available