Support Engineer with PostgreSQL DBA/Data Reliability Engineer II

Cloudious • Jersey City, NJ

1d

About The Position

We are seeking a PostgreSQL DBA/Data Reliability Engineer II to ensure the performance, availability, and reliability of PostgreSQL RDS instances and associated data pipelines. The role works closely with development teams to optimize database performance and contribute to the organization’s data strategy.

The position is listed in Jersey City, New Jersey, for a duration of 6+ months. The posting specifies 9+ years of experience required, and also lists 5–8 years of database administration experience focused on PostgreSQL and 2–4 years of hands-on PostgreSQL RDS experience.

Requirements

• Extensive experience with SQL and PostgreSQL architecture, schema and object management, performance tuning, backup, and recovery.
• Basic understanding of AWS Cloud, including AWS IaaS and AWS Redshift.
• Familiarity with data pipeline concepts and technologies such as Debezium, Kafka Connect, and ETL development.
• Strong SQL scripting skills for querying and basic data manipulation.
• Knowledge of database security best practices, including access controls, encryption, and compliance with data privacy laws.
• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5–8 years of database administration experience focused on PostgreSQL.
• 2–4 years of hands-on experience with PostgreSQL RDS.
• The posting also states 9+ years of experience required.

Nice To Haves

• Exposure to Spark for data processing.
• Basic understanding of Airflow for workflow orchestration.
• Familiarity with scripting languages such as Python or Bash.
• AWS Certified Database - Specialty certification.

Responsibilities

• Proactively monitor PostgreSQL RDS performance, availability, and resource utilization using monitoring tools such as CloudWatch, Prometheus, Grafana, and Kibana.
• Identify PostgreSQL RDS performance bottlenecks and apply basic tuning techniques, including reviewing query execution plans, adding missing indexes, and recommending parameter adjustments.
• Monitor Debezium and Kafka Connect connector health and performance, and troubleshoot basic data capture and delivery issues.
• Oversee Apache Airflow DAG execution, identify failed tasks, and manage troubleshooting and reruns.
• Develop and maintain automation scripts and infrastructure-as-code templates, such as Crossplane or Terraform, to automate routine database tasks, deployments, and updates.
• Participate in on-call rotations, respond to database incidents, troubleshoot issues, and perform root cause analysis.
• Implement and maintain cloud database security practices, including access controls, encryption, and regulatory compliance; regularly audit database security configurations.
• Configure and manage database backup and recovery strategies to protect data integrity and availability.
• Analyze database query performance and collaborate with developers to optimize SQL queries and schemas.
• Participate in continuous improvement initiatives to enhance cloud database reliability, scalability, and performance.
• Assist with designing and optimizing database schemas for cloud environments.
• Monitor ETL workflows and data pipelines for errors, performance bottlenecks, and processing delays; troubleshoot and resolve issues to support reliable and timely data movement.
• Support data-related issues and participate in root cause analysis.

What This Job Offers

• Career Level: Mid Level