Skip to main content

CGS Federal

PostgreSQL Database Developer

Los Angeles, CA$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 database environments for a federal Data Analytics and Business Intelligence platform. You'll ensure system scalability, performance, and high availability while supporting a growing government technology initiative.

What you'll do

  • Drive Oracle to Microsoft Azure PostgreSQL database migration efforts
  • Monitor database systems proactively to maintain security, performance, and minimal downtime
  • Create and maintain technical documentation while developing deep business data knowledge
  • Perform database performance tuning and assist developers with optimization
  • Manage backup, disaster recovery, patching, and upgrade processes
  • Collaborate with internal and external stakeholders to translate technical objectives into requirements

What they're looking for

  • PostgreSQL administration in Linux environments (7+ years)
  • Oracle database experience and schema migration using Ora2Pg tool
  • PostgreSQL backup and disaster recovery implementation
  • Database performance tuning and monitoring
  • AWS RDS for PostgreSQL
  • Cloud platforms (Azure and/or AWS)
  • Data warehouse implementation and maintenance
  • Agile development methodologies

Benefits

  • Health, Dental, and Vision coverage
  • Life Insurance
  • 401(k) with employer contributions
  • Flexible Spending Accounts (Health, Dependent Care, Commuter)
  • Paid Time Off and State/Federal Holiday observance
  • Professional development 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. How would you approach migrating Oracle schemas, packages, views, and triggers to PostgreSQL?
Unlock all 7 questions free — and practice them live →