Senior Data Reliability Engineer (PostgreSQL + AWS)

Novasoft; Basking Ridge (NJ); On-site; USD 150,000 - 210,000; Full time

Job summary

Novasoft in the United States is seeking a highly experienced Data Reliability Engineer to ensure the performance, availability, and security of PostgreSQL and cloud-based data environments.

The role focuses on ETL/ELT data pipelines, monitoring and tuning PostgreSQL RDS, Debezium and Kafka Connect, and building scalable data platforms with Airflow, Spark, and IaC tooling. On-site in Basking Ridge, NJ five days weekly.

Qualifications

• 13+ years in data engineering or related tech roles.
• Deep PostgreSQL experience, preferably on AWS RDS.
• Strong SQL and data pipeline design skills.
• Experience with cloud data platforms, monitoring, and security.

Responsibilities

• Design, develop, and troubleshoot ETL/ELT pipelines for data lakes/warehouses.
• Monitor PostgreSQL RDS performance, availability, and resources.
• Track metrics with CloudWatch/Prometheus; tune DB performance.
• Troubleshoot Debezium and Kafka Connect for reliable data delivery.
• Manage Airflow DAGs; fix failed tasks and re-run workflows.
• Develop automation scripts in Python or Bash.
• Create IaC with Terraform and Crossplane for data infra.
• Support backups, DR plans, security, and RCA.
• Work on-site in Basking Ridge, NJ.

Skills

PostgreSQL

AWS

ETL/ELT pipelines

SQL

Data reliability

Python

Bash

Terraform

Crossplane

Prometheus

Airflow

Kafka Connect

Debezium

Tools

AWS RDS

Debezium

Kafka Connect

Apache Airflow

Apache Spark

Python

Bash

Terraform

Crossplane

Prometheus

CloudWatch

S3

Job description

Novasoft in the United States is seeking a highly experienced Data Reliability Engineer to ensure the performance, availability, and security of PostgreSQL and cloud-based data environments.

The role focuses on ETL/ELT data pipelines, monitoring and tuning PostgreSQL RDS, Debezium and Kafka Connect, and building scalable data platforms with Airflow, Spark, and IaC tooling. On-site in Basking Ridge, NJ five days weekly.