PostgreSQL Database Engineer - Oracle-to-Postgres Migration

CGS Federal

Chicago (IL)

On-site

USD 110,000 - 160,000

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (Health, Dep

endent Care, and Commuter)

Job summary

CGS Federal in Chicago seeks a PostgreSQL Database Developer to support a migration from Oracle to Postgres on Microsoft Azure. You will manage database environments, ensure high availability, and optimize performance for a growing Data Analytics platform serving federal customers.

The role requires 7+ years of PostgreSQL administration on Linux, Oracle-to-Postgres migration with Ora2Pg, and experience with cloud services like AWS/Azure; you will create documentation and collaborate in an Agile

Qualifications

Bachelor's degree required.
7+ years of PostgreSQL administration in Linux environments.
Experience setting up, monitoring, and maintaining PostgreSQL instances.
Experience with PostgreSQL backup and disaster recovery processes.
Experience migrating Oracle schema, packages, views, triggers to Postgres using Ora2Pg.

Responsibilities

Migrate from Oracle to Azure PostgreSQL and ensure migration integrity.
Create and maintain technical documentation using templates and analyze business data.
Collaborate with internal/external teams to translate objectives into technical requirements.
Ensure availability and performance of databases supporting critical systems.
Perform and assist in database performance tuning and optimization.
Proactively monitor databases for security, downtime, and smooth rollouts/patching.