Skip to main content

CGS Federal

PostgreSQL Database Developer

Charlotte, NC$106.8k–$144.9kfull time hybridmidAdded 1 month ago

About this role

CGS seeks an experienced PostgreSQL Database Developer in Charlotte, NC to lead the migration from Oracle to Azure PostgreSQL and manage database environments for a federal Data Analytics platform. You'll ensure system scalability, performance, and availability while collaborating across teams to implement data solutions.

What you'll do

  • Drive Oracle to Azure PostgreSQL database migration efforts
  • Monitor and maintain database performance, availability, and security with minimal downtime
  • Create and maintain technical documentation and propose effective database solutions
  • Perform performance tuning and assist developers with optimization
  • Implement and maintain backup and disaster recovery processes
  • Conduct database patching, upgrades, and maintenance rollouts

What they're looking for

  • PostgreSQL administration in Linux environments
  • Oracle schema migration using Ora2Pg tool
  • Database backup and disaster recovery implementation
  • Cloud platforms (Azure, AWS)
  • Performance tuning and monitoring
  • Technical documentation
  • Agile development practices
  • AWS RDS for PostgreSQL

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.

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 hands-on experience with the Ora2Pg tool. How have you used it to migrate Oracle schemas, packages, views, and triggers?