Skip to main content

CGS Federal

PostgreSQL Database Developer

Boston, MA$106.8k–$144.9kfull time hybridmidAdded 1 month ago

About this role

CGS is hiring an experienced PostgreSQL Database Developer in Boston to lead the migration from Oracle to Azure Postgres while ensuring optimal performance and availability of data systems supporting a federal analytics platform. You'll manage database environments, conduct performance tuning, and collaborate across teams to implement scalable solutions.

What you'll do

  • Lead and execute migration from Oracle database to Microsoft Azure Postgres using Ora2Pg tool
  • Monitor database systems proactively to ensure security, performance, and minimal downtime
  • Perform performance tuning and assist developers in optimizing database queries
  • Create and maintain technical documentation and develop in-depth knowledge of business data requirements
  • Manage database maintenance including patching, upgrades, and rollouts
  • Implement and maintain backup and disaster recovery processes for PostgreSQL instances

What they're looking for

  • PostgreSQL administration in Linux environments
  • Oracle to Postgres migration and Ora2Pg tool
  • Database performance tuning and optimization
  • PostgreSQL backup and disaster recovery
  • Azure and/or AWS cloud platforms
  • AWS RDS for PostgreSQL
  • Data warehouse implementation and maintenance
  • Agile development methodologies

Benefits

  • Health, Dental, and Vision insurance
  • Life Insurance
  • 401(k) retirement plan
  • Flexible Spending Accounts
  • Paid Time Off and Federal Holidays
  • Professional growth and learning opportunities
Apply with Autofill

Opens the application — the Jobs AI extension fills it for you. Set up autofill

Opens the official application on the employer’s site. No login required.

CGS Federal

CGS Federal provides workforce development solutions and federal technology services, including training programs, job placement initiatives, and custom software development for government agencies. The company is hiring workforce development professionals in Washington, DC and SharePoint/PowerApps developers in Chicago and Atlanta to support these initiatives.

Website
cgsfederal.com
View all jobs at CGS Federal

Likely interview questions

  • Walk us through your experience migrating databases from Oracle to PostgreSQL. What challenges did you encounter and how did you use the Ora2Pg tool to address them?
  • Describe your experience administrating PostgreSQL databases in Linux environments. What monitoring and maintenance tasks do you perform regularly?
Unlock all 6 questions free — and practice them live →