PostgreSQL DBA/Developer

CGH Technologies, Inc. (CGH) is a business solutions firm, specializing in Data Management, Software Engineering, and Business Intelligence solutions. Located within the Washington corridor, CGH has worked successfully with Government, Commercial and International sectors, providing management consulting, software development and facilities/infrastructure design, maintenance and program management support of large, complex operational environments and facilities security maintenance. CGH has an exciting opportunity for a PostgreSQL DBA/Developer to join the CGH Team.

Purpose

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 who is equally comfortable writing advanced SQL, building robust procedural logic, supporting production systems, and working with spatial data using PostGIS. The ideal candidate brings enthusiasm for database technology, takes initiative, and continuously strives to improve performance, reliability, and data quality.

Responsibilities

• Maintain PostgreSQL instances across development, staging, and production environments.
• Monitor database health, disk usage, query performance, and resource utilization; take corrective action proactively in consultation with senior database personnel.
• 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 and other procedural languages.
• Collaborate with application developers to optimize ORM-generated queries and define effective data models.
• Participate in code reviews for database-facing application code and database schema changes.
• Analyze