Oracle to PostgreSQL Migration Architect

About the CompanyAt 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.Title:-Oracle to PostgreSQL Migration ArchitectLocation:- Sunnyvale, CA(Onsite)Type:- Contract/FTE(Both)About the RoleAn 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 ResponsibilitiesAssessment & 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 Experience:-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.Thanks!Vishal TyagiVishal.Tyagi@programmers.aiDirect Number: +19725879306 Extension Number: 472