Job Title: Senior Oracle Database Engineer / Oracle Developer – Data Migration
Location: Thane
Experience: 3–8 Years
Employment Type: Full-Time

Job Summary

We are looking for an experienced Oracle Database Engineer / Oracle Developer with a strong background in large-scale data migration projects. The ideal candidate should have hands-on experience migrating millions of records (high-volume datasets) across Oracle databases, legacy systems, ERP platforms, or core banking applications while ensuring data integrity, performance, and minimal downtime.

The candidate will be responsible for end-to-end migration activities including data analysis, extraction, transformation, loading (ETL), validation, reconciliation, performance tuning, and post-migration support.

Key Responsibilities Data Migration & Conversion

• Lead end-to-end data migration projects involving high-volume enterprise data.
• Analyze source and target database structures and prepare migration strategies.
• Design and develop migration scripts, PL/SQL packages, procedures, and automation utilities.
• Perform data extraction, transformation, cleansing, and loading activities.
• Execute bulk data loads using Oracle utilities such as SQL*Loader, Data Pump, External Tables, and custom ETL frameworks.
• Conduct data reconciliation and validation to ensure 100% data integrity.

Oracle Development

• Develop and maintain complex PL/SQL packages, procedures, functions, triggers, and views.
• Optimize database performance for large-volume transaction processing.
• Design scalable database solutions supporting millions of records.
• Implement indexing, partitioning, and query optimization techniques.

Performance & Database Optimization

• Tune SQL queries and PL/SQL programs handling large datasets.
• Monitor execution plans and identify bottlenecks.
• Improve ETL and migration performance for faster processing windows.
• Support database performance tuning during migration and go-live activities.

Testing & Quality Assurance

• Perform migration dry runs and mock cutovers.
• Validate migrated data using reconciliation reports.
• Conduct UAT and production deployment support.
• Ensure compliance with audit and regulatory requirements.

Stakeholder Management

• Work closely with business users, data architects, application teams, and project managers.
• Prepare migration documentation, mapping documents, and deployment plans.
• Provide regular project status updates and risk assessments.

Mandatory Skills

• Oracle Database (11g/12c/19c/21c)
• Advanced PL/SQL Development
• Oracle Data Pump (EXPDP/IMPDP)
• SQL*Loader
• ETL Development
• Data Migration & Data Conversion
• Performance Tuning
• Query Optimization
• Oracle RAC (preferred)
• Partitioning & Indexing
• Data Validation & Reconciliation
• Shell Scripting / Linux

Preferred Experience

Candidates should have worked on one or more of the following:

• Core Banking Data Migration
• Oracle to Oracle Migration
• Legacy System to Oracle Migration
• ERP Migration (SAP, Oracle EBS, Fusion, PeopleSoft)
• Data Warehouse Migration
• Cloud Migration Projects
• Financial Services / BFSI Transformation Projects

Required Experience

• 5+ years of Oracle Database Development experience.
• At least 2–3 end-to-end data migration projects.
• Experience handling databases containing 50 million+ records.
• Strong expertise in bulk data processing and migration validation.
• Experience working in production-critical environments.

Pay: ₹600,000.00 - ₹1,400,000.00 per year

Benefits:

• Paid sick time
• Provident Fund

Work Location: In person