PostgreSQL Database Developer

Contact Government Services - Phoenix, AZ

Full-time - Mid Level

Phoenix, AZ

Professional, Scientific, and Technical Services

About the position

CGS is seeking a PostgreSQL Database Developer to support a growing Data Analytics and Business Intelligence platform for federal customers. The role involves migrating from an Oracle database to a PostgreSQL database and managing database environments to ensure scalability and performance. The ideal candidate will contribute to government innovation and collaborate with various stakeholders to implement effective data solutions.

Responsibilities

• Drive efforts to migrate from the current Oracle database to the new Microsoft Azure Postgres database.
• Create and maintain technical documentation using defined templates.
• Collaborate with internal and external parties to transform high-level technical objectives into comprehensive technical requirements.
• Ensure the availability and performance of the databases, allocating sufficient resources for high resilience and speed.
• Perform and assist developers in performance tuning of the databases.
• Proactively monitor database systems to ensure secure services with minimum downtime.
• Improve maintenance of the databases, including rollouts, patching, and upgrades.

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.

Nice-to-haves

• Experience implementing and maintaining data warehouses
• Experience with AWS RDS for PostgreSQL
• Experience with Oracle databases
• Experience leveraging the Ora2Pg tool
• Experience with working in cloud environments such as Azure and/or AWS
• Prior federal consulting experience.

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