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.

• 5+ years of experience in database or systems infrastructure engineering, with hands-on expertise in Nutanix, SQL Server, and PostgreSQL administration.

• Proficiency in PowerShell scripting for Windows automation and Python scripting for infrastructure automation, data processing, and ETL pipeline development.

• Experience designing and maintaining ETL pipelines across heterogeneous database and file-based sources, including error handling, retry logic, and scheduling.

• Strong working knowledge of Linux system administration (RHEL/AlmaLinux/Rocky Linux 9.x or Ubuntu 22.04/24.04 LTS) and Windows Server 2019 system administration, including storage layout, networking, OS hardening, and lifecycle management.

• Hypervisor administration experience with VMware vSphere/ESXi or equivalent — VM provisioning, resource management, live migration, and host maintenance.

• Solid understanding of storage concepts including local disk layouts, NAS/SAN, and IOPS planning.

• Collaborative and communicative approach — comfortable working across data science, analytics, and engineering teams with clear written and verbal