Oracle Architect

This role is for one of Weekday’s clients
Salary range: Rs 1500000 - Rs 2800000 (ie INR 15-28 LPA)
Min Experience: 9 years
Location: Mumbai
JobType: full-time

We are seeking a highly skilled and experienced Oracle Architect to lead the design, development, and management of Oracle database solutions across our enterprise landscape. The ideal candidate will bring deep expertise in Oracle RAC (Real Application Clusters), RMAN, OEM, Data Guard, and other advanced Oracle technologies. This is a key role responsible for defining best practices, optimizing performance, ensuring high availability, and supporting complex data environments for mission-critical systems.

Key Responsibilities

1. 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.

2. Oracle RAC and High Availability

• 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.

3. Monitoring, Backup, and Recovery

• 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.

4. Database Performance Optimization

• 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.

5. Data Integration and Migration

• 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.

6. Database Administration and Security

• 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.