Senior PostgreSQL Data Architect & Engineer (Remote)

System Soft Technologies; Town of Texas (WI); On-site; USD 120,000 - 180,000; Full time

Job summary

System Soft Technologies seeks a Senior Database Developer to design, develop, optimize, and modernize enterprise database solutions centered on PostgreSQL and AWS. You'll work with software, infrastructure, BI teams to deliver reliable data architectures, improve performance, and support data-driven decisions.

Deep PostgreSQL expertise and AWS experience are essential. Responsibilities include automation, IaC with Terraform, data governance, and documentation; strong collaboration across

Qualifications

• Deep PostgreSQL expertise with performance tuning and optimization.
• Extensive AWS experience with Aurora, Redshift, and RDS.
• Experience designing data mesh and data lake architectures.
• Infrastructure as Code with Terraform guidance for database provisioning.
• Proficient with Git and version-controlled database change management.

Responsibilities

• Architect and implement scalable PostgreSQL solutions.
• Lead performance tuning, monitoring, and capacity planning.
• Manage cloud-based database hosts using AWS RDS, Aurora, and Redshift.
• Design data pipelines supporting analytics and operational workloads.
• Collaborate with developers to improve data access patterns and governance.

Skills

PostgreSQL

AWS Aurora

Amazon Redshift

SQL optimization

Terraform

DynamoDB

Git

JIRA/Confluence

Tools

Terraform

Git

JIRA

Confluence

Job description

System Soft Technologies seeks a Senior Database Developer to design, develop, optimize, and modernize enterprise database solutions centered on PostgreSQL and AWS. You'll work with software, infrastructure, BI teams to deliver reliable data architectures, improve performance, and support data-driven decisions.

Deep PostgreSQL expertise and AWS experience are essential. Responsibilities include automation, IaC with Terraform, data governance, and documentation; strong collaboration across