Database Analyst (SQL Server, ElasticSearch, SQL queries, stored procedures, performance tuning & optimization)

Database Analyst (SQL Server, ElasticSearch, SQL queries, stored procedures, performance tuning & optimization)

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.

Responsibilities:

• 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.

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.

Nice to Have:

• Experience with data warehousing concepts and best practices.
• Knowledge of cloud database platforms (e.g., Azure SQL Database, AWS RDS).
• Experience with scripting languages like PowerShell or Bash for automation.

Benefits:

• Private medical insurance (Regina Maria);
• Monthly budget in an online benefit platform (Benefit is our partner);
• Bookster and LinkedIn Learning subscriptions;
• Referral bonus;
• Additional company-paid days off ("Personal Day" and "Anniversary Days");
• Personal and professional development (trainings and certifications);
• An amazing journey in an internationally growing company;
• A competitive, dynamic, and awesome team;
• A fun, flexible, and relaxed work environment.

Our Mission
We are leading the fight against cybercrime and protecting the operational integrity of all midmarket and lower enterprise companies.

Our Culture
We believe in hiring the best and the brightest while cultivating a culture of collaboration and execution. We are Dedicated, Innovative, and Humble. As in devoted and passionate about our work and what we do. We seek to optimize, improve every day, and challenge status quo. We are open-minded to new ideas and to feedback, and we know success comes from hard work.

We are committed to constantly create an environment where each individual has the opportunity to grow, personally and professionally. We have a strong sense of unity and togetherness and know we are stronger together, and having fun together is a key element at Heimdal.

See what Peter, our Sales Enablement Partner, has to say about Heimdal here:

https://youtu.be/09VMldwc9PQ?si=81YnH7gt1dOnWU8G

We are an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment decisions are based on business needs, job requirements and individual qualifications, without regard to gender, race, color, disability, religion, marital status, family or parental status.