Oracle to PostgreSQL Migration Architect

Sunnyvale, CA - USA

Monthly Salary: Not Disclosed

Posted on: 15 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Description

We need to have profiles with excellent software engineering skill. Someone who can understand the customization done on the existing system using Java and Go Lang and do the same in the new system.

We cant consider anyone who is not excellent in 1) Data Structure & Algorithms 2) System Design and 3) Cloud computing especially Kube.

An Oracle to PostgreSQL Migration Architect leads the technical strategy assessment schema conversion and data migration from Oracle to PostgreSQL (often AWS RDS/Aurora or Azure). They specialize in mapping Oracle PL/SQL to PL/pgSQL optimizing performance designing cloud-native database architectures and reducing downtime.

Key Responsibilities

Assessment & Strategy: Evaluate existing Oracle database environments to plan the migration roadmap including TCO analysis and application dependency mapping.
Migration Design: Design scalable secure PostgreSQL schema architectures converting Oracle PL/SQL stored procedures triggers views and packages to PL/pgSQL.
Technical Execution: Perform data migrations using tools like AWS SCT/DMS Ora2Pg or pgloader ensuring data integrity.
Performance Optimization: Tune PostgreSQL performance including indexing query optimization and handling differences in storage engines.
Troubleshooting & Support: Resolve complex data type mismatches handle replication issues and provide troubleshooting during and after migration.

Required Technical Skills

Oracle Expertise: Proficient in Oracle Database Administration PL/SQL and SQL performance tuning.
PostgreSQL Proficiency: Strong knowledge of PostgreSQL internals PL/pgSQL and configuration.
Migration Tools: Experience with migration tools such as AWS Schema Conversion Tool (SCT) AWS Database Migration Service (DMS) or Ora2Pg.
Cloud Platforms: Knowledge of AWS (RDS/Aurora) or Azure.
Scripting: Proficiency in Python Bash or Perl for automation.

Required Experience & Education

10 years of hands-on experience in Oracle Database Administration with 3 years specifically in Oracle-to-PostgreSQL migration.

Key Skills for Success

Understanding of microservices architecture.
Database security best practices.
Excellent communication and stakeholder management skills.

Job Description We need to have profiles with excellent software engineering skill. Someone who can understand the customization done on the existing system using Java and Go Lang and do the same in the new system. We cant consider anyone who is not excellent in 1) Data Structure & Algorithms 2) ...