Application closing date: Monday, 11 March 2024 • 11:59pm, Canberra time (or once all sellers have responded) (in Canberra)
Estimated start date: Friday, 29 March 2024
Location of work: ACT
Length of contract: 6 months with 3 x 1 month extensions
Contract extensions: 3 x 1 month
Security clearance: Must have Baseline
Rates: $120 - $145 per hour (inc. super)
The Australian Fisheries Management Authority is seeking a highly skilled Oracle Database Developer / Data Engineer with a robust background in designing, implementing, and managing complex database solutions. This professional brings a deep understanding of Oracle database technologies, combined with a proven track record of leveraging Oracle Data Integrator (ODI) and Oracle Business Intelligence Enterprise Edition (OBIEE) to deliver high-quality data integration, ETL processes, and business intelligence insights. With a keen eye for innovation and efficiency, they are adept at deploying cloud-based data solutions across leading platforms such as Oracle Cloud Infrastructure (OCI), and Azure ensuring scalability, security, and cost-effectiveness. Their strong analytical skills, problem solving abilities, and commitment to excellence make them a valuable asset in supporting Solutions Architects to develop and optimize database routines that drive program success. Through effective collaboration and communication, they bridge technical and business domains to deliver data-driven solutions that meet strategic objectives and operational needs.
Primary Responsibilities:
- Database Development and Maintenance: Develop and maintain robust database systems, including schema design, stored procedures, queries, and scripts for data manipulation and retrieval. Ensure high performance, security, and scalability of database systems.
- Data Integration and ETL Processes: Utilize Oracle Data Integrator (ODI) to design and implement ETL (Extract, Transform, Load) processes that integrate data from various sources into a cohesive and efficient architecture. Optimize data flows to improve performance and reliability.
- Business Intelligence and Reporting: Support the development of reporting and analytics solutions using Oracle Business Intelligence Enterprise Edition (OBIEE). Collaborate with stakeholders to understand their data needs and deliver insightful, actionable reports.
- Cloud Data Management: Leverage cloud technologies for data storage, processing, and analytics. Experience with Oracle Cloud Infrastructure (OCI), and Azure is desirable. Implement and maintain cloud-based data solutions, ensuring they are scalable, secure, and cost-effective.
- Collaboration and Support: Work closely with the Solutions Architect and other team members to support the development and implementation of database routines and data strategies. Provide technical expertise and recommendations to improve program outcomes.
- Technical Expertise: Strong proficiency in Oracle database technologies, SQL, PL/SQL, and experience with Oracle Data Integrator (ODI) and Oracle Business Intelligence Enterprise Edition (OBIEE).
- Cloud Technologies: Experience with cloud platforms such as Oracle Cloud Infrastructure (OCI and Azure Platform). Knowledge of cloud-based data warehousing, ETL, and analytics services is highly desirable.
- Data Modelling: Solid understanding of data modelling concepts and experience designing and implementing relational and dimensional data models.
- Analytical Skills: Ability to analyse complex data sets to identify trends, patterns, and insights. Experience with data visualization tools and techniques is a plus.
- Problem-Solving: Strong problem-solving skills and the ability to troubleshoot issues effectively. Must be able to provide efficient and scalable solutions to meet business needs.
- Communication: Excellent communication skills, both verbal and written, with the ability to convey complex technical concepts to non-technical stakeholders.
- Applicants must possess a minimum of 5 years of hands-on experience as an Oracle Database Developer, with a solid track record of developing, optimizing, and managing complex Oracle database systems, including extensive experience with database migrations, performance tuning, and implementing advanced features of Oracle 11g and 19c.
- Oracle certifications and training in Oracle technologies, cloud platforms, and data engineering are highly desirable.
- Cloud Technologies Experience with cloud platforms such as Oracle Cloud Infrastructure (OCI and Azure Platform). Knowledge of cloud-based data warehousing, ETL, and analytics services is highly desirable.
- Data Modelling Solid understanding of data modelling concepts and experience designing and implementing relational and dimensional data models.
- Analytical Skills Ability to analyse complex data sets to identify trends, patterns, and insights. Experience with data visualization tools and techniques is a plus.
- Problem-Solving Strong problem-solving skills and the ability to troubleshoot issues effectively. Must be able to provide efficient and scalable solutions to meet business needs.
- Communication Excellent communication skills, both verbal and written, with the ability to convey complex technical concepts to non-technical stakeholders.
- Oracle Database and Tools Experience • Oracle certifications and training in Oracle technologies, cloud platforms, and data engineering are highly desirable. • Development proficiency in Oracle and Azure databases and related tools, with a preference for experience in cloud-based solutions. Your expertise in Oracle and some knowledge of Azure will be an asset in our data transformation initiatives.
- SAFe and/or Agile Experience/Exposure Familiarity with SAFe (Scaled Agile Framework) or other agile methodologies is a plus. Experience or exposure to agile practices will help streamline program delivery
- Security Clearance (NV1 or Baseline) Possession of an NV1 security clearance is preferable, with a baseline security clearance as a bare minimum