What are the responsibilities and job description for the Onsite : Oracle to PostgreSQL Migration Architect , Sunnyvale, CA position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Mpower Plus Rezolve AI Group LTD, is seeking the following. Apply via Dice today!
Hi
I hope you are doing well.
My name is Sushmitha, and I am part of the Talent Acquisition team. I hope this message finds you well! I’m reaching out to connect regarding an exciting opportunity for candidates with 8-10 years of experience in Oracle to PostgreSQL Migration Architect.
Position: Oracle to PostgreSQL Migration Architect
Location: Sunnyvale, CA (Onsite)
Open for both contact and Full Time
Job Description
An Oracle to PostgreSQL Migration Architect leads to 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,
Sushmitha Penchala
Senior Recruiter– North America
Rezolve AI Limited
Add: 499 Park Ave, Suite 1003,
New York, NY 10022, USA
Contact: Contact: | Email:
WebSite: | LinkedIn:
Hi
I hope you are doing well.
My name is Sushmitha, and I am part of the Talent Acquisition team. I hope this message finds you well! I’m reaching out to connect regarding an exciting opportunity for candidates with 8-10 years of experience in Oracle to PostgreSQL Migration Architect.
Position: Oracle to PostgreSQL Migration Architect
Location: Sunnyvale, CA (Onsite)
Open for both contact and Full Time
Job Description
An Oracle to PostgreSQL Migration Architect leads to 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,
Sushmitha Penchala
Senior Recruiter– North America
Rezolve AI Limited
Add: 499 Park Ave, Suite 1003,
New York, NY 10022, USA
Contact: Contact: | Email:
WebSite: | LinkedIn: