Senior PostgreSQL Developer - AWS Data Architect

System Soft Technologies; Town of Florida (NY); On-site; USD 140,000 - 190,000; Full time

Job summary

System Soft Technologies is seeking a Senior PostgreSQL Developer to design, implement, and optimize enterprise PostgreSQL-based data solutions. You will work on analytics, operational systems, and modern data architectures in a high-performance AWS environment.

The role emphasizes deep SQL/PLpgSQL expertise, data pipelines, and IaC with Terraform, with seniority and leadership in database modernization efforts.

Qualifications

• 10+ years of PostgreSQL development experience required.
• Advanced SQL/PLpgSQL, query tuning and optimization expertise.
• Experience with Aurora PostgreSQL and Redshift is preferred.

Responsibilities

• Design, develop, optimize, and modernize enterprise PostgreSQL solutions for analytics and operational systems.
• Lead PostgreSQL, Aurora, and Redshift upgrades and modernization efforts.
• Build and maintain data pipelines and cloud-native architectures with IaC using Terraform.

Skills

PostgreSQL development

SQL

Query tuning

Database optimization

Data pipelines

Terraform

Aurora PostgreSQL

Redshift

Education

Bachelor's or Master's in CS/SE

Tools

Terraform

Git

Java/JDBC

Node.js

Job description

System Soft Technologies is seeking a Senior PostgreSQL Developer to design, implement, and optimize enterprise PostgreSQL-based data solutions. You will work on analytics, operational systems, and modern data architectures in a high-performance AWS environment.

The role emphasizes deep SQL/PLpgSQL expertise, data pipelines, and IaC with Terraform, with seniority and leadership in database modernization efforts.