Oracle-to-Postgres Migration & Performance Engineer

CGS Federal (Contact Government Services); Philadelphia (Philadelphia County); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account

Paid Time Off

Job summary

A government services consulting firm is seeking a PostgreSQL Database Developer to support a growing Data Analytics platform. Responsibilities include migrating from Oracle to Postgres, ensuring database performance and documentation. Candidates should possess a Bachelor’s degree and at least 7 years of experience with PostgreSQL in Linux environments. Ideal applicants have cloud experience and familiarity with AWS RDS, making this role vital to government innovation and collaboration.

Qualifications

• 7 years of experience with PostgreSQL databases in Linux environments.
• Experience with database backup and disaster recovery processes.
• Experience migrating Oracle schemas to PostgreSQL using Ora2Pg tool.

Responsibilities

• Migrate from Oracle database to Microsoft Azure Postgres database.
• Create and maintain technical documentation.
• Collaborate on technical requirements and solutions.

Skills

PostgreSQL Database Administration

Linux Environments

Database Migration

AWS RDS

Ora2Pg Tool

Education

Bachelor's degree

Job description

A government services consulting firm is seeking a PostgreSQL Database Developer to support a growing Data Analytics platform. Responsibilities include migrating from Oracle to Postgres, ensuring database performance and documentation. Candidates should possess a Bachelor’s degree and at least 7 years of experience with PostgreSQL in Linux environments. Ideal applicants have cloud experience and familiarity with AWS RDS, making this role vital to government innovation and collaboration.