Vertica Dba Jobs (NOW HIRING)

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.

Desired Skills:

• 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 communication.

Our DE&I Philosophy: Lunar Energy is an equal opportunity employer. We are committed to attracting, developing and retaining diverse talent by supporting an inclusive workplace. Lunar recruits, hires, trains, promotes, compensates, and administers all personnel actions without regard to race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status or any other status protected by applicable law.

Our Compensation Philosophy: Our goal is to ensure that all Lunar Energy employees are fairly compensated. Please note that the hourly range information that follows is a good faith estimate for this position provided pursuant to the Pay Transparency for Pay Equity Act for California applicants. The hourly range estimate for this position depending on level of experience is $63.00-$68.00 USD

The actual offer, reflecting the total compensation package & benefits, will be at the company's sole discretion, and determined by factors including but not limited to years of experience, job level, geographic location, and other relevant business considerations. The company also reserves the right to amend or modify this job description, employee perks, and benefits at any time.