Oracle Architect

Requirements

Oracle Architect

Oracle RAC (Real Application Clusters)

RMAN

OEM

Data Guard

Key Responsibilities

2. Oracle RAC and High Availability

3. Monitoring, Backup, and Recovery

4. Database Performance Optimization

5. Data Integration and Migration

6. Database Administration and Security

• Database Architecture and Design
• Architect robust, scalable, and secure Oracle database solutions aligned with business needs and future growth.
• Define and implement database standards, frameworks, and design patterns to support enterprise-wide Oracle systems.
• Collaborate with cross-functional teams to understand business requirements and translate them into database architecture specifications.
• Expertly configure, manage, and maintain Oracle RAC environments to ensure system uptime and fault tolerance.
• Implement and manage Data Guard for disaster recovery and high availability configurations.
• Provide guidance to network and infrastructure teams on Oracle RAC networking and clustering requirements.
• Utilize Oracle Enterprise Manager (OEM) for proactive monitoring, capacity planning, and system health checks.
• Manage and implement effective backup and recovery strategies using RMAN, ensuring data integrity and minimal downtime.
• Automate health checks, alerts, and diagnostic procedures to maintain system performance and availability.
• Lead performance tuning initiatives, including SQL query optimization, index tuning, and memory management.
• Design and implement partitioning, caching, and clustering strategies to handle large datasets and maximize throughput.
• Conduct regular system audits and capacity planning reviews to anticipate and mitigate potential bottlenecks.
• Plan and execute seamless Oracle upgrades, patching, and database migrations with minimal disruption to business operations.
• Integrate Oracle systems with external applications using tools like Oracle GoldenGate, ensuring data consistency and near real-time synchronization.
• Lead efforts around data consolidation, transformation, and modernization initiatives.
• Provide day-to-day operational support for Oracle environments including health monitoring, issue resolution, and configuration management.
• Ensure compliance with data security standards, implementing user access controls, encryption, and auditing procedures.
• Maintain detailed documentation on architecture, configurations, and procedures.
  

Required Skills & Qualifications

• Minimum 9 years of hands-on experience in Oracle database administration and architecture.
• Expertise in Oracle RAC, OEM, RMAN, ASM, Data Guard, and GoldenGate.
• Proficiency in Oracle 11g/12c/19c environments.
• Strong knowledge of SQL, PL/SQL, and database performance tuning techniques.
• Proven experience with backup, recovery, and disaster recovery strategies.
• Familiarity with enterprise CI/CD practices and scripting is a plus.
• Strong problem-solving, analytical, and communication skills.
• Ability to work independently and manage multiple high-impact projects simultaneously