Oracle Database Consultant

Job Overview

We seek a seasoned Oracle Database Consultant to perform a thorough discovery and evaluation of an organization's Oracle database systems. The role involves identifying all database instances, examining architecture and configurations, appraising performance, security, availability, and resilience, and providing expert recommendations for enhancement.

Primary Duties

• Conduct exhaustive discovery of all Oracle databases across various organizational environments, including production, development, testing, and disaster recovery, maintaining a detailed inventory of versions, editions, and setups.
• Analyze database architectures, infrastructures, and deployment methods as well as dependencies on applications, middleware, and other technology components.
• Evaluate database health by examining performance metrics, resource use, workloads, and configuration parameters to detect bottlenecks, capacity issues, and scalability challenges.
• Assess the security framework, including authentication, authorization, access control, encryption, and auditing to identify vulnerabilities and compliance gaps.
• Review backup, recovery policies, schedules, and disaster recovery measures including high availability solutions, replication, failover, RPO, and RTO to enhance resilience and operational readiness.
• Perform risk assessments identifying technical, operational, architectural, security, and compliance weaknesses, single points of failure, and outdated systems, then prioritize and develop a remediation roadmap.
• Document findings comprehensively detailing current architecture, dependencies, risks, and propose target-state improvements for architecture, performance, security, and disaster recovery strategies.
• Present detailed reports and recommendations to technical teams and stakeholders, supporting the creation of actionable optimization and modernization plans.

Qualifications & Experience

• Over 7 years of extensive experience in Oracle Database administration, architecture, or consulting in enterprise settings.
• Demonstrated expertise in database discovery, performance assessment, architecture reviews, and operational readiness checks.
• Strong knowledge in Oracle security controls, backup/recovery, high availability, and disaster recovery concepts.
• Excellent problem-solving and analytical capabilities with effective communication and documentation skills.

Preferred Attributes

• Oracle certifications such as Oracle Certified Professional (OCP).
• Familiarity with Oracle RAC, Data Guard, RMAN, and enterprise monitoring tools like Oracle Enterprise Manager.
• Experience in large-scale database environments, Linux/Unix platforms, and cloud environments (Oracle Cloud, AWS, Azure).
• Knowledge of compliance frameworks and database migration or modernization projects.

Deliverables

• Oracle Database Discovery and Inventory report.
• Assessment reports on current architecture, health, security, compliance, backup, recovery, high availability, disaster recovery, and risk.
• Identification of single points of failure and prioritized remediation plans with recommendations for future database architecture.