Production Support Engineer - SQL

About Energy Exemplar

In an era where the world is rapidly advancing towards a cleaner future through decarbonization, Energy Exemplar’s mission lies in ‘Empowering Transformative Energy Decisions’. Founded in 1999 in Adelaide, Australia, our award-winning software portfolio encompassing the modeling and simulation platform PLEXOS®, Aurora, and Adapt2, is trusted by innovative organizations across the globe. Through our technology and people, we strive to enable stakeholders from across the entire energy value chain to revolutionize the energy ecosystem and to collaboratively plan and execute for a sustainable energy future with unprecedented clarity, speed, and innovation. 

Our impact is global and is being recognized across the industry. Some of our recent accolades include:

• SaaS Company of the Year (2025) – Global Business Tech Awards.
• Environmental Impact Award (2025) – E+E Leaders Awards.
• IPPAI (Independent Power Producers Association of India) Power Awards (2025) - Winners
• Finalist: Platts Global Energy Awards (2024) – Grid Edge category
• Finalist: Reuters Global Energy Transition Awards (2024) – Technologies of Change
• Top 50 Marketing Team (2024) – Voted by the public at the ICON Awards.

How We Work

Energy Exemplar is growing fast around 30% year on year and, that growth is driven by how we work. We trust our team to deliver great results from wherever they work best, whether that’s at home, in the office, or on the move.

We’re a global team that values ownership, integrity, and innovation. You’ll be supported to balance work and life in a way that works for you, and empowered to take initiative, solve problems, and make an impact, regardless of your background, location, or role.

Our four core values, Customer Success, One Global Team, Integrity & Ownership, and Innovation Excellence aren’t just words. They show up in how we collaborate, how we solve, and how we grow together.

About the Position

This role provides frontline support for consultants and customers using the Adapt2 ISO product, managing tier 3 triage for shadow settlements and database-dependent processes. Responsibilities include troubleshooting complex stored procedures and SQL processes, analyzing system functionality, and resolving intricate energy market challenges. As a trusted advisor, this role fosters client relationships while collaborating with internal teams to deliver optimal solutions. Strong communication skills are essential to articulate technical concepts to diverse audiences, ensuring seamless service delivery and customer success.

• Provide software product's frontline technical support to customers and consultants using the Adapt2 ISO product, resolving tier 3 issues.
• Build and maintain strong client relationships, acting as a trusted advisor to help optimize their use of the enterprise solution.
• Collaborate with internal teams, including Software Development, Implementation/Delivery, and Product Management, to address customer needs and provide the best solutions.
• Analyze data and system performance in Azure SQL to identify recurring issues, recommend improvements, and contribute to long-term resolutions.
• Troubleshoot and optimize complex SQL stored procedures for different processes such as shadow settlements, allocations and transmission profit and loss.

About the Position

This role provides frontline support for consultants and customers using the Adapt2 ISO product, managing tier 3 triage for shadow settlements and database-dependent processes. Responsibilities include troubleshooting complex stored procedures and SQL processes, analyzing system functionality, and resolving intricate energy market challenges. As a trusted advisor, this role fosters client relationships while collaborating with internal teams to deliver optimal solutions. Strong communication skills are essential to articulate technical concepts to diverse audiences, ensuring seamless service delivery and customer success.

• Provide software product's frontline technical support to customers and consultants using the Adapt2 ISO product, resolving tier 3 issues
• Build and maintain strong client relationships, acting as a trusted advisor to help optimize their use of the enterprise solution
• Collaborate with internal teams, including Software Development, Implementation/Delivery, and Product Management, to address customer needs and provide the best solutions
• Analyze data and system performance in Azure SQL to identify recurring issues, recommend improvements, and contribute to long-term resolutions
• Troubleshoot and optimize complex SQL stored procedures for different processes such as shadow settlements, allocations and transmission profit and loss

Candidate Requirements & Qualifications

• Microsoft SQL Professionals: Advanced Knowledge of SQL - 4+ years of expertise in Transact-SOL (T-SQL) and PL/SQL for efficient database management, complex query writing, debugging, and data analysis for technical customer support
• Technical Adaptability: Demonstrated experience in Python for data transformation, automation and analysis
• API & Testing: Experience in unit testing and testing RESTful APls, SOAP APls, integration using POSTMAN, Microsoft Flow, Swagger and other web services
• Good to have: MS Power Bl, Azure Cloud, Azure DevOps, Cl/CD pipeline for deploying microservices to Azure Kubernetes Service (AKS)
• Communication skills: Ability to follow written and oral instructions, create standardized documents, and communicate technical concepts to non-technical audiences
• Computer Science or Engineering background preferred

Desired but not required

• Power Settlements Knowledge: Experience or understanding of power market settlements, transaction processing, and related financial systems
• Experience with C# for code debugging, data transformation, automation and analysis
• Microsoft Azure Ecosystem knowledge: Understanding of Azure cloud services, infrastructure, and how they integrate into enterprise software solutions
• Energy Power Market Knowledge: Familiarity with the dynamics and regulations of energy markets, particularly in the context of ISO and RTO operations

#LI-RK1

Energy Exemplar is proud to be an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all team members. We welcome applications from people of all backgrounds, experiences, identities, and abilities. Please let us know if you require accommodations at any stage of the recruitment process—we're here to support you in showcasing your full potential.

Energy Exemplar respects your privacy and is committed to protecting the personal data you share during the recruitment process. This Candidate Privacy Notice explains how we collect, use, and protect your personal information when you apply for a role with us.