CGH Technologies, Inc. is hiring a PostgreSQL DBA/Developer to support a federal government customer. This is a remote role focused on keeping PostgreSQL environments reliable and fast while building advanced SQL and PostGIS capabilities that directly support application and reporting needs.
Compensation: $130,000 - $145,000 per year, based on relevant experience and customer parameters. Experience level: 7+ years of hands-on PostgreSQL development and administration in production environments.
Responsibilities
In this role, you will maintain PostgreSQL instances across development, staging, and production, ensuring database health and performance through proactive monitoring and targeted fixes in consultation with senior database personnel.
- 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 using CTEs, window functions, and analytical SQL for 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 for 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 and spatial indexes using PostGIS, including geometry/geography types.
- 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.
- Document schemas, runbooks, and operational procedures to keep documentation current.
Required Qualifications
- 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 experience with 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 and Aurora PostgreSQL.
- Experience with GDAL/OGR and/or QGIS or other GIS tools supporting PostGIS workflows.
- Working knowledge of containerization and orchestration tools such as Docker and Kubernetes, plus infrastructure-as-code tools including Terraform and Ansible.
- Familiarity with CI/CD, database migration frameworks such as Flyway and Liquibase, and version-controlled schema management.
- Experience working in an Agile/Scrum environment.
Additional Requirements
- 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 technical and non-technical stakeholders.
- Self-starter who can identify issues independently and drive resolution.
- Ability to manage multiple priorities and meet deadlines in a fast-paced environment.
- Physical requirements: able to sit, stand, talk, hear, and use a computer/keyboard/mouse for several hours daily; may require occasional light lifting up to 10 pounds.
Benefits
- 401(k) and 401(k) matching
- Health insurance, health savings account, and flexible spending account
- Dental insurance and vision insurance
- Short- and long-term disability insurance
- Life insurance
- Employee assistance program
- Paid time off
- Referral program
- Retirement plan
- Tuition reimbursement
- Commuter benefit
Technology Focus
PostgreSQL, PostGIS, SQL, PL/pgSQL, CTEs, window functions, EXPLAIN/EXPLAIN ANALYZE, pg_stat_* views; indexing including B-Tree, GiST, GIN, BRIN; AWS RDS and Aurora PostgreSQL; Linux/Unix; Bash, Python; GIS tools and formats such as GDAL/OGR, QGIS, Shapefile, GeoJSON, and GML; and tooling including Docker, Kubernetes, Terraform, Ansible, CI/CD, Flyway, and Liquibase.
