Azure PostgreSQL Migration Lead for Data Analytics Platform

CGS Federal (Contact Government Services); Massachusetts; On-site; USD 106,773 - 144,907; Full time

Benefits offered by this job

Health, Dental, Vision

Job summary

CGS Federal (Contact Government Services) seeks a PostgreSQL Database Developer to join the IT team. The role focuses on migrating from Oracle to Azure PostgreSQL, maintaining scalable database environments, and ensuring high availability.

You will work across our data analytics platform to deliver reliable data solutions for federal customers. The ideal candidate has extensive PostgreSQL experience on Linux, plus Oracle migration skills.

Qualifications

• Bachelor's degree required.
• U.S. Citizenship required.
• 7+ years of PostgreSQL administration in Linux environments.
• Experience setting up, monitoring, and maintaining PostgreSQL instances.
• Experience with backup and disaster recovery for PostgreSQL.
• 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 knowledge of business data.
• Collaborate with internal and external parties to translate objectives into requirements.
• Ensure availability and performance of databases supporting systems.
• Assist developers with performance tuning.
• Monitor databases for security, downtime and maintenance (patching, upgrades).
• Work within an Agile development approach.

Skills

Oracle to PostgreSQL migration

PostgreSQL administration

Linux

Performance tuning

Documentation

Agile development

Database security

Education

Bachelor's degree

Tools

Ora2Pg

Azure

AWS (RDS for PostgreSQL)

Job description

CGS Federal (Contact Government Services) seeks a PostgreSQL Database Developer to join the IT team. The role focuses on migrating from Oracle to Azure PostgreSQL, maintaining scalable database environments, and ensuring high availability.

You will work across our data analytics platform to deliver reliable data solutions for federal customers. The ideal candidate has extensive PostgreSQL experience on Linux, plus Oracle migration skills.