4 days ago Be among the first 25 applicants
Direct message the job poster from Skillfield
Skillfield is a specialist technology consultancy operating at the intersection of cyber, data and AI. We partner with enterprise clients to protect, transform and empower their organisations with forward‑thinking solutions. Our reputation is built on outcomes, not effort.
Contract: 9 months, with potential for extension
Location: Hybrid (Melbourne-based)
What You'll Do
* Design, implement, and optimise database structures, tables, views, and materialised views in PostgreSQL.
* Analyse, tune, and refactor complex SQL queries for performance and maintainability.
* Create efficient CTEs (including recursive CTEs) and PL/pgSQL functions, especially for recursive and hierarchical data structures (e.g. organisational hierarchies).
* Review and enhance existing schemas and data models to align with best practices for scalability and performance.
* Collaborate with existing Developers and DBAs to implement indexing, partitioning, caching, and query execution improvements.
* Support and mentor the current database team, promoting modern, consistent, and maintainable design and development practices.
* Contribute to PostgreSQL deployment, configuration, and performance monitoring as needed.
* Troubleshoot database issues and identify root causes related to performance, design, or data integrity.
Core Technical Skills
* Strong SQL and PL/pgSQL development experience.
* Deep understanding of PostgreSQL internals — storage, query planning, execution, and indexing strategies.
* Practical experience with recursive queries and hierarchical data models.
* Solid grounding in database design and normalisation, with an eye for practical performance optimisation.
* A solid working knowledge of PostgreSQL installation, configuration, and maintenance.
* Familiarity with query profiling and tuning tools (e.g. EXPLAIN, ANALYZE, pg_stat_statements).
* Experience with schema refactoring, indexing strategy, and data access performance improvements.
* Ability to work independently, identify opportunities for optimisation, and communicate improvements clearly to peers.
What You'll Bring
* A passion for mentoring and uplifting team capability
* Comfort working in collaborative environments with minimal supervision
* Curiosity and a proactive approach to learning new technologies and practices
* Desire to build high‑performing, maintainable, and elegant database solutions
Why Join Skillfield?
* Be part of a team serious about doing work that matters
* Join a culture that values clarity, autonomy and shared success
* Enjoy flexibility, support, and performance‑based recognition
Ready to make a measurable impact?
Apply now and help us deliver impact that matters.
Seniority level
Mid‑Senior level
Employment type
Contract
Job function
Consulting and Information Technology
Industries
IT Services and IT Consulting
We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr