Required Skills

Oracle DBA

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 28th Oct 2024

JOB DETAIL

• Install, configure, and maintain Oracle Golden Gate for real-time data replication across heterogeneous databases.
• Hands on 10+ years’ experience on Oracle DBA skills
• Experience on MySQL, Cassandra
• Experience setting up master-slave replication and configured automatic failover in MySQL to ensure data availability
• Managed and monitored Oracle RAC environments, ensuring high availability and performance.
• Implement backup and recovery strategies using RMAN and Data Pump.
• Experience on Optimized Cassandra data partitioning and replication strategies
• Perform database tuning and optimization to achieve zero lag times in Golden Gate processes.
• Develop and maintain database documentation, including schemas, procedures, and best practices.
• Collaborate with development and operations teams to ensure seamless integration and performance of database systems.
• Conduct regular database audits and health checks to ensure optimal performance and security.
• Perform data migration and transformation tasks using Data Pump and SQL*Loader.
• Develop and implemented disaster recovery plans to ensure data integrity and availability.
• Proficient in below tools
• Backup & Recovery: RMAN, Data Pump, Export/Import
• Performance Tuning: AWR, ASH, SQL Tuning
• Tools & Utilities: OEM, Grid Control, SQL*Loader
• Unix shell scripting and the ability to automate routine tasks
• Certifications preferred: Oracle Cloud Infrastructure Architect Professional.

Company Information