Job Description
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
...