Intermediate Database Engineer
Job Description
We are seeking an experienced and motivated Intermediate SQL Server Database Engineer to join our data team. The successful candidate will have 3–4 years of professional experience in database engineering, administration, and performance optimization across large, high-transactional environments. You will be responsible for ensuring the stability, scalability, and efficiency of our SQL Server and Azure SQL databases, supporting ETL workflows, and contributing to data integrity and quality assurance.
This role requires strong technical proficiency in T-SQL, Azure SQL, and database performance tuning, complemented by a proactive mindset toward automation, cloud technologies, and continuous improvement. Familiarity with tools and platforms such as Power BI, Snowflake, PostgreSQL, MongoDB, and PowerShell scripting would be advantageous but is not mandatory.
Key Responsibilities:
- Design, develop, and maintain SQL Server databases, stored procedures, and functions.
- Optimize and tune queries, indexes, and database structures for performance and scalability.
- Manage and administer Azure SQL databases including provisioning, scaling, monitoring, and security.
- Configure and maintain SQL Server environments (on-prem and cloud).
- Develop and manage ETL workflows for data ingestion, transformation, and integration (e.g., SSIS, Azure Data Factory).
- Support data validation, testing, and QA activities to ensure data consistency and integrity.
- Collaborate with developers, analysts, and infrastructure teams to support data-driven initiatives.
- Perform database backups, restores, and disaster recovery planning.
- Monitor database health and troubleshoot performance or availability issues.
- Contribute to automation and DevOps initiatives related to database deployments and CI/CD pipelines.
- Assist in data analysis, reporting, and dashboard development.
About you
You align with our values: #WeDoWhatsRight, #WeGetItDone, #WeLearnAndGrow, #WePlayAsATeam AND have experience with:
- Bachelor’s degree in Computer Science, Information Technology, or related field.
- 3–4 years of hands-on experience in SQL Server database development and administration.
- Strong proficiency in T-SQL and performance tuning for large, high-volume systems.
- Experience managing and optimizing Azure SQL or other cloud-based databases.
- Solid understanding of SQL Server configuration, indexing strategies, backups, and security.
- Experience with ETL tools (e.g., SSIS, Azure Data Factory, Airflow or similar).
- Familiarity with testing and QA practices for database changes.
- Exposure to data visualization tools (Power BI preferred).
- Basic scripting experience with PowerShell, Python, or similar automation tools.
- Understanding of data modeling, normalization, and database design principles.
- Familiarity with CI/CD pipelines, version control systems (Git), and DevOps practices (nice to have).
- Knowledge of monitoring and alerting tools such as Azure Monitor, Datadog, or Redgate suite.
- Awareness of data governance, security compliance, and privacy best practices.
- Nice to have exposure to Snowflake, PostgreSQL, MongoDB or other NoSQL database technologies.
Why EROAD:
EROAD is a true Kiwi success story in the tech sector! Publicly listed, we are represented on the NZX and ASX, and recently completed the largest Tech merger in New Zealand's history. We continue to grow rapidly, with over 450 EROADers based in NZ, Australia and the USA.
Our purpose is simple – to create safer and more sustainable roads. Our sophisticated software and in-vehicle technology ensures that fleet vehicles operate safely, minimise environmental impact.
Join us in an environment where innovation meets teamwork, and challenges are embraced as opportunities for growth.
Benefits:
This is an outstanding opportunity to take on a critical role in a fast-growing high-tech company with international reach. EROAD offers a competitive salary and benefits, excellent career development opportunities through a structured framework, and a fun, fast-paced work environment.
EROAD is genuinely committed to investing in its people, and this is demonstrated through comprehensive leadership development programs, fully paid medical insurance, 8 weeks paid parental leave, peer-to-peer recognition frameworks and regular check-ins on culture, ways of working and Employee Experience.
As a Kiwi-led, global organisation, we ensure that we stay well connected with our international team-mates through frequent company-wide communication, learning opportunities and cultural sharing.
If you are ready to make a significant impact and advance your career in database engineering, apply now and be a part of our exciting journey!
Top Skills
What We Do
EROAD develops technology solutions (products and services) that manage vehicle fleets, support regulatory compliance, improve driver safety and reduce the costs associated with driving.
EROAD believes that every community deserves safer roads and the people who use the roads should influence the design, management and funding of transport networks.
