PostgreSQL Database Developer with Security Clearance

About the role

CGS is seeking a PostgreSQL Database Developer to support a Data Analytics and Business Intelligence platform. Key responsibilities include migrating from Oracle to Postgres, managing database environments, and ensuring system scalability.

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, and gain an in-depth knowledge of 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 databases supporting systems, allocating sufficient resources for high resilience and speed
• Perform and assist developers in performance tuning
• Proactively monitor database systems to ensure secure services with minimal downtime and improve database maintenance including rollouts, patching, and upgrades
• Create and maintain technical documentation using defined templates, and gain an in-depth knowledge of business data to propose and implement effective solutions

Qualifications

• Bachelor's degree
• Must be US Citizen
• 7 years of experience with 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 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 (ideally)