ZipRecruiter

Log In

1

Oracle To Aurora Postgresql Migration Jobs (NOW HIRING)

Leidos

PostgreSQL Database Administrator

Ashburn, VA

$107K - $195K/yr

Migration of Oracle to Aurora PostgreSQL with over 70TB migrating from Oracle to Aurora * Experience using Generative AI to tune SQL statements * Experience with CBP * Java Experience * Experience ...

Leidos

PostgreSQL Database Administrator

Ashburn, VA · On-site

$107K - $195K/yr

Migration of Oracle to Aurora PostgreSQL with over 70TB migrating from Oracle to Aurora * Experience using Generative AI to tune SQL statements * Experience with CBP * Java Experience * Experience ...

Quest Oracle Community

$107K - $195K/yr

Migration of Oracle to Aurora PostgreSQL with over 70TB migrating from Oracle to Aurora * Experience using Generative AI to tune SQL statements * Experience with CBP * Java Experience * Experience ...

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 ...

Dynamo Technologies LLC

Hands‑on experience with Ora2Pg (the customer‑approved Oracle-to-PostgreSQL migration tool for this environment) or a comparable Oracle-to-PostgreSQL migration toolset, including experience with ...

Wise Skulls

PostgreSQL DBA

Irvine, CA · On-site

... DB migration. * Experienced PostgreSQL Developer DBA with expertise in Oracle/SQL Server to ... Strong hands-on experience in AWS Aurora PostgreSQL, RDS PostgreSQL, AWS SCT, AWS DMS (Full Load ...

next page

Showing results 1-20

All JobsTechnology JobsOracle To Aurora Postgresql Migration Jobs

Oracle To Aurora Postgresql Migration information

See salary details

$12

$68

$88

How much do oracle to aurora postgresql migration jobs pay per hour?

As of Sep 11, 2026, the average hourly pay for oracle to aurora postgresql migration in the United States is $68.72, according to ZipRecruiter salary data. Most workers in this role earn between $61.06 and $76.92 per hour, depending on experience, location, and employer.

What is Oracle to Aurora PostgreSQL migration?

Oracle to Aurora PostgreSQL migration refers to the process of moving databases, applications, and workloads from Oracle Database to Amazon Aurora with PostgreSQL compatibility. This migration involves converting database schemas, data, and application code to ensure compatibility with PostgreSQL. The goal is often to reduce licensing costs, improve scalability, and leverage managed services offered by AWS. Successful migration requires careful planning, assessment of application dependencies, and thorough testing to minimize downtime and ensure data integrity.

What are the key skills and qualifications needed to thrive as an Oracle to Aurora PostgreSQL migration specialist, and why are they important?

Success in this role requires deep expertise in Oracle and PostgreSQL database administration, SQL scripting, and data migration strategies, often supported by a degree in computer science or a related field. Familiarity with AWS services (especially RDS and Aurora), migration tools like AWS Database Migration Service (DMS), and relevant certifications such as AWS Certified Database – Specialty are commonly expected. Strong problem-solving skills, attention to detail, and clear communication are vital for addressing migration challenges and collaborating with stakeholders. These abilities ensure smooth, efficient migrations with minimal downtime and data integrity, which are critical for business continuity.

What are some challenges I might face when migrating databases from Oracle to Aurora PostgreSQL, and how can I prepare for them?

Migrating from Oracle to Aurora PostgreSQL often involves addressing differences in data types, SQL syntax, and stored procedures, which can lead to compatibility issues. You may also encounter challenges with schema conversion, application rewrites, and ensuring minimal downtime during migration. To prepare, it's helpful to use AWS Schema Conversion Tool (SCT) and Database Migration Service (DMS), thoroughly test your migration in a staging environment, and collaborate closely with both application developers and DBAs. Building a detailed migration plan and involving stakeholders early will greatly increase your chances of a smooth transition.

What is the difference between Oracle To Aurora Postgresql Migration vs Database Migration Engineer?

AspectOracle To Aurora Postgresql MigrationDatabase Migration Engineer
Primary FocusMigrating databases from Oracle to Amazon Aurora PostgreSQLPlanning and executing various database migrations across platforms
Skills & CertificationsOracle certifications, AWS certifications, SQL, PostgreSQLDatabase certifications (e.g., Oracle, Microsoft, AWS), SQL, scripting
Work EnvironmentCloud environments, enterprise data centers, AWS cloudData centers, cloud platforms, client sites
Industry UsageFinance, healthcare, retail with cloud migration needsVarious industries requiring database upgrades or migrations

While both roles involve database migration, Oracle To Aurora Postgresql Migration specialists focus specifically on transitioning Oracle databases to Amazon Aurora PostgreSQL, often requiring AWS expertise. Database Migration Engineers have broader responsibilities, handling diverse migration projects across different database systems and environments.

What other helpful pages are available for Oracle To Aurora Postgresql Migration?

Other pages related to Oracle To Aurora Postgresql Migration:

Infographic showing various Oracle To Aurora Postgresql Migration job openings in the United States as of September 2026, with employment types broken down into 100% Full Time. Highlights an 67% In-person, and 33% Hybrid job distribution, with an average salary of $142,947 per year, or $68.7 per hour.

Oracle to PostgreSQL Migration Consultant

Austin, TX • On-site

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

Other

Re-posted 18 hours 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.

Apply