Skip to main content

CGS Federal

PostgreSQL Database Developer

Chicago, IL$106.8k–$144.9kfull time hybridmidAdded 1 month ago

About this role

CGS seeks an experienced PostgreSQL Database Developer to lead the migration from Oracle to Azure Postgres and manage database environments for a federal data analytics platform. You'll ensure system scalability, performance, and reliability while collaborating across teams to implement effective data solutions.

What you'll do

  • Lead Oracle to Microsoft Azure PostgreSQL database migration efforts
  • Monitor and optimize database performance, availability, and resource allocation
  • Create and maintain technical documentation and manage business data requirements
  • Perform performance tuning and assist developers with optimization
  • Implement and maintain backup, disaster recovery, and patching processes
  • Collaborate with internal and external stakeholders to translate technical objectives into requirements

What they're looking for

  • PostgreSQL database administration (7+ years in Linux environments)
  • Oracle schema, packages, views, and triggers migration using Ora2Pg tool
  • PostgreSQL instance setup, monitoring, and maintenance
  • Backup and disaster recovery implementation
  • Cloud environments (Azure and/or AWS preferred)
  • Data warehouse implementation
  • AWS RDS for PostgreSQL
  • Agile development methodologies

Benefits

  • Health, dental, and vision insurance
  • Life insurance
  • 401(k) retirement plan
  • Flexible spending accounts (health, dependent care, commuter)
  • 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 from Oracle to PostgreSQL. What challenges did you encounter, and how did you resolve them?
  • Tell us about your experience with the Ora2Pg tool. How have you used it to migrate Oracle schemas, packages, views, and triggers?
Unlock all 7 questions free — and practice them live →