ZipRecruiter

Log In

1

Aws Postgresql Migration Oracle Jobs (NOW HIRING)

Dynamo Technologies LLC

$125 - $150/hr

The Oracle Database Migration Specialist will support assessment, planning, and execution of Oracle ... PostgreSQL, Microsoft SQL Server, Azure SQL Database, AWS RDS. * Experience with AWS Schema ...

Info Way Solutions

PostgreSQL Developer DBA

Irvine, CA · On-site

$53.75 - $67/hr

... migration , particularly migrating Oracle and SQL Server databases to PostgreSQL . The ideal candidate will have strong experience with AWS PostgreSQL environments, database migration tools, PL/pgSQL ...

InterSources Inc

PostgreSQL Developer

San Jose, CA · On-site

$61.50 - $79.50/hr

They are seeking a PostgreSQL Developer with Java experience to assist in Oracle to PostgreSQL migration. Responsibilities : • PostgreSQL developer with Java experience who has done Oracle to PG ...

System One

Sr. AWS Cloud/Software Architect III

Washington, DC · Remote

$66.25 - $87/hr

Drive architecture, design, development, and migration of on-prem legacy applications to AWS cloud ... Experience designing and developing database systems with RDBMS including Oracle, PostgreSQL, MySQL ...

System One

Sr. AWS Cloud/Software Architect III

Washington, DC · Remote

$66.25 - $87/hr

Drive architecture, design, development, and migration of on-prem legacy applications to AWS cloud ... Experience designing and developing database systems with RDBMS including Oracle, PostgreSQL, MySQL ...

System One

Sr. AWS Cloud/Software Architect III

Washington, DC · Remote

$66.25 - $87/hr

Drive architecture, design, development, and migration of on-prem legacy applications to AWS cloud ... Experience designing and developing database systems with RDBMS including Oracle, PostgreSQL, MySQL ...

System One

Sr. AWS Cloud/Software Architect III

Washington, DC · Remote

$66.25 - $87/hr

Drive architecture, design, development, and migration of on-prem legacy applications to AWS cloud ... Experience designing and developing database systems with RDBMS including Oracle, PostgreSQL, MySQL ...

System One

Sr. AWS Cloud/Software Architect III

Washington, DC · Remote

$66.25 - $87/hr

Drive architecture, design, development, and migration of on-prem legacy applications to AWS cloud ... Experience designing and developing database systems with RDBMS including Oracle, PostgreSQL, MySQL ...

System One

Sr. AWS Cloud/Software Architect III

Washington, DC · Remote

$66.25 - $87/hr

Drive architecture, design, development, and migration of on-prem legacy applications to AWS cloud ... Experience designing and developing database systems with RDBMS including Oracle, PostgreSQL, MySQL ...

System One

Sr. AWS Cloud/Software Architect III

Washington, DC · Remote

$66.25 - $87/hr

Drive architecture, design, development, and migration of on-prem legacy applications to AWS cloud ... Experience designing and developing database systems with RDBMS including Oracle, PostgreSQL, MySQL ...

System One

Sr. AWS Cloud/Software Architect III

Washington, DC · Remote

$66.25 - $87/hr

Drive architecture, design, development, and migration of on-prem legacy applications to AWS cloud ... Experience designing and developing database systems with RDBMS including Oracle, PostgreSQL, MySQL ...

next page

Showing results 1-20

All JobsTechnology JobsAWS Postgresql Migration Oracle Jobs

Aws Postgresql Migration Oracle information

See salary details

$21K

$136.2K

$177.5K

How much do aws postgresql migration oracle jobs pay per year?

As of Sep 9, 2026, the average yearly pay for aws postgresql migration oracle in the United States is $136,232.00, according to ZipRecruiter salary data. Most workers in this role earn between $128,000.00 and $144,500.00 per year, depending on experience, location, and employer.

What does an AWS PostgreSQL migration specialist from Oracle do?

An AWS PostgreSQL migration specialist from Oracle is responsible for moving databases and applications from Oracle databases to PostgreSQL databases hosted on Amazon Web Services (AWS). This role involves assessing the current Oracle environment, planning and executing the migration strategy, converting database schemas and data, and ensuring minimal downtime. The specialist also troubleshoots compatibility issues and optimizes the new PostgreSQL environment for performance and security. Their expertise helps organizations take advantage of cost savings, scalability, and cloud-native features offered by AWS and PostgreSQL.

What are the key skills and qualifications needed to thrive as an AWS PostgreSQL migration Oracle specialist?

To thrive as an AWS PostgreSQL Migration Oracle specialist, you need expertise in Oracle and PostgreSQL database administration, strong SQL skills, and experience with cloud migration strategies, typically supported by a degree in computer science or related certifications. Familiarity with AWS Database Migration Service (DMS), schema conversion tools, and cloud management consoles is crucial. Problem-solving, attention to detail, and effective communication help ensure seamless migrations and collaboration with stakeholders. These skills are essential for minimizing downtime, ensuring data integrity, and delivering successful cloud transitions.

What are some common challenges faced during AWS PostgreSQL migration from Oracle, and how can they be addressed?

