Oracle to PostgreSQL Migration Architect

East Brunswick, NJ, US • Posted 1 day ago • Updated 1 day ago
Full Time
On-site
Depends on Experience
Fitment

Dice Job Match Score™

📊 Calculating match score...

Job Details

Skills

Summary

Oracle to PostgreSQL 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 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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10117909
  • Position Id: 26-08817
  • Posted 1 day ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Remote or Princeton, New Jersey

Yesterday

Easy Apply

Contract

50 - 55

New York, New York

6d ago

Easy Apply

Third Party, Contract

Depends on Experience

Montgomery, New Jersey

Today

Full-time

New York, New York

Today

Full-time

Search all similar jobs