Oracle to PostgreSQL Migration Architect

First Call Trading Corporation
Los Altos, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Los Altos, United States of America

Tech stack

Amazon Web Services (AWS)
Azure
Bash
Cloud Computing
Cloud Engineering
Databases
Data Integrity
Data Migration
Database Security
Perl
Python
PostgreSQL
Oracle
Oracle Applications
Oracle SQL Developer
Performance Tuning
Query Optimization
SQL Stored Procedures
PL-SQL
Scripting (Bash/Python/Go/Ruby)
Indexer
Database Migration
Amazon Web Services (AWS)
Sql Tuning
Microservices

Job description

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., * 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.

Requirements

Pls look for Strong Python Coder having experience in creating Microservices on database and you can have any database migration.

  • 10+ years of hands-on experience in Oracle Database Administration, with 3+ years specifically in Oracle-to-PostgreSQL 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.

PKey Skills for Success

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

About the company

At Programmers.IO, We help a global IT services and software development company specializing in application modernization, AI enablement, and legacy system support. We are growing fast and looking for a passionate Oracle to PostgreSQL Migration Architect with our Client is Wipro and location is Sunnyvale, CA(Onsite). The managers are working fast and looking forward to having a successful candidate on board at the earliest.

Apply for this position