We are seeking an experienced and highly skilled SQL Developer to join a leading retail organization based in Melbourne for an ongoing 6-month contract. This is an excellent opportunity to leverage your expertise in a dynamic environment, contributing to critical data initiatives within a large-scale enterprise.
The Role:
As a SQL Developer, you will be instrumental in designing, developing, and optimizing robust SQL-based solutions. You will work on various aspects of the data lifecycle, from data ingestion to reporting and performance enhancement.
Key Responsibilities:
* Design and Development: Architect and implement efficient and scalable SQL Server solutions, including stored procedures, functions, views, and complex queries.
* Data Engineering: Develop and maintain ETL (Extract, Transform, Load) processes to integrate data from various sources into the data warehouse.
* BI Reporting Support: Collaborate with BI teams to ensure data availability and performance for reporting tools and dashboards.
* Database Performance Tuning: Proactively identify and resolve database performance bottlenecks. Optimize existing SQL code, indexes, and database configurations for improved efficiency and speed.
* PL/SQL Optimization: Specifically focus on optimizing existing PL/SQL code for enhanced performance and resource utilization.
* System Performance Enhancements: Contribute to overall system performance improvements through database-level optimizations and collaboration with broader IT teams.
* Troubleshooting & Support: Provide expert support for SQL-related issues, ensuring data integrity and system availability.
Skills & Experience Required:
* Proven experience as a SQL Developer with a strong understanding of relational database design principles.
* Extensive hands-on experience with Microsoft SQL Server (or similar enterprise-level SQL databases).
* Deep expertise in SQL query optimization, indexing strategies, and database performance tuning techniques.
* Solid experience with ETL processes and tools (e.g., SSIS or similar).
* Demonstrable experience with PL/SQL optimization and understanding of Oracle database concepts (if applicable to their environment).
* Familiarity with data warehousing concepts and BI reporting requirements.
* Strong analytical and problem-solving skills with a keen eye for detail.
* Ability to work independently and collaboratively within a fast-paced team environment.
* Excellent communication skills, both written and verbal.
Desirable (but not essential):
* Experience within the retail sector.
* Familiarity with cloud-based data platforms (e.g., Azure SQL Database, AWS RDS).
To apply online, please click on the appropriate link below. Alternatively, for a confidential discussion, please contact Ethan Anderson on