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

...