Database Engineer
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.
- Compensation
- Not disclosed
- Location
- Kolkata, India
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Contract
- Experience
- Not specified
- Category
- Devops
- Posted
Skills
Must have
- Kafka
- Relational databases
- Document databases
Full description
- 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
- Kafka
- Relational databases
- 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.