About 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.