Senior Database Engineer
Posted 17 days ago · 0 applicants
Saving, applying or scoring takes a few seconds to set up your free account.
The role in plain words
This role involves building and maintaining scalable database infrastructure to process data from millions of IoT devices. You will design schemas, write stored procedures, and optimize query performance across Azure SQL and Elasticsearch or OpenSearch systems. Additionally, you will manage database security, monitor performance metrics, and automate operations using Python and PowerShell.
- At least 7 years of hands-on experience in database engineering / development
- Experience with large scale databases that have millions of transactions per day
- Strong T-SQL skills, with proven experience writing and tuning stored procedures
- Solid understanding of indexing strategy and query optimization
- Experience with table partitioning and data retention/archival strategies for large or time-series datasets
- Experience using AI tools (preferably Claude) for data analysis and rapid development of stored procedures
Extracted from the job description · kept up to date automatically
Who this suits
This role suits an experienced database engineer with at least seven years of hands-on experience, strong T-SQL skills, and practical knowledge of Azure SQL and NoSQL search engines. It is less ideal for junior developers or those without experience managing large-scale databases with millions of daily transactions.
Full job description
Original listing · kept for referenceAbout the role
Global supply chains move the world, and most of it is currently invisible. Hoopo is changing that by bringing Fleet Intelligence to the world's largest shipping and transportation operations through a unique combination of hardware, signal processing, and AI.
We're looking for an Experienced Database Engineer to join our growing R&D team. In this role, you will work closely with development and research teams to build scalable, high-performance database infrastructure that ingests and processes data from millions of IoT devices operating across maritime, transportation, and aviation environments. You will work across both relational (Azure SQL) and search-oriented (Elasticsearch/OpenSearch) systems. You will develop our data layer on Azure SQL Database, alongside our search/NoSQL infrastructure.
About Hoopo
Hoopo is a venture-backed startup headquartered in Herzliya, Israel. We digitize unpowered fleets (containers, chassis, trailers, airport ground equipment, and more) - using the world’s most power-efficient tracking devices coupled with signal processing that makes it work in the world's harshest and most challenging environments. On top of that, we are building an AI-powered fleet intelligence platform that turns raw location data into operational insights for some of the largest shipping and logistics companies in the world.
Job requirements
• At least 7 years of hands-on experience in database engineering / development.
• Experience with large scale databases that have millions of transactions per day.
• Strong T-SQL skills, with proven experience writing and tuning stored procedures.
• Solid understanding of indexing strategy and query optimization.
• Experience with table partitioning and data retention/archival strategies for large or time-series datasets.
• Practical experience operating Azure SQL Database and working in the Azure Portal.
• Experience defining backup/restore and data-security policies on Azure SQL (point-in-time restore, access control, encryption).
• Experience monitoring databases and acting on performance and health metrics.
• Hands-on experience with a NoSQL / search engine such as Elasticsearch or OpenSearch.
• Experience building and maintaining CI/CD pipelines for databases (schema versioning, automated deployments).
• Proficiency in Python and PowerShell for automation and scripting.
• Proactive approach - Ability to diagnose and resolve performance problems independently.
What you'll be doing
• Collaborate with developers to design and implement efficient schemas and data-access patterns.
• Design, write, and maintain stored procedures, functions, and views in Azure SQL Database.
• Analyze and optimize query performance, including partitioning, index design, execution-plan analysis, and resolving bottlenecks.
• Implement retention/archival policy according to our customer needs.
• Monitor database health, performance and availability - set up alerting, track key metrics, and respond proactively to issues.
• Manage and monitor Azure SQL resources through the Azure Portal (provisioning, scaling, performance metrics, security configuration).
• Define and implement database backup/restore and security policies.
• Build and maintain database CI/CD pipelines - schema migrations, version control, and automated deployments.
• Build and maintain search and NoSQL data flows using Elasticsearch or OpenSearch.
• Automate database operations and tooling using Python and PowerShell.
Advantage
• Experience using AI tools (preferably Claude) for data analysis and rapid development of stored procedures.
Questions about this role
- This listing did not state a salary. We only show pay when the employer publishes it.
- At least 7 years of hands-on experience in database engineering / development, Experience with large scale databases that have millions of transactions per day, Strong T-SQL skills, with proven experience writing and tuning stored procedures, Solid understanding of indexing strategy and query optimization, Experience with table partitioning and data retention/archival strategies for large or time-series datasets