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
π
Average salary range of similar jobs in
analytics β
Loading...