PostgreSQL DBA/Developer

CGH Technologies, Inc. • Washington, DC

8d • $130,000 - $150,000 • Onsite

About The Position

CGH Technologies, Inc. (CGH) is seeking a skilled and motivated PostgreSQL Database Administrator / Developer to join their team supporting a federal government customer. This mid-level role requires a candidate comfortable with advanced SQL, procedural logic, production system support, and working with spatial data using PostGIS. The ideal candidate is enthusiastic about database technology, takes initiative, and aims to improve performance, reliability, and data quality.

Requirements

• 7+ years of hands-on PostgreSQL development and administration experience in production environments.
• Bachelor's degree in Computer Science, Information Technology, GIS, Engineering, or related field (or equivalent experience)
• 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 cloud-hosted PostgreSQL environments, including AWS RDS/Aurora PostgreSQL.
• Experience with GDAL/OGR, QGIS, or other GIS tools supporting PostGIS workflows.
• Working knowledge of containerization technologies such as Docker and Kubernetes, and infrastructure-as-code tools including Terraform and Ansible.
• 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.
• Microsoft Office 365
• U.S. Citizen or person with valid U.S. Work Visa who has lived in the U.S. for 3 or more years.
• Strong communication skills with the ability to explain technical concepts to both technical and non-technical stakeholders.
• Self-starter mindset with the ability to identify issues independently and drive them to resolution.
• Works effectively both as a collaborative team member and as a self-directed professional with minimal supervision.
• Demonstrated ability to manage multiple priorities simultaneously, organize workloads efficiently, and meet deadlines in a fast-paced environment.
• Regularly required to sit, stand, talk, hear and use a computer/keyboard/mouse for several hours on a daily basis.
• May require occasional light lifting of up to 10 pounds.

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 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 to optimize workload performance.
• Identify and resolve locking, bloat, and vacuum-related issues, including autovacuum tuning.
• Design and implement spatial schemas, geometry/geography types, and spatial indexes using PostGIS.
• Develop spatial queries for proximity searches, buffering, intersection, routing, and coordinate transformations.
• Load, validate, and maintain spatial datasets from GIS formats such as Shapefile, GeoJSON, and GML.
• Optimize PostGIS query performance, including spatial join strategies and GiST index tuning.
• Proactively identify risks, bottlenecks, and opportunities for improvement.
• Document schemas, runbooks, and operational procedures, ensuring documentation remains current.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level