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 Microsoft Azure Postgres database, managing database environments, and ensuring system scalability.

Responsibilities

• Drive efforts to migrate from Oracle to Postgres database
• 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 developers in performance tuning
• Proactively monitor database systems for security and minimal downtime
• Work within a structured and Agile development approach

Qualifications

• Bachelor's degree
• US Citizenship
• 7+ years of experience 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
• Prior federal consulting experience (ideally)

Skills

• 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

Benefits

We offer a comprehensive benefits package including:

• Health, Dental, and Vision insurance
• Life Insurance
• 401(k)
• 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 position