Database Analyst (SQL Server, ElasticSearch, SQL queries, stored procedures

at  HEIMDAL SECURITY

We are Heimdal® and cybersecurity is our passion. Join us in an internationally expanding business, leading the fight against cybercrime!
We have been praised by the FBI and are winners of multiple awards, most recently the “Best AI & Machine Learning Security Solution of the Year” at the 2023 Computing Security Awards and “Cloud Based Solution of the Year” at the 2023 Network Computing Awards. We’ve also awarded the “Risk Management Award” at the Security Excellence Awards and 7 (!) awards in the G2 Fall report, such as “Best Support for Mid-Market”, “High Performer in the EDR, Endpoint Management, and Antivirus categories” and “Highest User Adoption in the EDR category”.
When joining Heimdal®, you will embark on a thrilling ride in Europe’s fastest growing bootstrapped cybersecurity business, where we believe that the team is the cornerstone of what we do tomorrow. We are leading the fight against cybercrime, developing new technologies and providing intelligence to protect over 15,000 companies worldwide against cybercriminal attacks and data security breaches.
We are seeking an experienced and motivated Database Analyst to manage and optimize our database systems. You will have hands-on experience with Microsoft SQL Server, including complex query optimization and reporting, as well as proficiency with Elasticsearch clusters. Knowledge of OLAP databases would be a strong plus, as we aim to extend our reporting capabilities.
We are looking into all cities in Romania, therefore if you are in Bucharest, you can work from home and come to the office when and if it is necessary or if you’d like to come. If you are based in any other city in Romania, you can work remote, from home - we have the online resources to guide you through the pre-boarding & onboarding processes and beyond.

QUALIFICATIONS:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Database Analyst, Database Administrator, or similar role.
• Expertise in Microsoft SQL Server administration, query optimization, and reporting services.
• Hands-on experience managing Elasticsearch clusters and familiarity with Elasticsearch query DSL.
• Familiarity with OLAP databases (e.g. Microsoft Analysis Services, Apache Kylin) is a strong advantage.
• Solid understanding of ETL processes and experience with reporting tools (e.g. Power BI, SSRS).
• Strong analytical and problem-solving skills with an attention to detail.
• Excellent communication and teamwork abilities.

• Database Management: Maintain, monitor, and optimize Microsoft SQL Server databases to ensure maximum performance, security, and availability.
• Query Optimization: Review and re-write existing SQL queries to improve performance and reduce resource consumption.
• Reporting: Design and maintain database-driven reports, dashboards, and ad-hoc queries to support internal and external stakeholders.
• Elasticsearch Management: Manage, monitor, and optimize Elasticsearch clusters for search functionality, scalability, and performance.
• OLAP Systems (Optional but Preferred): Implement and maintain OLAP databases to support advanced data analysis and reporting.
• Backup & Recovery: Ensure data integrity, implement backup and recovery strategies, and conduct periodic database maintenance tasks.
• Collaboration: Work closely with development teams to support data-related needs, including designing database structures for new applications.
• Documentation: Create and maintain detailed documentation for database environments, processes, and reporting standards.