Oracle Database Architect

Job Title: Oracle Database Architect

Location: Manhattan NY

Duration: / Term: 6 months

Job Description:

Experience Desired: 12 Years.

We are seeking an experienced Oracle RAC Architect to design implement and maintain high-availability database solutions using Oracle Real Application Clusters (RAC). The ideal candidate will lead complex database architecture initiatives and provide technical leadership in a mission-critical environment.

Responsibilities

• Design and implement Oracle RAC Oracle Exadata architectures that ensure high availability scalability and optimal performance across multiple nodes and clusters
• Develop technical specifications architectural diagrams and documentation for Oracle RAC implementations and migrations
• Lead capacity planning initiatives and provide recommendations for hardware and software requirements
• Establish best practices for Oracle RAC Exadata administration backup and recovery and disaster recovery procedures
• Mentor and provide technical guidance to database administrators and development teams
• Perform complex troubleshooting of RAC-related issues and implement preventive measures
• Create and maintain automation scripts for RAC deployment maintenance and monitoring
• Collaborate with cross-functional teams to ensure database architectures align with business requirements
• Conduct regular health checks and performance tuning of RAC environments
• Lead database upgrade and migration projects while ensuring minimal downtime

Requirements:

• Minimum 12 years of experience as an Oracle Database Administrator with at least 5 years of hands-on Oracle RAC experience
• Oracle Certified Master (OCM) or equivalent advanced Oracle certifications
• Expert knowledge of Oracle RAC 12c/19c/21c architecture Grid Infrastructure and ASM
• Strong experience with Oracle Data Guard Golden Gate and other high availability solutions
• Proven experience in performance tuning backup and recovery and disaster recovery planning
• Advanced knowledge of Linux/Unix operating systems and shell scripting
• Experience with automation tools and infrastructure as code principles
• Strong understanding of storage systems networking and cluster technologies
• Technical Experience in the following areas.

• Oracle RAC 12c/19c/21c
• Grid Infrastructure and ASM
• Oracle Data Guard
• Oracle GoldenGatePP1
• Oracle Exadata
• Linux/Unix Administration
• Shell Scripting (Bash Python)
• SQL and PL/SQL
• Network and Storage Technologies
• Infrastructure Automation Tools
• Performance Monitoring and Tuning Tools
• DB migration Tools XTTS Golden Gate AWS DMS SCT Datapump Backup restore methods. PP2

• Preferred Skills:

• Experience with cloud platforms (AWS Azure OCI) and cloud-based RAC deployments and migrations specifically on AWS.
• Knowledge of container technologies and microservices architectures
• Experience with monitoring tools like Oracle Enterprise Manager Prometheus or Grafana
• Background in implementing Oracle Exadata or other engineered systems
• Experience with database security and compliance requirements
• Knowledge of DevOps practices and CI/CD pipelines

Key Skills:

Oracle RAC Oracle Exadata architectures RAC 12c/19c/21c architecture Grid Infrastructure ASM Data Guard Golden Gate