Skip to main content

CGS Federal

PostgreSQL Database Developer

Washington, DC$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 PostgreSQL while managing database environments for a federal analytics platform. You'll ensure system scalability, performance, and high availability while collaborating across teams in an Agile environment.

What you'll do

  • Lead Oracle-to-PostgreSQL database migration using Ora2Pg tool and transform schema, packages, views, and triggers
  • Set up, monitor, and maintain PostgreSQL instances with backup and disaster recovery processes
  • Optimize database performance through tuning and proactive system monitoring to minimize downtime
  • Create and maintain technical documentation while translating business data needs into technical solutions
  • Manage database maintenance including patching, upgrades, and resource allocation for high resilience
  • Collaborate with internal and external stakeholders to define technical requirements and support system scalability

What they're looking for

  • PostgreSQL database administration in Linux environments
  • Oracle database experience and migration expertise
  • Ora2Pg migration tool proficiency
  • Database backup and disaster recovery implementation
  • Cloud platforms (Azure, AWS RDS for PostgreSQL)
  • Database performance tuning
  • Technical documentation
  • Agile development methodologies

Benefits

  • Health, Dental, and Vision insurance
  • Life Insurance and 401(k)
  • Flexible Spending Accounts (Health, Dependent Care, Commuter)
  • Paid Time Off and State/Federal Holiday observance
  • Professional growth and learning opportunities
  • Collaborative, supportive work environment
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 Ora2Pg to handle schema, packages, views, and triggers?
  • Describe your approach to setting up and monitoring PostgreSQL instances in Linux environments to ensure high availability and performance for mission-critical systems.
Unlock all 7 questions free — and practice them live →