MonoSpear Technologies

2 weeks ago


Anywhere in IndiaMultiple Locations MonoSpear Technologies Pvt Ltd Full time ₹ 12,00,000 - ₹ 36,00,000 per year

About the Role :

We are looking for a highly experienced Oracle Database Migration Specialist with deep expertise in Oracle GoldenGate to lead and execute end-to-end database migration projects.

The ideal candidate will have a strong understanding of Oracle database architecture, real-time replication, and zero-downtime migration strategies using GoldenGate, both on-premises and in cloud environments (AWS, Azure, OCI, etc.

Youll play a critical role in planning, implementing, monitoring, and validating complex migrations with a strong emphasis on data integrity, performance, and minimal downtime.

Key Responsibilities :

- Design and implement robust data migration strategies using Oracle GoldenGate for real-time, high-volume replication.

- Plan and execute zero-downtime migrations from legacy or on-prem databases to target environments (on-prem, cloud, hybrid).

- Configure, monitor, and troubleshoot GoldenGate components (extract, pump, replicat, trails, checkpointing, etc.

- Ensure bidirectional replication, conflict detection/resolution, and proper synchronization pre-cutover.

- Perform database assessments, source/target environment compatibility checks, and schema/data validations.

- Optimize Oracle database performance during migration using techniques like partitioning, parallel execution, and tuning.

- Validate data consistency and referential integrity post-migration

- Automate migration processes using GoldenGate scripting, Oracle Data Pump, and Shell/Python scripts.

- Create detailed runbooks, rollback plans, and verification checklists.

- Work with cloud-native Oracle solutions (Oracle Cloud Infrastructure) or other platforms like AWS RDS/Aurora, Azure SQL/Oracle VM, etc.

- Migrate and replicate data to/from heterogeneous environments when needed.

- Document architecture, configuration, and operational procedures.

- Collaborate with application teams, DBAs, infrastructure, and security to align migration timelines and support post-migration stabilization.

- Conduct knowledge transfer sessions and train internal teams on GoldenGate best practices.

Required Skills & Experience :

years of experience in Oracle database administration and performance tuning.

years hands-on experience with Oracle GoldenGate (11g, 12c, 19c) in production environments.

- Proven experience with large-scale Oracle database migrations across environments (on-prem to cloud, cross-region, hybrid).

- Strong knowledge of :

- Oracle RDBMS (11g/12c/19c)

- PL/SQL scripting

- Oracle Data Pump, RMAN, and backup/restore strategies

- Oracle RAC and Data Guard (a plus)

- Familiar with database monitoring, alerting, and performance tools (OEM, AWR, ASH, etc



  • Anywhere in India/Multiple Locations MonoSpear Technologies Pvt Ltd Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Role Overview : As a Technical Lead, you will play a pivotal role in driving the technical direction, architecture, and implementation of complex systems. You will leverage your expertise in , NestJS, PHP, React, , TypeScript, Microservices, and cutting-edge DevOps practices to build solutions that scale, perform, and innovate. Key...


  • Anywhere in India/Multiple Locations MonoSpear Technologies Pvt Ltd Full time ₹ 10,00,000 - ₹ 25,00,000 per year

    Job Opening : Oracle HCM Cloud Payroll Consultant (Contract).Location : Middle East Doha (Work from Office Initial 3 months only, then offshore).Duration : 1-Year Contract.Notice Period : Maximum 1 Month.Preferred Experience : - Minimum 7 years of total IT experience. - Minimum 4 years of Oracle HCM Cloud functional consulting experience. - Previous...