Oracle Database Architect

Thakral One; Metro Manila; On-site; PHP 1,200,000 - 1,800,000; Full time

Job summary

A technology consulting firm in Metro Manila seeks a Database Architect to lead database layer assessments and optimize Oracle 10g environments. Responsibilities include identifying performance constraints, quantifying technical debt, and developing categorized optimization recommendations. The ideal candidate will have at least seven years of hands-on experience in production settings with direct operational ownership in Oracle database management, including performance analysis and capacity monitoring.

Qualifications

• Minimum 7 years of hands-on experience with Oracle 10g in production environments.
• Direct operational ownership; advisory experience is not equivalent.
• Experience with locking and contention analysis and capacity management.

Responsibilities

• Conduct structured analysis of the Oracle database layer.
• Develop optimization recommendations for database improvements.
• Quantify and identify technical debt associated with database operations.

Skills

Oracle 10g database administration

SQL performance analysis

Database performance tuning

RMAN backup and recovery frameworks

Legacy Oracle environments

Indexing strategies

Capacity monitoring

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

Schema health review

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

Support the establishment of a validated architecture baseline by analyzing:

Application-to-database coupling points

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

Operational improvements

Category B – Moderate Structural Remediation

Controlled database upgrades

Compatibility-preserving migration approaches

All recommendations must include:

Technical scope breakdown

Rollback considerations

Operational and Reliability Assessment

Backup and recovery practices

RMAN validation

Capacity monitoring

Patch application and change management

Required Experience & Background

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

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