PostgreSQL Database Developer

About the role

CGS is seeking a PostgreSQL Database Developer to support a Data Analytics and Business Intelligence platform. The role involves migrating from Oracle to Postgres databases, managing environments, and ensuring system scalability.

Responsibilities

• Drive efforts to migrate from Oracle to Postgres databases
• Create and maintain technical documentation
• Collaborate with internal and external parties to transform technical objectives into technical requirements
• Ensure the availability and performance of databases supporting systems
• Perform and assist in performance tuning
• Proactively monitor database systems
• Create and maintain technical documentation
• Work within a structured and Agile development approach

Qualifications

• Bachelor's degree
• US Citizenship
• 7 years of experience with 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

Preferred Qualifications

• 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
• Life Insurance
• 401k
• Flexible Spending Account (Health, Dependent Care, and Commuter)
• Paid Time Off and Observance of State/Federal Holidays

Pay

$106,773.33 - $144,906.66 annually

Schedule

Full-time