SQL Developer – AWS / Amazon Redshift / PostgreSQL

Role :SQL Developer – AWS / Amazon Redshift / PostgreSQL

Location: Melbourne

Duration: Permanent

Role Description:

We are looking for an experienced SQL Developer with strong expertise in SQL programming, database development, and query optimisation to support business applications, reporting, and data management solutions.

Preferred : SQL Developers with AWS / Amazon Redshift experience and strong database development skills.

Key Responsibilities

• Design, develop, and maintain database views and stored procedures.
• Write and optimise complex SQL queries using joins, CTEs, window functions, and subqueries.
• Perform query performance tuning and execution plan analysis.
• Work with Amazon Redshift and/or PostgreSQL databases.
• Optimise database performance using indexes, distribution keys, and sort keys.
• Support both real-time and batch processing environments.
• Perform data validation and ensure data accuracy and integrity.
• Collaborate with technical and business stakeholders to translate requirements into technical solutions.
• Maintain technical documentation and support code handovers.

Required Skills

• Strong hands-on experience in Advanced SQL.
• Experience with Amazon Redshift or PostgreSQL.
• Expertise in Stored Procedures and Database Views.
• Strong understanding of SQL performance tuning and query optimisation.
• Knowledge of CTEs, Joins, Window Functions, and Subqueries.
• Understanding of differences between PostgreSQL and Amazon Redshift.
• Familiarity with Git, version control, and Agile methodologies.
• Strong communication and problem-solving skills.