Oracle Database Architect

Thakral One; Quezon City; On-site; PHP 1,004,400 - 1,339,200; Full time

Job summary

A technology solutions provider located in Quezon City is looking for an Oracle Database Architect to lead the assessment of Oracle database performance and stability within legacy technology systems. The ideal candidate will have extensive experience with Oracle 10g, and will be responsible for developing actionable recommendations for optimisation while collaborating with assessment teams. Candidates should have strong SQL performance analysis skills and experience in RMAN backup validation, with at least seven years in live production environments.

Qualifications

• At least seven years of hands-on experience with Oracle 10g or similar databases.
• Direct experience with SQL workload profiling and RMAN backup.
• Experience in integrated Oracle Forms environments.

Responsibilities

• Lead assessments of Oracle database performance and architectural constraints.
• Identify optimisation opportunities and cross layer root causes.
• Develop actionable recommendations for operational enhancements.

Skills

SQL performance analysis

Oracle 10g administration

Database analysis

Capacity monitoring

Collaboration

Job description

As an Oracle Database Architect, you will lead the assessment of the Oracle database layer within a legacy technology stack. You will evaluate performance, stability, architectural constraints, and technical debt, contributing to an implementation ready optimisation roadmap. Your work will support cross layer findings and strengthen the technical foundation needed for improvement planning.

What You’ll Do and How You’ll Succeed

Database Assessment

• Analyse SQL workloads, locking and contention issues, indexing, input or output bottlenecks, and schema health.
• Identify cross layer root causes and opportunities for optimisation.
• Review application to database touchpoints, cross schema dependencies, and data access patterns.
• Contribute to current state architecture documentation and evidence logs.

Technical Debt Analysis

• Identify performance, structural, and maintainability risks related to Oracle 10g and tightly coupled legacy designs.
• Provide impact assessments and cost of inaction summaries.

Optimisation Recommendations

• Develop actionable recommendations that include near term tuning, operational enhancements, and low risk fixes.
• Propose moderate remediation paths such as database upgrades and compatibility preserving migration approaches.
• Provide effort estimates, dependencies, risks, and rollback considerations.

Operational and Reliability Review

• Assess backup and recovery practices, including RMAN validation.
• Evaluate capacity monitoring, patch and change management, and production uptime processes.

We’d Love to Hear From You If…

Experience

• You have at least seven years of hands on experience with Oracle 10g or similar legacy Oracle databases in live production environments.
• You have direct experience in SQL workload profiling, locking or contention analysis, RMAN backup and recovery validation, patch and change management, and capacity or uptime monitoring.
• You have worked in Oracle Forms integrated environments.

Technical Expertise

• Oracle 10g administration and performance tuning
• SQL performance analysis and indexing strategies
• RMAN backup and recovery
• Monolithic or legacy Oracle backed application environments
• Database analysis in hybrid infrastructure settings

Ways of Working

• You analyse database behaviours methodically and document findings clearly.
• You can translate technical findings into actionable recommendations.
• You collaborate effectively within multi layer assessment teams.

Clicking will redirect you to our secure recruitment platform.