CGS Federal (Contact Government Services)

PostgreSQL Database Developer

CGS Federal (Contact Government Services)

full-time

Posted on:

Origin:  • 🇺🇸 United States • New York

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 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 - Work within a structured and Agile development approach

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