Position: Senior Oracle PL/SQL developer
Company: 8allocate
Experience required: 5y
Category: SQL
English level: upper
Published: 2023-05-01T00:00:00+03:00

**8allocate** is a global provider of end-to-end custom software development solutions to companies all over the globe, from North America to the EU to Israel to Australia.

Headquartered in Estonia, we run offshore Research and Development centers in Kyiv and Lviv. Our team is 50% remote and distributed. We specialize in flexible interaction exclusively with international clients (we cover industries from commercial aviation to fintech) thanks to a multinational support group of experts and management.

Currently, we are looking for a **Senior Oracle PL/SQL developer**.

**About the project:**  The project involves enhancing the existing global risk system for a commodity trading firm that operates in multiple countries. The system is currently implemented using a combination of PL/SQL and SSIS. The primary objective is to separate the code base for the London office from the newly integrated requirements of the Japan office. This separation will involve creating a new templated code base specifically for Japan, including its own static and reference data. The project also includes integrating the new code base and batch-processing outputs into the global risk schemas. Extensive system and user acceptance testing will be required. 

**What skills are required:**
— 6+ years of relevant experience 
— Strong experience in PL/SQL development, including the ability to write efficient and optimized code.
— Prior experience working on complex systems, preferably in a commodities or financial services environment.
— Knowledge of market risk concepts is highly desirable.
— Proficiency in Oracle databases and tools (e.g., Oracle SQL Developer, TOAD).
— Solid understanding of data modeling principles and the ability to propose changes to existing data models.

**Responsibilities:**
— Collaborate with the existing team to address a large backlog of Oracle enhancements and new developments.
— Develop and maintain PL/SQL packages to support the functionality and performance of the system.
— Perform detailed analysis of existing systems to identify areas for improvement and propose tactical and strategic implementations to meet requirements.
— Propose changes to existing data models and potentially create new models to enhance system capabilities.
— Ensure the integrity and reliability of data through effective data management practices.
— Troubleshoot and resolve issues related to PL/SQL code, database performance, and data integrity.

**Why choose us?**
— “Family and Friends”. We are no longer a start-up, but we still have a family atmosphere in our supportive and spirited team, who are all working together on the same goal.
— “Just break down all barriers and find a better way”. Every day you’ll meet with interesting and challenging (international) projects that are covering industries from commercial aviation to fintech (different technologies, different products).
— “Hungry for learning”. You will get a lot of chances for career advancement and the development of new skills, opportunities for mentorship, or from more experienced colleagues.

**Benefits from 8allocate:**
— You’ll work with a supportive and spirited team of professionals.
— Corporate events, holidays, and team buildings for your joy.
— Training and development: we have a huge library (about 500 books!) and a budget for your professional development.
— Сoverage of sports activities.
— People-oriented management without bureaucracy.
— Coverage of psychologist sessions.