PostgreSQL Database Developer

CGS Federal (Contact Government Services); Dallas (TX); On-site; USD 106,773 - 144,906; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Accounts

Paid Time Off and Holidays

Job summary

A federal services firm is seeking a PostgreSQL Database Developer in Dallas, TX, to support the migration from Oracle databases to Microsoft Azure Postgres. The ideal candidate should have at least 7 years of experience with PostgreSQL in Linux environments, a Bachelor’s degree, and strong skills in backup solutions and performance tuning. The position offers a competitive salary with comprehensive benefits including health and dental insurance, 401k, and paid time off.

Qualifications

• 7 years of experience administering PostgreSQL databases in Linux environments.
• Experience setting up, monitoring, and maintaining PostgreSQL instances.
• Experience migrating Oracle schemas to PostgreSQL using Ora2Pg.

Responsibilities

• Drive efforts to migrate from Oracle database to Microsoft Azure Postgres.
• Ensure availability and performance of databases with high resilience.
• Collaborate to translate technical objectives into requirements.

Skills

PostgreSQL Administration

Linux Environments

Database Migration

Backup and Disaster Recovery

Education

Bachelor's degree

Tools

Ora2Pg

AWS RDS for PostgreSQL

Azure

Job description

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: https://www.cgsfederal.com or contact: Email: [e-mail]