Role :SQL Developer – AWS / Amazon Redshift / PostgreSQL
Location: Melbourne
Duration: Permanent
Role Description:
We are looking for an experienced SQL Developer with solid 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
Robust hands-on experience in Advanced SQL.
Experience with Amazon Redshift or PostgreSQL.
Expertise in Stored Procedures and Database Views.
Robust 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.