Skip to main content

CGS Federal

PostgreSQL Database Developer

Fairfax, VA$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 while managing and optimizing database environments for a federal data analytics platform. You'll ensure system scalability, performance, and reliability while collaborating across teams to transform technical requirements into solutions.

What you'll do

  • Lead Oracle to Microsoft Azure Postgres database migration efforts using Ora2Pg tools
  • Monitor database performance and proactively optimize systems for availability and speed
  • Create and maintain technical documentation while gaining deep business data knowledge
  • Perform and assist with database performance tuning and optimization
  • Manage database maintenance including patching, upgrades, and rollouts
  • Implement and maintain backup and disaster recovery processes

What they're looking for

  • PostgreSQL administration in Linux environments
  • Oracle database migration and schema conversion
  • Ora2Pg tool expertise
  • Database performance tuning
  • Backup and disaster recovery implementation
  • Azure and/or AWS cloud platforms
  • AWS RDS for PostgreSQL
  • Data warehouse experience

Benefits

  • Health, Dental, and Vision coverage
  • Life Insurance
  • 401(k) plan
  • Flexible Spending Accounts
  • Paid Time Off and Federal Holiday observance
  • 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 overcome them?
  • Describe your experience using the Ora2Pg tool to migrate Oracle schemas, packages, views, and triggers. What issues have you encountered during migrations?
Unlock all 7 questions free — and practice them live →