Oracle Database Consultant

About the Role

TestCrew | Quality Engineering & Software Testing is seeking an experienced Oracle Database Consultant to join their team in Riyadh. This full-time role involves conducting comprehensive discovery and assessment of the organization's Oracle database environment. The consultant will be responsible for identifying existing database instances, assessing architecture and configurations, evaluating performance, security, availability, and resilience, and providing recommendations for overall environment improvement.

Key Responsibilities

• Perform comprehensive Oracle database discovery activities to identify all existing database instances, environments, versions, editions, and configurations.
• Build and maintain an inventory of Oracle databases across production, development, testing, disaster recovery, and other environments.
• Assess database architecture, infrastructure, configurations, and deployment models, identifying dependencies with business applications, middleware, and other technology components.
• Evaluate the overall health, performance, capacity, and stability of Oracle database environments, including performance metrics, resource utilization, and workloads.
• Identify performance bottlenecks, capacity constraints, configuration issues, and potential scalability concerns, providing recommendations for optimization.
• Assess the security posture of Oracle databases, covering authentication, authorization, access controls, encryption, auditing, and security configurations.
• Review existing backup and recovery strategies, high-availability configurations, and disaster recovery architecture, including RPO and RTO.
• Identify technical, operational, architectural, security, and compliance risks, single points of failure, and operational gaps.
• Prepare comprehensive discovery and assessment reports, documenting current-state architecture, database inventory, dependencies, risks, and key findings.
• Develop recommendations and target-state improvements for database architecture, performance, security, availability, backup, and disaster recovery.

Key Deliverables

• Oracle Database Discovery & Inventory Report
• Current-State Database Architecture Assessment
• Database Health & Performance Assessment
• Security & Compliance Gap Assessment
• Backup, Recovery, HA & DR Assessment
• Risk & Single Point of Failure Assessment
• Prioritized Recommendations & Remediation Roadmap
• Target-State Oracle Database Architecture Recommendations

Qualifications and Experience

Candidates should possess strong hands-on experience with Oracle Database architecture, administration, performance assessment, high availability, backup and recovery, disaster recovery, security, and database infrastructure assessment. A minimum of 5-10 years of relevant experience is required for this role.

Work Environment

This is a full-time position based in Riyadh.