Database Engineer
OpenLM 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
2. Relational databases
3. Document databases
Benefits
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.
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:
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.