PostgreSQL Migration Architect - Azure DB

CGS Federal (Contact Government Services); Arlington (VA); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Health, Dental, Vision

401k

Paid Time Off

Job summary

CGS Federal (Contact Government Services) is seeking a PostgreSQL Database Developer to support migration from Oracle to Azure PostgreSQL and to manage scalable PostgreSQL environments in a federal IT setting.

You will contribute to data solutions for government clients, ensure database availability, and collaborate with teams to translate complex objectives into concrete technical requirements.

Qualifications

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

Responsibilities

• Migrate from Oracle to Microsoft Azure PostgreSQL database.
• Create and maintain technical documentation using templates and deep knowledge of business data.
• Collaborate with internal and external parties to translate objectives into technical requirements.
• Ensure availability and performance of databases with adequate resources for high resilience and speed.
• Assist developers with performance tuning and proactive monitoring to minimize downtime.
• Maintain documentation and support rollouts, patching, and upgrades.
• Work within a structured and Agile development approach.

Skills

PostgreSQL

Linux

Performance tuning

Oracle to Postgres migration

Azure cloud

Agile

Education

Bachelor's degree

Tools

Ora2Pg

Azure

AWS RDS for PostgreSQL

Job description

CGS Federal (Contact Government Services) is seeking a PostgreSQL Database Developer to support migration from Oracle to Azure PostgreSQL and to manage scalable PostgreSQL environments in a federal IT setting.

You will contribute to data solutions for government clients, ensure database availability, and collaborate with teams to translate complex objectives into concrete technical requirements.