Postgre SQL Developer

Overview

Remote
Depends on Experience
Full Time

Skills

PostGre SQL
AWS
SQL
Redshift

Job Details

Job Summary:

We are looking for a skilled PostgreSQL Developer with strong experience in AWS services, Redshift, and SQL development. The ideal candidate will be responsible for database development, optimization, and providing production support for mission-critical systems.

Key Responsibilities

  • Design, develop, and optimize PostgreSQL database objects (tables, views, functions, stored procedures).

  • Build and manage ETL pipelines integrating PostgreSQL, AWS services (Lambda, S3, Glue), and Redshift.

  • Write efficient, high-performance SQL queries for analytics and application development.

  • Monitor production databases, troubleshoot issues, and ensure high availability and performance.

  • Handle production support activities, including incident analysis, root-cause identification, and timely resolution.

  • Work with AWS services to deploy and maintain cloud-based database solutions.

  • Develop data models, schema designs, and implement best practices for database performance.

  • Perform backup, restore, and disaster recovery operations.

  • Collaborate with application developers, DevOps, and analysts to support data-driven projects.

  • Implement security, compliance, and data-governance standards across environments.

Qualifications:

Bachelors Degree

Postgres SQL development and RedShift

AWS experience

Writing complex SQL queries & stored procedures; tuning them

Needs to be aware of current database trends, especially around AI dev tools (SQL coding, performance tuning)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About SYSTEM SOFT TECHNOLOGIES LLC