CGS Federal (Contact Government Services)

PostgreSQL Database Developer

CGS Federal (Contact Government Services)

full-time

Posted on:

Origin:  • 🇺🇸 United States • California

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 $106,773 - $144,907 per year

Job Level

SeniorLead

Tech Stack

AWSAzureCloudLinuxOraclePostgres

About the role

  • CGS seeking PostgreSQL Database Developer supporting Data Analytics and Business Intelligence platform for federal customers
  • Support migration from Oracle to Postgres and manage database environments proactively
  • Ensure scalability, availability, and performance of database systems
  • Create and maintain technical documentation and transform high-level objectives into technical requirements
  • Perform/assist in performance tuning, monitoring, backup, disaster recovery, rollouts, patching, and upgrades
  • Work within a structured and Agile development approach

Requirements

  • 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
  • Work within a structured and Agile development approach
  • Bachelor's degree
  • Must be US Citizenship
  • 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
  • Ideally: Experience implementing and maintaining data warehouses
  • Ideally: Experience with AWS RDS for PostgreSQL
  • Ideally: Experience with Oracle databases
  • Ideally: Experience leveraging the Ora2Pg tool
  • Ideally: Experience with working in cloud environments such as Azure and/or AWS
  • Ideally: Prior federal consulting experience