CGS Federal
PostgreSQL Database Developer
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 high availability while collaborating across teams in an Agile environment.
What you'll do
- Lead Oracle to Microsoft Azure Postgres database migration using Ora2Pg tool
- Monitor and maintain PostgreSQL instances to ensure performance, security, and minimal downtime
- Implement and manage backup and disaster recovery processes
- Create technical documentation and translate business requirements into technical solutions
- Perform database performance tuning and assist developers with optimization
- Execute patching, upgrades, and maintenance rollouts proactively
What they're looking for
- PostgreSQL database administration in Linux environments
- Oracle to Postgres migration tools (Ora2Pg)
- Database performance tuning and optimization
- Backup and disaster recovery implementation
- Cloud environments (Azure, AWS RDS)
- Data warehouse design and maintenance
- Technical documentation
- 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 State/Federal Holiday observance
- Professional growth and learning opportunities
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
Likely interview questions
- Walk us through your experience migrating databases from Oracle to PostgreSQL. Have you used the Ora2Pg tool, and what challenges did you encounter?
- Describe your approach to setting up and monitoring PostgreSQL instances for high availability and performance in a Linux environment.