| Oracle to PostgreSQL Migration Architect || Sunnyvale, CA (Onsite) at Sunnyvale, California, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=3397165&uid=506375678ea44730bb7e6532b067e2b4 From: Shubham Kumar, Tanisha Systems Inc. [email protected] Reply to: [email protected] Position: Oracle to PostgreSQL Migration Architect Location: Sunnyvale, CA (Onsite) C2C Strong Python Coder having experience in creating Microservices on database and you can have any database migration. 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. 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. Thanks & Regards | | Shubham Kumar Team Lead Tanisha Systems Inc. Desk: (732) 377-3397 EXT- 589 99 Wood Ave South, Suite # 308, Iselin, NJ 08830 Email: [email protected] Web: www.tanishasystems.com | E-Verify, Certified Minority Business Enterprise MBE, Dun & Bradstreet CREDIBILITY CORP Certified Keywords: information technology procedural language California New Jersey Oracle to PostgreSQL Migration Architect || Sunnyvale, CA (Onsite) [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=3397165&uid=506375678ea44730bb7e6532b067e2b4 |
| [email protected] View All |
| 10:09 PM 22-May-26 |