Oracle Database Architect

The Database Architect will serve as the Database Layer Lead responsible for assessing the Oracle database layer within the AISIS technology stack. The role will focus on evidence-based analysis of database performance, operational stability, structural constraints, and technical debt , and will contribute to the development of an implementation-grade optimization roadmap .

The engagement is assessment and advisory only , covering database analysis within the broader application, database, and infrastructure stack .

The environment includes:

Oracle 10g Database

Oracle Forms and Reports (legacy)

Ruby on Rails components

Hybrid infrastructure (on-premise and cloud)

Key Responsibilities

Database Layer Assessment

Conduct structured analysis of the database layer including:

Locking and contention analysis

Index effectiveness review

I/O bottleneck analysis

...