MonoSpear Technologies - Oracle Database Migration Specialist - Performance Tuning

Job Title : Oracle Database Migration Specialist

Experience : 7+ Years

Location : Bangalore

Job Type : Full-time

Initial Location : Hyderabad - Company will cover expenses during this period

Subsequent Location : Bangalore

Overview

We are seeking an experienced Oracle Database Migration Specialist to join our team.

This role focuses on managing and executing complex database migrations, specifically Oracle-based migrations across different platforms.

The ideal candidate will have a deep understanding of Oracle database migration techniques, tools like Oracle GoldenGate, RMAN, Data Pump, and cross-platform migration strategies.

You will be responsible for ensuring smooth, near-zero downtime database migrations, with expertise in migrating databases between Oracle and non-Oracle platforms like SQL Server and PostgreSQL.

Key Responsibilities

Oracle Database Migration :

• Lead and manage cross-platform database migrations including Unix to Linux, Linux to Unix, and Linux to Linux.
• Perform Oracle-to-Oracle migrations using RMAN, Data Pump, and GoldenGate, ensuring minimal or no downtime.
• Oversee Oracle-to-SQL Server and Oracle-to-PostgreSQL migrations, ensuring proper data integrity and performance post-migration.
  
  

Migration Planning & Execution

• Plan and architect migration strategies, working closely with stakeholders to ensure requirements are met and minimize risk.
• Define and implement rollback strategies for migration, ensuring database availability and minimal disruption.
• Coordinate and execute migrations, including pre-migration health checks, data validation, and post-migration optimizations.
  
  

Database Optimization Post-Migration

• Perform database performance tuning and optimization post-migration to ensure optimal database performance.
• Troubleshoot and resolve performance issues arising after the migration to ensure smooth operations in production environments.
  
  

Automation & Scripting

• Develop scripts to automate migration processes, data transfers, and other associated tasks to reduce downtime and manual intervention.
• Automate tasks such as backup, restore, and verification as part of the migration process using scripting languages (Shell, Python, Perl).
  
  

Cross-Platform Migration Expertise

• Provide expertise in migrating Oracle databases to non-Oracle platforms like SQL Server and PostgreSQL.
• Ensure compatibility of schema, data, and stored procedures when migrating between Oracle and non-Oracle platforms.
  
  

Documentation & Reporting

• Create and maintain comprehensive documentation for the migration process, including steps taken, issues encountered, and solutions implemented.
• Provide clear and concise reporting on migration progress, timelines, and any risks or roadblocks.
  
  

Collaboration

• Work closely with infrastructure, application teams, and project managers to ensure that migration goals are aligned with business objectives.
• Support the sales team with migration-related queries and help design solutions for client proposals.
  
  

Required Skills And Experience

Oracle Database Migration Expertise :

• Proven experience in cross-platform database migration, especially Oracle to Oracle, Oracle to SQL Server, and Oracle to PostgreSQL.
• Deep expertise with Oracle tools for migration such as RMAN, Data Pump, and Oracle GoldenGate.
  
  

Advanced Database Tools

• Experience in using Oracle GoldenGate for real-time data replication during migrations.
• Knowledge of database optimization and tuning after migration to ensure long-term Understanding :
• Experience migrating databases between different operating systems like Unix to Linux, Linux to Unix, and Linux to Linux.
• Hands-on experience with non-Oracle database platforms (SQL Server, PostgreSQL) and their migration strategies.
  
  

Scripting & Automation

• Strong skills in scripting (Shell, Python, Perl) to automate various migration-related tasks.
• Ability to design and execute scripts for backup, restore, validation, and optimization during the migration.
  
  

Problem Solving & Troubleshooting

• Expertise in troubleshooting complex database migration issues, ensuring data integrity and performance.
  
  

Desired Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) certification is preferred.
• Experience in large-scale database migrations across diverse platforms.
  
  

Work Environment

• Fast-paced, dynamic team environment.
• Occasional on-call or after-hours support may be required for migrations
  
  

(ref:hirist.tech)