Migrating from Oracle to PostgreSQL on AWS often involves challenges such as data type mismatches, differences in stored procedures, and ensuring minimal downtime. Addressing these requires thorough pre-migration assessment, using tools like AWS Schema Conversion Tool (SCT) and Database Migration Service (DMS) to automate much of the conversion and transfer processes. Close collaboration with application developers and DBAs is essential to resolve compatibility issues and test application behavior post-migration. Regular validation and performance tuning after migration help ensure a smooth transition.

What is the difference between Aws Postgresql Migration Oracle vs Database Administrator?

AspectAws Postgresql Migration OracleDatabase Administrator
CertificationsAWS certifications, Oracle certifications, PostgreSQL expertiseOracle Certified Professional, Microsoft Certified: Database Administrator, or similar
Work EnvironmentCloud platforms, migration projects, database setup and optimizationOn-premises or cloud environments, database management and maintenance
Industry UsageTech, finance, healthcare, any industry migrating or managing databasesAll industries requiring database management and support
Search & Comparison IntentFocus on migration skills, cloud expertise, Oracle and PostgreSQL knowledgeFocus on database management, support, and optimization skills

In summary, Aws Postgresql Migration Oracle specialists focus on migrating databases to cloud platforms, combining cloud and database skills, while Database Administrators manage and maintain databases across various environments. Both roles require strong technical knowledge but differ in scope and focus.

What other helpful pages are available for Aws Postgresql Migration Oracle?

Other pages related to Aws Postgresql Migration Oracle:

Infographic showing various Aws Postgresql Migration Oracle job openings in the United States as of September 2026, with employment types broken down into 92% Full Time, 2% Part Time, and 6% Contract. Highlights an 74% Physical, 6% Hybrid, and 20% Remote job distribution, with an average salary of $136,232 per year, or $65.5 per hour.

Oracle to PostgreSQL Migration Consultant

Austin, TX • On-site

Tanisha Systems
1 - 5K employees
Learn more about Tanisha Systemsexternal

Full-time

Posted 28 days ago

Job description

Oracle to PostgreSQL Migration Consultant
Location: Sunnyvale, CA/ Austin, TX (Onsite)
FTE/Fulltime
Salary : Market- based on exp
Rate: Market- based on exp
CANDIDATE SHOULD HAVE PYTHON CODING EXPERIENCE AND ORACLE TO POSTGRESQL MIGRATION EXPERIENCE
Job Description

We are seeking an experienced Data Engineer with proven, hands-on expertise in migrating enterprise database workloads from

Oracle to PostgreSQ

L. The ideal candidate will lead/support

end-to-end migration

activities including assessment, schema conversion, data migration, application compatibility, performance tuning, and cutover planning.


Key Responsibilities
  • Assess existing Oracle databases (schema, PL/SQL objects, indexes, partitioning, triggers, jobs) to determine migration complexity and approach.
  • Perform schema and object conversion from Oracle to PostgreSQL using tools such as AWS SCT/DMS, Ora2Pg, EDB Migration Toolkit, or custom scripts.
  • Convert PL/SQL procedures, functions, triggers, and packages to PostgreSQL PL/pgSQL, resolving syntax and behavioral differences.
  • Design and execute data migration/validation strategies (full load, incremental/CDC, reconciliation) ensuring zero/minimal data loss.
  • Identify and remediate incompatibilities (data types, sequences, materialized views, partitioning strategies, error handling, connection pooling).
  • Optimize PostgreSQL performance post-migration (indexing strategy, query tuning, vacuum/autovacuum, connection pooling via PgBouncer, partitioning).
  • Collaborate with application teams to update SQL queries, ORM configurations, and connection strings/drivers (JDBC/ODBC/psycopg2).
  • Plan and execute cutover strategy including rollback plans, downtime minimization, and go-live support.
  • Document migration runbooks, technical decisions, and lessons learned.

Required Skills & Experience
  • 5+ years of overall database engineering/DBA experience; 3+ years hands-on with Oracle-to-PostgreSQL migration projects (not just theoretical knowledge).
  • Strong command of Oracle (PL/SQL, RMAN, Data Pump, performance tuning) and PostgreSQL (PL/pgSQL, extensions, vacuum internals, replication).
  • Practical experience with migration tools: Ora2Pg, AWS SCT, AWS DMS, EDB Postgres Migration Toolkit, Google DMS, or equivalent.
  • Solid understanding of differences between Oracle and PostgreSQL (sequences, ROWID vs CTID, NVL vs COALESCE, hierarchical queries CONNECT BY vs recursive CTEs, autonomous transactions, packages, etc.).
  • Experience with data validation/reconciliation frameworks to ensure migration accuracy.
  • Familiarity with cloud database services (AWS RDS/Aurora PostgreSQL, Azure, GCP Cloud SQL) is a plus.
  • Scripting skills in Shell, Python for automation of migration tasks.
  • Experience with CI/CD pipelines and version control (Git) for schema/code management.
  • Strong problem-solving skills and ability to work with minimal supervision on complex legacy systems.