Senior PostgreSQL DB Developer for Data Analytics Platform

CGS Federal; United States; On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Health, Dental, and Vision

401k

Flexible Spending Account (Health, Dep

Paid Time Off and Holidays

Job summary

CGS Federal is seeking a PostgreSQL Database Developer to support a migration from Oracle to Microsoft Azure PostgreSQL and to manage scalable data environments for a federal analytics platform.

You will ensure high availability, performance, and secure services while collaborating in an Agile development setting. A Bachelor's degree and 7+ years of Linux PostgreSQL experience are required, along with US citizenship.

Qualifications

• Bachelor's degree or higher in a related field.
• 7+ years in administering PostgreSQL databases on Linux.
• Experience migrating Oracle schemas to PostgreSQL using Ora2Pg.
• Ability to set up backups, DR, and high availability.

Responsibilities

• Migrate from Oracle to Microsoft Azure PostgreSQL and ensure high availability.
• Create and maintain technical documentation using templates.
• Collaborate with internal/external teams to translate objectives into requirements.
• Monitor, tune, and maintain database performance and security.

Skills

Oracle to Postgres migration

PostgreSQL performance tuning

Database performance monitoring

Documentation of technical solutions

Agile development practices

Azure PostgreSQL management

Linux database administration

Education

Bachelor's degree

Tools

Ora2Pg

PostgreSQL

Linux

Job description

CGS Federal is seeking a PostgreSQL Database Developer to support a migration from Oracle to Microsoft Azure PostgreSQL and to manage scalable data environments for a federal analytics platform.

You will ensure high availability, performance, and secure services while collaborating in an Agile development setting. A Bachelor's degree and 7+ years of Linux PostgreSQL experience are required, along with US citizenship.