PostgreSQL Database Developer

About the role

CGS is seeking a PostgreSQL Database Developer to join the Information Technology department on a full‑time, experienced level basis. The role supports a rapidly growing Data Analytics and Business Intelligence platform, driving the migration from an Oracle database to a Microsoft Azure PostgreSQL environment and proactively managing database environments to ensure scalability, availability, and performance for federal customers.

Responsibilities

• Drive efforts to migrate the current Oracle database to a new Microsoft Azure PostgreSQL database.
• Create and maintain technical documentation using defined templates, gaining in‑depth knowledge of business data to propose and implement effective solutions.
• Collaborate with internal and external parties to translate high‑level technical objectives into comprehensive technical requirements.
• Ensure database availability and performance, allocating sufficient resources for high resilience and speed.
• Assist developers with performance tuning of database queries and structures.
• Proactively monitor database systems to provide secure services with minimal downtime, and manage rollouts, patching, and upgrades.
• Set up, monitor, and maintain PostgreSQL instances in Linux environments.
• Implement and maintain PostgreSQL backup and disaster recovery processes.
• Migrate Oracle schema, packages, views, and triggers to PostgreSQL using the Ora2Pg tool.

Qualifications

• Bachelor’s degree.
• U.S. citizenship.
• Minimum 7 years of experience administering PostgreSQL databases in Linux environments.
• Experience setting up, monitoring, and maintaining PostgreSQL instances.
• Experience implementing and maintaining PostgreSQL backup and disaster recovery processes.
• Experience migrating Oracle schemas, packages, views, and triggers to PostgreSQL using the Ora2Pg tool.

Preferred qualifications

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

Benefits

• Health, dental, and vision insurance.
• Life insurance.
• 401(k) retirement plan.
• Flexible Spending Accounts (health, dependent care, and commuter).
• Paid time off and observance of state/federal holidays.

Pay

Salary range: $106,773.33 – $144,906.66 per year.