Oracle Developer

Description:

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.

Essential criteria

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

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

3. Data Modelling Solid understanding of data modelling concepts and experience designing and implementing relational and dimensional data models.

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

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

6. Communication Excellent communication skills, both verbal and written, with the ability to convey complex technical concepts to non-technical stakeholders.

Desirable criteria

1. Familiarity with Federal Government ICT

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

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