Назад
Company hidden
2 часа назад

SQL Developer (PostgreSQL/Redshift)

Формат работы
hybrid
Тип работы
project
Грейд
senior
Английский
b2
Страна
Australia
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
SQL Developer (PostgreSQL/Redshift): Developing, optimizing, and maintaining database views, stored procedures, and complex queries for a government agency with an accent on PostgreSQL, Amazon Redshift, and data quality. Focus on query performance tuning, execution plans, indexing, data validation, and delivering reliable reporting solutions.

Location: Melbourne CBD, Australia; hybrid working arrangement

Company

Work with a large government organisation on database solutions supporting data analysis and reporting.

What you will do

  • Design, develop, and maintain database views and stored procedures using PostgreSQL and Amazon Redshift.
  • Write, optimize, and troubleshoot complex SQL queries for data analysis and reporting.
  • Perform database performance tuning using query execution plans, indexing, and optimization techniques.
  • Collaborate with technical teams and business stakeholders to gather requirements and deliver database solutions.
  • Conduct unit testing, data validation, and technical documentation to maintain data accuracy, integrity, and quality.

Requirements

  • Advanced SQL development experience, including complex joins, CTEs, window functions, and subqueries.
  • Strong hands-on experience with PostgreSQL and/or Amazon Redshift.
  • Experience developing and optimizing database views, stored procedures, and complex queries.
  • Understanding of database performance tuning, query optimization, and differences between PostgreSQL and Redshift.
  • Strong analytical, problem-solving, and communication skills.

Culture & Benefits

  • Contract through the end of September 2027.
  • Hybrid work arrangement based in Melbourne CBD.
  • Work with a government agency.

Hiring process

  • Apply for an interview or contact Donal McCann for a confidential discussion.

Будьте осторожны

Если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →