PostgreSQL Database Developer

Overview

CGS Federal (Contact Government Services) is seeking a PostgreSQL Database Developer to join our team supporting a rapidly growing Data Analytics and Business Intelligence platform focused on providing data solutions for federal customers. Location: Dallas, TX. You will support a migration from Oracle to PostgreSQL and manage database environments proactively to ensure scalability and performance.

Compensation

Base pay range: $106,773.33/yr - $144,906.66/yr. This range is provided by CGS Federal (Contact Government Services). Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Employment Type: Full Time, Experienced level

Responsibilities

• Drive efforts to migrate from the current Oracle database to the Microsoft Azure Postgres database.
• Create and maintain technical documentation using defined templates, and gain an in-depth knowledge of the 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 the availability and performance of the databases that support our systems, with 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 oversee rollouts, patching, and upgrades.
• Maintain up-to-date technical documentation and leverage business data to propose solutions.
• Work within a structured Agile development approach.

Qualifications

• Bachelor's degree
• Must be a US citizen
• 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 Ora2Pg

Preferred / Ideally you will also have

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

Our Commitment & Benefits

CGS Federal strives to simplify government work by optimizing human, technical, and financial resources. We combine cutting-edge technology with skilled professionals to deliver solutions that meet client needs, and we are committed to honesty, professionalism, and quality work.

• Health, Dental, and Vision
• Life Insurance
• 401k
• Flexible Spending Account (Health, Dependent Care, and Commuter)
• Paid Time Off and Holidays

EEO Statement

CGS Federal is an Equal Opportunity Employer. Applicants will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Join our team and contribute to government innovation.

For more information about CGS please visit: or contact: Email: View email address on click.appcast.io