Oracle to Postgres on Azure migration

PradeepIT Consulting Services Pvt Ltd; Bengaluru; On-site; INR 1,800,000 - 2,400,000; Part time

Job summary

PradeepIT Consulting Services Pvt Ltd in Bengaluru is seeking a skilled database migration engineer to lead Oracle to PostgreSQL migrations on Azure cloud, with 6+ years in database development and migration.

You will evaluate on-premises environments, plan migrations to AWS RDS/Aurora, and develop test plans to demonstrate readiness post migration.

Requires Bash/Perl/Python scripting, experience with heterogeneous migrations, and strong troubleshooting and communication skills.

Qualifications

• Experience migrating Oracle/SQL Server/MySQL to PostgreSQL.
• Hands-on AWS services experience: RDS, Aurora, SCT, DMS.
• Experience with heterogeneous database migrations.
• Strong troubleshooting and communication skills.

Responsibilities

• Evaluate on-premises database environments and plan migrations to AWS RDS/Aurora.
• Enhance PLSQL/ TSQL scripts for migration.
• Identify workarounds for migration issues and corner cases.
• Develop test plan and test cases to demonstrate readiness post migration.

Skills

Oracle

PostgreSQL

AWS RDS

Aurora

SCT

DMS

PL/SQL

T-SQL

Bash

Perl

Python

Migration

Performance tuning

Troubleshooting

Backup & restore

Replication

Heterogeneous

Education

Bachelor's degree

Tools

AWS SCT

DMS

RDS

Job description

About the job Oracle to Postgres on Azure migration

JD: Mandatory skills: Oracle to Postgres on Azure migration.

• EXP 6 to 10 years
• Contract 3 Month

Responsibilities:

• Evaluate on-premises transactional database environments such as Oracle, SQL Server, MySQL, and PostgreSQL, evaluate and plan migrations to AWS RDS, Aurora.
• Enhance database PLSQL scripts/TSQL to migrate from source database to target database
• Identity workarounds for specific issues and corner scenarios observed during migration
• Develop test plan and testcases to demonstrate database readiness post migration

Requirements:

• Bachelor's degree preferred
• 6+ years of experience in database development/migration using Oracle/SQL Server/MySQL/PostgreSQL
• Hands-on experience on AWS Services - RDS, Aurora, SCT, DMS
• Experience with heterogenous database migrations
• Experience in performance optimization techniques
• High end Troubleshooting and Communication skills
• Scripting language (bash/Perl/python)
• Experience in Database Administration - backup/restore, replication, etc