We are looking for an SQL Developer who can provide technical expertise in database development and SQL programming to support business applications, reporting, and data management needs. Builds efficient and reliable database solutions, maintaining data quality, and contributing to continuous improvement of systems and processes.
Key Accountabilities:
- Design, build and maintain database views and stored procedures in PostgreSQL and Amazon
Redshift.
- Write and optimise complex SQL queries to support data analysis needs.
- Tune the performance of views, stored procedures and queries, including reviewing execution plans and applying database specific optimisation (distribution/sort keys, indexes).
- Collaborate with stakeholders and other internal teams to understand and document development requirements and translate them into technical solutions.
- Support development solutions across both real-time and batch processing environments.
- Perform high-quality unit testing and validate deliverables to ensure data accuracy, quality, and integrity.
- Document views, stored procedures, and associated logic clearly and succinctly for ongoing support and handover.
- Provide advice on development methodologies, coding standards, development tools, operating systems, databases, scripting languages and analytics packages.
- Manage assigned work and deliver to agreed timeframes with minimal supervision.
- Completion of other required tasks as directed by the Manager and / or Leadership Team.
Technical Expertise:
- Advanced SQL capability, including complex joins, CTEs, window functions and subqueries.
- Demonstrated experience developing views and stored procedures.
- Significant experience utilising either Amazon Redshift or PostgreSQL.
- Demonstrated knowledge and understanding of differences between PostgreSQL and Redshift
(e.g. supported syntax and procedural language behaviour).
📌 SQL Developer (Melbourne)
🏢 Hays
📍 Melbourne
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.