Oracle to PostgreSQL Migration Architect

Oracle to Postgre

SQL Migration Architect

Location:

Sunnyvale, CA (Onsite) Salary:
Market (DOE) FTE - open for contract

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 can't consider anyone who is not excellent in
1) Data Structure & Algorithms,
2) System Design and
3) Cloud computing especially Kube. An Oracle to Postgre

SQL Migration Architect leads the technical strategy, assessment, schema conversion, and data migration from Oracle to Postgre

SQL (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 Postgre

SQL 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, Ora2

Pg, or pgloader, ensuring data integrity. Performance Optimization:
Tune Postgre

SQL 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. Postgre

SQL Proficiency:
Strong knowledge of Postgre

SQL internals, PL/pgSQL, and configuration. Migration Tools:

Experience with migration tools such as AWS Schema Conversion Tool (SCT), AWS Database Migration Service (DMS), or Ora2

Pg. 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-Postgre

SQL migration. Key Skills for Success Understanding of microservices architecture. Database security best practices. Excellent communication and stakeholder management skills.