Oracle to PostgreSQL Migration Architect
Programmers.io
About the Company
At Programmers.IO, We help a global IT services and software development company specializing in application modernization, AI enablement, and legacy system support. We are growing fast and looking for a passionate Oracle to PostgreSQL Migration Architect with our Client is Wipro and location is Sunnyvale, CA(Onsite). The managers are working fast and looking forward to having a successful candidate on board at the earliest.
Title:-Oracle to PostgreSQL Migration Architect
Location:- Sunnyvale, CA(Onsite)
Type:- Contract/FTE(Both)
About the Role
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 Experience:-
Pls look for Strong Python Coder having experience in creating Microservices on database and you can have any database migration.
- 10+ years of hands-on experience in Oracle Database Administration, with 3+ years specifically in Oracle-to-PostgreSQL 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.
PKey Skills for Success
- Understanding of microservices architecture.
- Database security best practices.
- Excellent communication and stakeholder management skills.
Thanks!
Vishal Tyagi
View email address on click.appcast.io
Direct Number: View phone number on click.appcast.io Extension Number: 472
Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Oracle to PostgreSQL Migration Architect in Sunnyvale, CA vacancy
$80k - $173.8k
Wipro Technologies is seeking an Oracle to PostgreSQL Migration Architect in Sunnyvale, California. This role involves designing secure PostgreSQL architectures, converting PL/SQL to PL/pgSQL, and performing data migrations. Candidates should have over 10 years of experience...PostgresqlOracle$80k - $173.8k
Oracle to PostgreSQL Migration Architect City: Sunnyvale, State/Province: California. Responsibilities Design scalable, secure PostgreSQL schema architectures, converting Oracle PL/SQL stored procedures, triggers, views, and packages to PL/pgSQL. Perform data migrations...PostgresqlOracleLocal area- ...Hi we are hiring for an Oracle Cloud Supply Chain Accounting & Project Costing Lead / Architect located in Bay Area, CA please go through the job description and reply... ...recommendations. Support integrations, data migration, reporting, and reconciliations. Coordinate...Oracle
Kastech
Sunnyvale, CA4 days ago - ...SAP Architect SAP Architecture and SAP HANA Deployment, Basis Administration/Security, OS/ DB migrations and technical core competencies tasks including SAP applications, SAP HANA and Oracle software installation and configuration, upgrade, applying Support Packages...OracleRemote work
Georgia IT Inc
Mountain View, CA3 days ago - ...any testing tools ~ Good Understanding of various database technologies(DB2,Teradata, Oracle 10g/11g,SQL server, Big data/Hadoop, PostgreSQL) ~ Experience in testing Cloud migration applications (MS Azure, AWS, Snowflake) based testing ~ Good exposure in executing...PostgresqlOracleRemote work
Omega Solutions
Santa Clara, CA3 days ago $151k - $204.3k
...support implementation projects in order to migrate customer environments to AWS cloud based... ...-premises database environments such as Oracle, SQL Server, or other Commercial DB Engines to Open-Source Engines like Aurora PostgreSQL/MySQL or RedShift, DynamoDB. 6.Work with...PostgresqlOracleLocal areaRemote workFlexible hoursAmazon.com Inc
Mountain View, CA4 days ago$150k - $180k
...AI-ready, multi-modal, distributed PostgreSQL database for cloud-native apps.... ...the world's leading enterprises are migrating from legacy RDBMSs (like Oracle, SQL Server, and DB2) to YugabyteDB... ...SQL. Responsibilities: Architect, develop and maintain test automation...PostgresqlOracleWork at officeLocal areaWorldwideFlexible hours2 days per week3 days per weekYugaByte
Sunnyvale, CA1 day ago- ...PostgreSQL Consultant Location: San Jose, CA Type of Hire: FTE/CWR Basic Qualifications: Experience in migration from Oracle to PostgreSQL. Experience with Ora2Pg tool. Experience in procedure writing for PostgreSQL. Founded in 2007, InterSources...PostgresqlOracle
InterSources
San Jose, CA1 day ago - ...CloudWatch CloudFormation PL/SQL Experience Strong Oracle Db Experience Experience in writing SQL queries Experience... ...infrastructure, user issues, platform updates Competencies: PostgreSQL Experience (Years): 10 & Above Regarding: Ashutosh Pasbola...PostgresqlOracleContract work
Syntricate Technologies
Sunnyvale, CA1 day ago - ...Job Title: Senior Workato Integration Architect (MCP & AI exp) Location: Palo... ...Boomi, MCP (Model Context Protocol), SQL (PostgreSQL/MySQL), JSON/XML Key... ...Responsibilities 1. Workato Implementation & Migration (Boomi Replacement) Lead the...PostgresqlLong term contract
Inficare
Palo Alto, CA4 days ago - b2bnetwork is seeking a PostgreSQL DBA in Mountain View, California. This role involves migrating PostgreSQL databases to Google Cloud while ensuring performance and optimization. The ideal candidate has strong hands-on experience with PostgreSQL, cloud environments, and...Postgresql
- ...Mongo DB Architect Sonsoft, Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc... ...Spring Framework, Rest/Json, Cassandra, MongoDB, MS SQL Server, Oracle, MySQL, Memcached, and Redis. ~ Demonstrated ability to...OracleFull time
SonSoft
Sunnyvale, CA11 days ago - ...environment • Strong hands-on development experience and proficiency in JAVA/ Kotlin • Expertise in databases like MongoDB/ MySQL/ PostgreSQL/ Oracle/ etc. • Expertise in application frameworks like Spring Boot/ NestJS/ etc. • Must have an In-depth understanding of SOA/...PostgresqlOracle
E-Solutions
Mountain View, CA20 hours ago - ...Title :Boomi Architect Location: Santa Clara, CA (100% Onsite) Experience 6-8 years of overall integration experience 5+ years... ...messaging/streaming technologies: Kafka, JMS (ActiveMQ, MQSeries, Oracle AQ, etc.) Experience integrating with Salesforce, Workday,...Oracle
Yantran LLC
Santa Clara, CA1 day ago - ...implement, and maintain complex SQL queries, stored procedures, triggers, and functions to interact with relational databases (Oracle, PostgreSQL, etc.). Optimize database performance and ensure data integrity. Python Programming: Develop and maintain Python-based...PostgresqlOracle
Rootshell Inc
Santa Clara, CA1 day ago - ...technology recruiting firm seeks a Senior Database Solutions Architect to lead the design and operation of cloud-native database platforms... .... The role necessitates hands-on experience with HA MariaDB/PostgreSQL and cloud environments. This position is highly independent,...PostgresqlRemote work
Red Oak Technologies
Mountain View, CA9 days ago - Job Posting Fulltime Only, Please submit all resumes in below format with "candidate evaluation sheet" for consideration. Taleo - Name of the Candidate - Skills - Vendor - Current Location - Current Organization - Current Rate - Expected Salary - Contact Number -...OracleFull time
ClifyX
Sunnyvale, CA1 day ago - ...Hadoop Architect Sonsoft, Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc.... ...Data Modeling in the DW environment (dimensional modeling) and Oracle and SQL server with hands on experience on playing data architect...Oracle
SonSoft
Sunnyvale, CA1 day ago - ...Experience designing and implementing RESTful APIs and microservices Hands-on experience with relational databases such as Oracle and PostgreSQL Experience with NoSQL databases such as Cassandra Strong analytical and problem-solving skills with attention to...PostgresqlOracle
Prophecy Technologies
Sunnyvale, CA1 day ago $120k - $130k
...CTG is seeking an experienced Data Architect - Data Modernization, Snowflake to lead... ...architecting and delivering scalable cloud-based migration solutions leveraging Snowflake,... ...strategies involving: Oracle to PostgreSQL Oracle to SQL Server Relational...PostgresqlOracleLocal areaCTG, Inc.
San Jose, CA4 days ago$70 per hour
...Spring Spring Boot JPA Hibernate REST APIs OAuth Access Management SSO Node.js Oracle RDBMS PostgreSQL Elastic Search Please provide answers to the qualifying questions below How many yrs of...PostgresqlOracle3B Staffing LLC
Mountain View, CA4 days ago- ...modern front-end frameworks such as React, Angular, or Vue.js. Databases: Proficient in relational databases like MySQL, PostgreSQL, or Oracle. Experience with NoSQL databases is a plus. Tools and Technologies: Familiarity with version control systems (e.g., Git),...PostgresqlOracleWork experience placement
Kasmo Global
Cupertino, CA20 hours ago - ...TypeScript ~ Deep understanding of TypeScript, modern JavaScript (ES6+), HTML5, and CSS ~ Experience with SQL databases (PostgreSQL, MySQL, Oracle). ~ Experience with NoSQL databases (MongoDB, Redis, DynamoDB). ~ Experience building cloud-native applications...PostgresqlOracleContract work
VBeyond
Mountain View, CA2 days ago - ...: Experience in .Net framework architecture, SLQ Server with 12 years of relevant experience as Architect. Desirable skills are LifeRay, Adobe, Salesforce, Java and Oracle. B2B Architect: Minimum 10 years of experience ~ Working knowledge of .Net framework, SLQ...Oracle
Omni Inclusive
Santa Clara, CA20 hours ago - ...Principal Platform Architect San Jose, California, United States Archer is an aerospace... ...a portable data architecture using PostgreSQL, including schema evolution and... ...design, indexing, performance tuning, migrations) ~ Experience designing canonical data...PostgresqlLocal area
Archer
San Jose, CA4 days ago - ...areas for MPP DB Work with a team of architects and engineers to develop proof-of-concept... ...theory a plus Experience with PostgreSQL kernel a plus Must be a team player... ...Coding Software development If they work for Oracle, IBM, SAP they are database companies than...PostgresqlOracleContract workImmediate start
Careers Integrated Resources Inc
Santa Clara, CA1 day ago - ...of object oriented programming principles and design patterns. Proficient in database management systems (e.g., MySQL, Oracle, PostgreSQL). Experience with RESTful APIs and web services. Familiarity with version control systems (e.g., Git). Strong...PostgresqlOracle
Diverse Lynx
Santa Clara, CA4 days ago - ...experience. Programming experience in Python Experience with at least one relational database technology such as MySQL, PostgreSQL, Oracle, or MS SQL. Deep hands-on technical expertise in development, preferably full-stack. Good data-processing and testing...PostgresqlOracleWork at office
Samprasoft
Sunnyvale, CA2 days ago $140k - $150k
...every day? Join us at Qualitest! We are looking for a Business Architect to join our growing team in United States! Required Skills &... ...tools such as C#, .NET, PL/SQL, and database platforms like Oracle and MS SQL Server. * Demonstrated ability to lead ambiguity reviews...OracleCasual workLocal areaFlexible hoursQ Analysts
Santa Clara, CA1 day ago$120k - $130k
...initiatives across enterprise environments. Design and implement scalable ETL and data migration solutions. Architect data pipelines and modernization strategies involving: Oracle to PostgreSQL Oracle to SQL Server Relational to NoSQL migrations Data Warehouse to Data...PostgresqlOracleLocal area
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Oracle to PostgreSQL Migration Architect. Be the first to apply!
Related searches