Data Infrastructure Engineer (contract)

<p class="p1"><strong>Data Infrastructure Engineer (6 month contract)</strong></p> <p class="p2">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.</p> <p class="p2">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.</p> <p class="p3"><strong>On a given day at Lunar, you’ll likely…</strong></p> <ul class="ul1"> <li class="li4">Design, deploy, and maintain Vertica analytics database clusters (physical and virtual), including cluster topology, K-safety, node health, projection design, and query performance tuning.</li> <li class="li4">Administer SQL Server 2016/2019 Enterprise on virtualized Windows infrastructure, including configuring and maintaining Always On Availability Groups for high availability.</li> <li class="li4">Write and maintain PowerShell and Python scripts to automate Windows server deployments, patching, monitoring, alerting, and operational tooling across the infrastructure stack.</li> <li class="li4">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.</li> <li class="li4">Administer and tune PostgreSQL instances on Linux, managing roles, schemas, access controls, backup and recovery, and integrating PostgreSQL within the broader data pipeline.</li> <li class="li4">Manage the hypervisor platform (VMware vSphere/ESXi or equivalent), including VM provisioning, resource tuning, vSwitch configuration, host patching, and live migrations with minimal downtime.</li> <li class="li4">Develop and maintain infrastructure-as-code, runbooks, and monitoring dashboards; lead incident response for infrastructure outages and conduct post-mortems.</li> </ul> <p class="p3"><strong>Desired Skills:</s