Data Infrastructure Engineer (contract)

Data Infrastructure Engineer (6 month contract)

Lunar Energy is looking for a Data Infrastructure Engineer to design, deploy, and maintain the hybrid infrastructure stack underpinning our enterprise data platform.

In this role, you will own the full lifecycle of a multi-tier environment spanning columnar analytics databases, relational SQL systems, Windows and Linux application servers, and shared storage — ensuring reliability, performance, and scalability across production and development environments.

You will bring strong hands-on expertise in database administration, scripting, and ETL pipeline development, paired with an operational mindset and a proactive approach to capacity planning and infrastructure-as-code.

Lunar Energy was founded to transition homes to 100% clean energy—making our electricity greener, our air cleaner and our energy more safe, secure and reliable for all.

We’re a fast-growing, global company building the world’s best clean energy products to electrify all homes and connect communities to form clean, resilient virtual power plants.

On a given day at Lunar, you’ll likely…

• Design, deploy, and maintain Vertica analytics database clusters (physical and virtual), including cluster topology, K-safety, node health, projection design, and query performance tuning.
• Administer SQL Server 2016/2019 Enterprise on virtualized Windows infrastructure, including configuring and maintaining Always On Availability Groups for high availability.
• Write and maintain PowerShell and Python scripts to automate Windows server deployments, patching, monitoring, alerting, and operational tooling across the infrastructure stack.
• Build, maintain, and optimize ETL pipelines that move and transform data across Vertica, SQL Server, PostgreSQL, and flat-file sources, with robust error handling and data quality checks.
• Administer and tune PostgreSQL instances on Linux, managing roles, schemas, access controls, backup and recovery, and integrating PostgreSQL within the broader data pipeline.
• Manage the hypervisor platform (VMware vSphere/ESXi or equivalent), including VM provisioning, resource tuning, vSwitch configuration, host patching, and live migrations with minimal downtime.
• Develop and maintain infrastructure-as-code, runbooks, and monitoring dashboards; lead incident response for infrastructure outages and conduct post-mortems.