Filtr uses AI to scan 1000+ jobs and finds postings that perfectly matches your resume

CGS is seeking a PostgreSQL Database Developer to support a rapidly growing Data Analytics and Business Intelligence platform for federal customers, focusing on migrating from Oracle to PostgreSQL and ensuring the scalability of data systems.

Requirements

• 7 years of experience with administrating PostgreSQL Databases in Linux environments
• Experience with setting up, monitoring, and maintaining PostgreSQL instances
• Experience with implementing and maintaining PostgreSQL backup and disaster recovery processes
• Experience migrating Oracle schema, packages, views, triggers to Postgres using Ora2Pg tool
• Experience implementing and maintaining data warehouses
• Experience with AWS RDS for PostgreSQL
• Experience with Oracle databases

Responsibilities

• Drive efforts to migrate from the current Oracle database to the new Microsoft Azure Postgres database
• Create and maintain technical documentation, using defined technical documentation templates, as well as gain an in-depth knowledge of the business data to propose and implement effective solutions
• Collaborate with internal and external parties to transform high-level technical objectives into comprehensive technical requirements
• Ensure the availability and performance of the databases that support our systems, ensuring that they have sufficient resources allocated to support high resilience and speed.
• Perform and assist developers in performance tuning
• Proactively monitor the database systems to ensure secure services with minimum downtime and improve maintenance of the databases to include rollouts, patching, and upgrades
• Create and maintain technical documentation using defined technical documentation templates, as well as gaining an in-depth knowledge of the business data to propose and implement effective solutions

Other

• Must be US Citizenship
• Work within a structured and Agile development approach
• Prior federal consulting experience