Azure PostgreSQL DB Developer – Oracle Migration

CGS Federal; Philadelphia (Philadelphia County); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (Health, Dep

endent Care, and Commuter)

Paid Time Off and Holidays

Job summary

CGS Federal is seeking a PostgreSQL Database Developer to join our IT team supporting a federal data analytics and BI platform. You will lead a migration from Oracle to Postgres on Microsoft Azure and manage database environments for scalability and reliability.

You will create technical documentation, collaborate with stakeholders, ensure high availability, perform tuning, and support patching and upgrades in an Agile setting.

Qualifications

• Bachelor's degree in a relevant field.
• US Citizenship 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 schemas to Postgres using Ora2Pg.

Responsibilities

• Migrate from Oracle to Microsoft Azure Postgres database.
• Create and maintain technical documentation using templates.
• Collaborate with internal and external parties to translate objectives into requirements.
• Ensure the availability and performance of databases with high resilience.
• Perform and assist developers in performance tuning.
• Proactively monitor the database systems to minimize downtime.
• Work within a structured Agile development approach.

Skills

PostgreSQL administration

Linux

Performance tuning

Agile development

Technical documentation

Data migrations

Azure/AWS cloud

Education

Bachelor's degree

Tools

Ora2Pg

Azure

AWS RDS for PostgreSQL

Job description

CGS Federal is seeking a PostgreSQL Database Developer to join our IT team supporting a federal data analytics and BI platform. You will lead a migration from Oracle to Postgres on Microsoft Azure and manage database environments for scalability and reliability.

You will create technical documentation, collaborate with stakeholders, ensure high availability, perform tuning, and support patching and upgrades in an Agile setting.