Oracle Database Architect at Thakral One

Manila, Metro Manila, Philippines -

Full Time

Start Date

Immediate

Expiry Date

11 Jun, 26

Salary

0.0

Posted On

13 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle 10g, Database Architecture, SQL Workload Characterization, Locking Analysis, Index Review, Schema Health, RMAN, Performance Tuning, Forms and Reports, Ruby On Rails, Hybrid Infrastructure, Technical Debt Quantification, Capacity Monitoring, Change Management, Root Cause Identification, Optimization Roadmap

Industry

IT Services and IT Consulting

Description

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

Responsibilities

The Database Architect will lead the assessment of the Oracle database layer, focusing on performance, stability, and technical debt through evidence-based analysis. Key duties include conducting structured database analysis, supporting architecture baseline documentation, quantifying technical debt, and developing categorized optimization recommendations.