> Markdown version of [/jobs/ext/573434-postgresql-dba-developer](https://www.wearedevelopers.com/jobs/ext/573434-postgresql-dba-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # PostgreSQL DBA/Developer - **Company:** CGH Technologies, Inc. - **Location:** Washington, DC, United States (Remote available) - **Experience:** Expert - **Salary:** $130,000.0 - $150,000.0 - **Contract:** Permanent contract - **Skills:** Query Performance, Geographic Information Systems, Bash Shell, Profiling, Code Review, Databases, Continuous Integration, Database Schema, GIS Applications, Python (Programming Language), PostgreSQL, Liquibase, Microsoft Office, Performance Tuning, PostGIS, Scrum Methodology, Quantum GIS (QGIS), Ansible, Software Engineering, Spatial Data Infrastructures, SQL Stored Procedures, SQL Databases, Scripting, Freeform SQL, Sql Optimization, Database Optimization, Database Migration, Amazon Relational Database Service, Containerization, Infrastructure Automation Frameworks, Information Technology, Geospatial Data Abstraction Library (GDAL), Terraform, Software Version Control, Docker - **Published:** June 17, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=3206f1be1267445f ## About the Role Do you have experience in Version control systems?, Do you have a Bachelor's degree?, Number of Years Experience Required: * 7+ years of hands-on PostgreSQL development and administration experience in production environments. Minimum Education and Certifications Required: * Bachelor's degree in Computer Science, Information Technology, GIS, Engineering, or related field (or equivalent experience) Technical Skills Required: * 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. Computer Skills: * Microsoft Office 365 Other Knowledge, Skills, and Abilities Required: * 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. * While performing the duties of this job, the individual is 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. * The hiring range for this position is $130K - $150K/year based on relevant experience and position requirements as determined by the customer parameters. ## Description 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., * 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. ## Related Videos - [Tracking vehicles at scale](https://www.wearedevelopers.com/videos/1999-tracking-vehicles-at-scale) - [Docker Compose: Rediscovered](https://www.wearedevelopers.com/videos/1978-docker-compose-rediscovered) - [Dev & Test in the Cloud? Deploy your cloud environments with Ansible & Terraform](https://www.wearedevelopers.com/videos/1607-dev-test-in-the-cloud-deploy-your-cloud-environments-with-ansible-terraform) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Docker build without Docker](https://www.wearedevelopers.com/videos/100114-docker-build-without-docker) - [Postgres in the Age of AI (and Devin)](https://www.wearedevelopers.com/videos/1042-postgres-in-the-age-of-ai-and-devin) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Dev Digest 168: Hacking Postgres, Blocking Meta and Fixing CSS](https://www.wearedevelopers.com/magazine/588-dev-digest-168-hacking-postgres-blocking-meta-and-fixing-css) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Backend Developer Salary in Germany [2023]](https://www.wearedevelopers.com/magazine/196-backend-developer-salary-in-germany-2023) - [DevOps Engineer Salary [2023]](https://www.wearedevelopers.com/magazine/203-devops-engineer-salary-2023)