Database Architect

Role Overview

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:

• SQL workload characterization

• Locking and contention analysis

• Index effectiveness review

• I/O bottleneck analysis

• Schema health review

The analysis must support cross-layer root cause identification and optimization recommendations.

Architecture Baseline Support

Support the establishment of a validated architecture baseline by analyzing:

• Application-to-database coupling points

• Cross-schema dependencies

• Integration patterns

• Data access patterns impacting performance or scalability

Findings must contribute to the current-state architecture documentation and evidence register.

Technical Debt Quantification

Identify and quantify database-related technical debt including:

• Performance constraints arising from the Oracle 10g environment

• Structural limitations caused by tightly coupled application-database designs

• Maintainability risks associated with legacy database structures

Each identified item must include impact analysis and cost-of-inaction considerations.

Optimization Recommendation Development

Contribute to the creation of categorized optimization recommendations:

Category A – Near-Term Optimizations

• Configuration tuning

• Operational improvements

• Minimal-risk enhancements

Category B – Moderate Structural Remediation

• Controlled database upgrades

• Compatibility-preserving migration approaches

All recommendations must include:

• Technical scope breakdown

• Effort estimation

• Dependency sequencing

• Risk mitigation plan

• Rollback considerations

Operational and Reliability Assessment

Evaluate database operational posture including:

• Backup and recovery practices

• RMAN validation

• Capacity monitoring

• Patch application and change management

• Production uptime management

Required Experience & Background

Candidates must demonstrate:

• Minimum seven (7) years of hands-on experience managing Oracle 10g or comparable legacy Oracle database environments in live production.

• Direct operational ownership in production environments (advisory-only experience is not considered equivalent).

• Experience performing:

  • Locking and contention analysis

  • SQL workload characterization

  • RMAN-based backup and recovery validation

  • Patch application and change management

  • Capacity monitoring and uptime management

• Experience working with Oracle Forms-integrated database environments.

Technical Skills

Required expertise includes:

• Oracle 10g database administration and performance analysis

• SQL performance analysis and workload profiling

• Oracle RMAN backup and recovery frameworks

• Database performance tuning and indexing strategies

• Legacy Oracle environments supporting monolithic applications

• Database analysis within hybrid infrastructure environments