What are the responsibilities and job description for the Oracle to PostgreSQL Migration Architect position at MPower Plus?
Job Description: Oracle to PostgreSQL Migration Architect
We are looking for a highly skilled software engineering professional with strong expertise in Java and/or Go, excellent knowledge of Data Structures & Algorithms, System Design, and Cloud-native architecture (especially Kubernetes). The candidate must be able to understand existing system customizations and rebuild equivalent solutions in modern cloud environments.
This role focuses on leading Oracle to PostgreSQL migration initiatives, including architecture design, schema conversion, performance optimization, and ensuring zero/low-downtime migrations.
Key Responsibilities
- Define migration strategy and roadmap for Oracle to PostgreSQL conversion, including dependency analysis and TCO assessment
- Design and implement scalable PostgreSQL architectures (AWS RDS/Aurora or Azure PostgreSQL)
- Convert Oracle PL/SQL (procedures, triggers, packages, views) to PostgreSQL PL/pgSQL
- Execute data migration using AWS SCT, AWS DMS, Ora2Pg, or pgloader
- Optimize query performance, indexing, and database tuning in PostgreSQL
- Handle complex migration issues including data type mismatches and replication challenges
- Collaborate with engineering teams to modernize legacy systems into cloud-native architecture
Required Skills
- Strong experience in Java and/or Go Lang
- Excellent knowledge of Data Structures, Algorithms, and System Design
- Strong experience in Oracle (PL/SQL, performance tuning)
- Deep expertise in PostgreSQL (PL/pgSQL, internals, optimization)
- Hands-on experience with AWS or Azure cloud platforms
- Experience with migration tools: AWS SCT, AWS DMS, Ora2Pg, pgloader
- Good understanding of Kubernetes, Docker, and cloud-native systems
- Scripting experience in Python, Bash, or Perl
Required Experience
- 10 years of overall IT experience
- Minimum 3 years of hands-on Oracle to PostgreSQL migration experience
Good to Have
- Microservices architecture experience
- CI/CD pipelines and DevOps exposure
- Experience in distributed systems and high-performance architectures
- Strong communication and stakeholder management skills