Data Infrastructure Engineer (contract)
About The Position
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.
Requirements
- 5+ years of experience in database or systems infrastructure engineering, with hands-on expertise in Vertica, 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 RHEL/CentOS 7.x and Windows Server 2016 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 communication.
Responsibilities
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
