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.
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.
Skills Required
- Kafka
- Relational databases (SQL)
- Document databases (MongoDB/MongoDB Atlas)
- AWS RDS
- Pentaho (ETL tools)
- Database backup, restore, migration and disaster recovery experience
- Query tuning, indexing strategies, troubleshooting locking/blocking/deadlocks
- Database security, access control, roles and permissions management
What We Do
OpenLM is a Gartner-recognized global leading provider of software license management solutions for engineering applications, and specialty software (Source: SAM Market Guide 2021). Available both on-premise and on the cloud. Established in 2007 with coverage of 15+ industries, the company is trusted by 1500+ brands globally (400 from the USA, 10% from Fortune1000) with an NPS of 4.6/5, Value for Money: 4.46/5, Ease of use: 4.2/5 and more. Key reasons customers choose us: - IT Asset Cost Reduction - Rich, deep analytics with prebuilt 14+ Power BI enabled reports to enable you to take the right decisions - IT compliance & Security (Source: OpenLM Customer Satisfaction Survey, 2022) and more Who should use OpenLM? - OpenLM’s innovative solutions enable IT Directors, Project Managers, Head of Engineering, Head of SaaS, System Administrators, License Managers, and Software Asset Managers to easily monitor the actual usage and effectively optimize the organization’s engineering software licenses, web-based/saas applications like Salesforce, Workday, Slack, GotoMeeting, Zoom, Gmail, Google, Facebook and more. Why us? OpenLM - supports FLEXlm, DSLS, Bentley, Siemens, Nvidia, Creo, MatLabs, SOLIDWORKS, Cadence, Ansys, Reprise, Altair, Sentinel, and other 60+ license managers, - and monitors/automates and manages 25,000+ CAD, GIS, CAM, PLM, electronics, automotive applications, etc - supports any OS (Unix, Windows, Linux, Mac) - supports any license types - single user/node based, named user, floating/network based licenses, cloud-based, dongle based, etc. - supports any databases from RDBMS - MSSQL, PostgreSQL to component-based databases: MariaDB, MongoDB - provides excellent customer support with ratings of 4.6 out of 5 - is GDPR and BDSG compliant - is AWS secured robust platform - is GSA approved - is recognized by Capterra, SoftwareAdvice, TrustPilot, CUSPERA, G2, GartnerPeerInsights For more information, please visit www.openlm.com.
