CGS Federal (Contact Government Services)

PostgreSQL Database Developer

CGS Federal (Contact Government Services)

full-time

Posted on:

Origin:  • 🇺🇸 United States • Massachusetts, Pennsylvania

Visit company website
AI Apply
Manual Apply

Salary

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

Job Level

SeniorLead

Tech Stack

AWSAzureCloudLinuxOraclePostgres

About the role

  • Support a migration from Oracle to Postgres (Microsoft Azure Postgres)
  • Manage PostgreSQL database environments proactively and ensure scalability
  • Create and maintain technical documentation using defined templates
  • Collaborate with stakeholders to transform high-level objectives into technical requirements
  • Ensure availability, performance, and resilience of database systems
  • Perform and assist with performance tuning
  • Monitor databases for security and minimal downtime; handle rollouts, patching, and upgrades
  • Work within an Agile development approach to support a Data Analytics and Business Intelligence platform focused on federal customers

Requirements

  • 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
  • Drive efforts to migrate from Oracle to Microsoft Azure Postgres database
  • Create and maintain technical documentation
  • Collaborate with internal and external parties to translate technical objectives into requirements
  • Ensure availability and performance of databases; perform and assist developers in performance tuning
  • Proactively monitor, patch, upgrade, and maintain database systems
  • Work within a structured and Agile development approach
  • (Ideally) Experience implementing and maintaining data warehouses; AWS RDS for PostgreSQL; Oracle databases; cloud environments such as Azure and/or AWS; prior federal consulting experience