We are now looking for a new Customer Portal Database Developer in Zagreb, Croatia!
As an Customer Portal Database Developer you will utilize your expertise in PL/SQL, Oracle EBS, Oracle Fusion, and Snowflake to ensure seamless data flows into our Oracle Autonomous Transaction Processing (ATP) environment. Your work will directly support front-end developers, enabling efficient data integrations that drive exceptional user experiences for some of the world’s largest organizations.
As a key member of our Customer Portal team, you’ll thrive in a collaborative, Agile environment, partnering with product owners, QA specialists, and front-end developers to design, implement, and optimize robust data solutions. Beyond PL/SQL, you’ll also expand your skill set through working with Oracle Integration Cloud (OIC) and Oracle Visual Builder Studio (VBS), gaining exposure to cutting-edge tools and best practices. Bring your problem-solving mindset, passion for clean code, and commitment to continuous improvement, and together we’ll deliver a responsive, reliable platform that transforms how our customers manage and monitor their mission-critical infrastructure.
What kind of work will you be doing?
PL/SQL Development:
- Architect and develop robust PL/SQL queries, stored procedures, triggers, and functions to drive the Customer Portal’s data flows, ensuring high performance and data integrity
- Seamlessly integrate and process data from multiple sources—including Oracle EBS, Oracle Fusion, and Snowflake—using best practices in query design and code modularity
- Continuously refine and optimize PL/SQL code to handle large data volumes and evolving business requirements, ensuring the platform remains efficient and responsive
Oracle Integration Cloud (OIC) (Highly Preferred):
- Collaborate with front-end Visual Builder Cloud Services and Oracle Integration Cloud developers to ensure efficient communication with Oracle Autonomous Transaction Processing (ATP) and Oracle EBS databases
- Utilize OIC for data synchronization between Oracle EBS, Oracle ATP, and external systems, ensuring efficient, secure integrations
- Monitor, maintain, and optimize existing OIC integrations to handle high-volume and mission-critical transactions
Oracle Visual Builder Studio (VBS) Collaboration:
- Integrate backend services with Oracle Visual Builder Studio, working closely with front-end developers to ensure seamless data flow and user experience
- Develop and maintain REST APIs or similar services as needed for VBS-based applications
Performance Optimization & Troubleshooting:
- Review and refactor existing queries and stored procedures to follow best practices and deliver performance improvements
- Work with the Business Analyst to investigate data issues and discrepancies, ensuring data integrity across systems
Data Insights & Reporting:
- Query and analyze data from Oracle EBS, Oracle ATP, and other integrated sources to provide insights and KPI metrics for the Product Owner
- Collaborate with stakeholders to turn raw data into actionable recommendations that drive product and business decisions
Agile Collaboration & Delivery:
- Participate in sprint planning, daily stand-ups, and retrospectives, contributing to the continuous improvement of Agile processes
- Work closely with Product Owners, Business Analysts, and QA to clarify requirements, define acceptance criteria, and ensure high-quality deliverables
- Act as the data scripting expert on the team in developing CI/CD and DevOps solutions
Code Quality & Testing:
- Create and maintain unit tests for PL/SQL code, ensuring robust error handling and data validation
- Utilize Git to track changes, collaborate, and automate deployments
- Conduct code reviews and provide constructive feedback to peers, fostering a collaborative and high-quality development culture
Technical Leadership & Mentorship:
- Assist junior developers by sharing expertise in PL/SQL, Oracle EBS, and integration best practices
- Lead or contribute to technical design discussions, offering insights on architecture, performance, and scalability
Documentation & Knowledge Sharing:
- Maintain clear, comprehensive technical documentation for all developed components, including architectural diagrams and SOPs
- Share knowledge through team wikis, workshops, or lunch-and-learn sessions to continually upskill the broader team