Database Architect/Engineer

$$$$
Product

Numerical Technologies LTD is a leading provider of custom software solutions and services specializing in risk, limits, and regulatory capital. Right now, we are looking for a Database Architect/Engineer to join our team.


What you will be doing:

 

  • Work on a large-scale modernization of a complex Oracle system with 15+ years of legacy PL/SQL code spread across hundreds of packages.
  • Analyze and decompose PL/SQL code to separate business logic, CRUD, and dead code, and define what stays in the database vs what is moved out.
  • Drive dependency analysis of PL/SQL packages and architectural decisions for system decomposition.
  • Design schema decomposition and data ownership across domains.
  • Own dual-run and dual-write strategies during migration.
  • Ensure backward compatibility through additive-only schema changes under production constraints.
  • Lead performance tuning, SQL optimization, and execution plan analysis.

     

Project:

  • Migration of a monolithic Oracle system to a decomposed architecture.
  • 723+ PL/SQL packages with tightly coupled legacy logic.
  • Gradual dual-run migration with controlled schema evolution in production.
  • Redesign of cross-domain dependencies and data ownership model.

     

What we’re looking for:

  • Strong Oracle Database 19c+ experience.
  • Strong PL/SQL (packages, procedures, functions, triggers).
  • Oracle performance tuning (Explain Plan, AWR/ASH, indexing, partitioning).
  • Large-scale legacy Oracle system experience.
  • Experience with database modernization / monolith decomposition.
  • Strong understanding of dual-run / dual-write consistency.
  • Experience with Flyway or Liquibase.
  • Ability to make architectural decisions in complex legacy database environments.

 

What we offer:

  • Competitive compensation depending on experience and skills.
  • Regular assessments and salary reviews.
  • Paid personal days.
  • Mental health support program.
  • Language classes.
  • Flexible working schedule.

Required languages

English B2 - Upper Intermediate
Ukrainian Native
Published 10 June
3 views
Β·
0 applications
To apply for this and other jobs on Djinni login or signup.
Loading...