PostgreSQL Database Developer

Overview:


CGS is seeking a PostgreSQL Database Developer to join our team supporting a rapidly growing Data Analytics and Business Intelligence platform focused on providing data solutions that empower our federal customers. As a PostgreSQL Database Developer, you will play a key role in ensuring the scalability of our data systems and supporting a migration from the current Oracle database to a Postgres database.
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 and 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

Qualifications:

* Bachelor's degree

* Must be a US Citizen

* 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

Benefits:

* Health, Dental, and Vision insurance

* Life Insurance

* 401k

* Flexible Spending Account (Health, Dependent Care, and Commuter)

* Paid Time Off and Observance of State/Federal Holidays