CGS Federal (Contact Government Services)

PostgreSQL Database Developer

CGS Federal (Contact Government Services)

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Manual Apply

Salary

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

Job Level

SeniorLead

Tech Stack

AWSAzureCloudLinuxOraclePostgres

About the role

  • Drive efforts to migrate from the current Oracle database to the new Microsoft Azure Postgres database
  • Create and maintain technical documentation using defined templates and gain in-depth knowledge of business data
  • Collaborate with internal and external parties to translate high-level technical objectives into technical requirements
  • Ensure availability and performance of databases; allocate resources for resilience and speed
  • Perform and assist developers in performance tuning
  • Proactively monitor database systems for security and minimum downtime; manage rollouts, patching, and upgrades
  • Work within a structured Agile development approach

Requirements

  • Bachelor's degree
  • Must be US Citizenship
  • 7 years of experience administering 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 (preferred)
  • Experience with AWS RDS for PostgreSQL (preferred)
  • Experience with Oracle databases (preferred)
  • Experience leveraging the Ora2Pg tool (preferred)
  • Experience with cloud environments such as Azure and/or AWS (preferred)
  • Prior federal consulting experience (preferred)