PostgreSQL DBA/Developer

Postgres
UNITED STATES
October 27, 2026
Full Time
Apply Now

Job Description

Company: CGH Technologies, Inc.
Location: Remote
Workplace Type: On-site
Employment Type: Full-time
Pay / Compensation: $130K – $145K/year

About the Role

CGH Technologies, Inc. is a business solutions firm specializing in Data Management, Software Engineering, and Business Intelligence. We are seeking a skilled and motivated PostgreSQL Database Administrator / Developer to join our team supporting a federal government customer. This mid-level role sits at the intersection of database operations and application development, requiring a candidate equally comfortable writing advanced SQL, building robust procedural logic, supporting production systems, and working with spatial data using PostGIS.

What You’ll Do / Key Responsibilities

  • Maintain PostgreSQL instances across development, staging, and production environments.
  • Monitor database health, disk usage, query performance, and resource utilization; take corrective action proactively.
  • Maintain replication, high-availability, and failover solutions.
  • Develop complex SQL queries, including CTEs, window functions, and analytical SQL to support application and reporting requirements.
  • Create and maintain stored procedures, functions, triggers, and views using PL/pgSQL.
  • Analyze and resolve performance issues using EXPLAIN/EXPLAIN ANALYZE, pg_stat_* views, and profiling tools.
  • Design and implement indexing strategies, including B-Tree, GiST, GIN, BRIN, partial, and composite indexes.
  • Tune PostgreSQL configuration parameters related to memory, parallelism, vacuuming, and checkpoints.
  • Design and implement spatial schemas using PostGIS, developing spatial queries for proximity searches, buffering, and routing.
  • Familiarity with cloud-hosted PostgreSQL environments, including AWS RDS/Aurora PostgreSQL.

Requirements & Qualifications

  • 7+ years of hands-on PostgreSQL development and administration experience in production environments.
  • Strong proficiency in advanced SQL, including window functions, CTEs, subqueries, set operations, and analytical queries.
  • Solid PL/pgSQL development experience, including stored procedures, functions, triggers, and custom types.
  • Demonstrated PostGIS experience, including spatial schema design, geometry functions, spatial joins, and index optimization.
  • Experience with performance tuning, query plan analysis, indexing strategies, and server-side configuration.
  • Experience working in Linux/Unix environments and scripting in Bash, Python, or similar languages.
  • Familiarity with Docker, Kubernetes, and infrastructure-as-code tools like Terraform and Ansible.

Preferred / Bonus Qualifications (if applicable)

  • Experience with GDAL/OGR, QGIS, or other GIS tools supporting PostGIS workflows.
  • Familiarity with CI/CD practices, database migration frameworks such as Flyway and Liquibase, and version-controlled schema management.
  • Experience working in an Agile/Scrum environment.

Benefits & Perks (if applicable)

  • Comprehensive benefits package including medical, dental, vision, short- and long-term disability insurance, life insurance, commuter benefit, and flexible spending account.
  • 401K, paid holidays, and Paid Time Off (PTO).

CGH is an Equal Opportunity Employer. Candidates selected will be subject to a Government background investigation and must meet eligibility requirements (U.S. Citizen or person with valid U.S. Work Visa who has lived in the U.S. for 3 or more years).

Related Jobs