Oracle to PostgreSQL Migration Architect
Not Disclosed•ContractorOn-site
location_on602, Santa Catalina Terrace, Sunnyvale, Santa Clara County, California, 94085, United States
About the Role
We are seeking an Oracle to PostgreSQL Migration Architect to lead the technical strategy and execution of a critical database modernization initiative. This role is pivotal in transforming legacy Oracle environments into scalable, cloud-native PostgreSQL architectures, often leveraging AWS RDS/Aurora or Azure.
You will bridge the gap between complex legacy systems and modern infrastructure. Your mission involves not just converting data, but re-architecting the underlying logic. You will specialize in mapping Oracle PL/SQL to PL/pgSQL, optimizing performance for new storage engines, and ensuring zero-downtime transitions. This position requires a deep understanding of the customization done on existing systems using Java and Go Lang, ensuring that the new system mirrors the functionality and robustness of the old one.
Who We Are Looking For
This is a high-stakes role reserved for engineers with exceptional mastery of core computer science fundamentals. We require candidates who demonstrate excellence in Data Structures & Algorithms, System Design, and Cloud Computing, with a specific focus on Kubernetes. You must be comfortable navigating the nuances of microservices architectures and database security best practices.
Hiring Process
- Initial screening to assess technical depth and migration experience.
- Technical deep-dive focusing on system design and cloud architecture.
- Practical assessment of migration strategies and tooling expertise.
- Final interview with the engineering leadership team.
Equal Opportunity
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
Work location
Work model: On-site
602, Santa Catalina Terrace, Sunnyvale, Santa Clara County, California, 94085, United States
Sunnyvale, California
Key Responsibilities
- check_circleLead technical strategy and assessment for Oracle to PostgreSQL migration
- check_circleDesign scalable PostgreSQL schema architectures and convert Oracle PL/SQL to PL/pgSQL
- check_circlePerform data migrations using tools like AWS SCT/DMS, Ora2Pg, or pgloader
- check_circleTune PostgreSQL performance through indexing and query optimization
- check_circleResolve complex data type mismatches and handle replication issues during migration
- check_circleEvaluate existing Oracle environments to plan migration roadmaps and TCO analysis
Requirements
- verified10+ years Oracle Database Administration experience
- verified3+ years Oracle-to-PostgreSQL migration experience
- verifiedProficiency in Data Structures & Algorithms
- verifiedProficiency in System Design
- verifiedProficiency in Cloud computing (Kubernetes)
- verifiedProficiency in Oracle PL/SQL
- verifiedProficiency in PostgreSQL PL/pgSQL
- verifiedExperience with AWS SCT/DMS or Ora2Pg
- verifiedKnowledge of AWS RDS/Aurora or Azure
- verifiedProficiency in Python, Bash, or Perl
Similar Job Opportunities
Frequently asked questions about Oracle to PostgreSQL Migration Architect at Tanisha Systems, Inc
What does a Oracle to PostgreSQL Migration Architect at Tanisha Systems, Inc do?expand_more
Day-to-day, the Oracle to PostgreSQL Migration Architect at Tanisha Systems, Inc will lead technical strategy and assessment for oracle to postgresql migration; design scalable postgresql schema architectures and convert oracle pl/sql to pl/pgsql; perform data migrations using tools like aws sct/dms, ora2pg, or pgloader; and tune postgresql performance through indexing and query optimization.
What are the requirements for this Oracle to PostgreSQL Migration Architect role?expand_more
To qualify for the Oracle to PostgreSQL Migration Architect at Tanisha Systems, Inc position, applicants should have: 10+ years Oracle Database Administration experience; 3+ years Oracle-to-PostgreSQL migration experience; Proficiency in Data Structures & Algorithms; Proficiency in System Design; Proficiency in Cloud computing (Kubernetes); and Proficiency in Oracle PL/SQL.
Where is the Oracle to PostgreSQL Migration Architect role at Tanisha Systems, Inc located?expand_more
Oracle to PostgreSQL Migration Architect at Tanisha Systems, Inc is based in 602, Santa Catalina Terrace, Sunnyvale, Santa Clara County, California, 94085, United States. This is a on-site role.
Is this Oracle to PostgreSQL Migration Architect job remote, hybrid, or on-site?expand_more
Tanisha Systems, Inc has listed this Oracle to PostgreSQL Migration Architect role as on-site.
How much experience is required for this Oracle to PostgreSQL Migration Architect role?expand_more
Oracle to PostgreSQL Migration Architect at Tanisha Systems, Inc typically requires 10+ years of relevant experience at the lead level.
What skills do you need for the Oracle to PostgreSQL Migration Architect role at Tanisha Systems, Inc?expand_more
Key skills for Oracle to PostgreSQL Migration Architect at Tanisha Systems, Inc include Java; Go Lang; Data Structure & Algorithms; System Design; Cloud Computing; Kube; Oracle; and Postgresql.
What category does the Oracle to PostgreSQL Migration Architect role belong to?expand_more
Oracle to PostgreSQL Migration Architect at Tanisha Systems, Inc is part of the it job category on Recrutus.